In this article, we are going to learn how to drop oracle database manually step by step. Perform these steps in UAT first don’t perform on the production database server.
Before taking any action you must know the location of datafile, controlfile and online redo log files. Using the below query you can get the details.
SQL> select name from v$database; <<--- check database name SQL> select name from v$datafile; SQL> select name from v$controlfile; SQL> select member from v$logfile;
Step 1. Make a connection with database as sys user.
$export ORACLE_SID=orcl $sqlplus / as sysdba
Step 2. Shutdown the database.
SQL> shu immediate
Step 3. Start Database in Exclusive mode till mount stage. Start the process to drop oracle database manually.
SQL> startup mount exclusive restrict;
Step 4. Now Drop the Database.
SQL> drop database;
Now your database has been droped successfully.
Note: After drop the database verify the all associated files should be removed from it’s origenal location. Also remove entry from “/etc/oratab”.
Chat with me on: