Sometimes we need to drop the unusable oracle database from the server to free up the resources. So in this article, we are going to learn step by step how to drop database manually in oracle.
Pre-requisites:
Before the drop, must be sure about the database which you want to drop, then find below details of the database.
- Controlfile Location
- Datafile Location
- Online Redo Log Location
We will be cross verify the file after it the dropped, using the following queries.
SQL> select name from v$controlfile;
SQL> select name from v$datafile;
SQL> select member from v$logfile;

Steps to Drop Database manually.
Follow the below steps carefully.
Step 1: Login in Database as sysuser
$ export ORACLE_SID=ocp
$ sqlplus sys/pass as sysdba
Step 2: Shutdown the Database
SQL> shu immediate;
Step 3: Mount Database in restrict mode
SQL> startup mount exclusive restrict;
Step 4: Drop the Database
SQL> drop database;
After dropping the database you must verify the physical locations and remove the related directories also disable the cronjobs. drop database including contents and datafiles.
Read More:
- Resolve error in invoking target agent nmhs of makefile
- Purge RECYCLEBIN in Oracle
- How to get tablespace DDL in oracle
- How to create tablespace in Oracle
- Switchover steps in Oracle 11G, 12c, 19c
-
How do I manually drop a database?
Using the above commands you can drop the database.
-
How do I delete a database without Dbca?
The manual method you can use to drop the database, read the above article.
-
How do I drop a database in Windows?
The same manual method you can use in the windows platforms.
- Resolve error in invoking target agent nmhs of makefile
- Purge RECYCLEBIN in Oracle
- How to get tablespace DDL in oracle
- How to create tablespace in Oracle
- Switchover steps in Oracle 11G, 12c, 19c
- Run Expdp Jobs in Background
Nice article dear oraclerider.com thanks for sharing