How to drop database manually without using DBCA in Oracle database 11gR2
Posted by Mir Sayeed Hassan on February 10th, 2019
How to drop database manually without using DBCA in Oracle database 11gR2
Database status:
sys@TESTDB> select instance_name,status,version from V$instance; INSTANCE_NAME STATUS VERSION ---------------- ------------ ----------------- testdb OPEN 11.2.0.4.0
It’s recommended to take the backup of full database for future reference.
Shutdown the database:
sys@TESTDB> shu immediate Database closed. Database dismounted. ORACLE instance shut down.
Startup the database in mount mode with exclusive restrict:
sys@TESTDB> startup mount exclusive restrict; ORACLE instance started. Total System Global Area 2455228416 bytes Fixed Size 2255712 bytes Variable Size 1845494944 bytes Database Buffers 587202560 bytes Redo Buffers 20275200 bytes Database mounted.
sys@TESTDB> select open_mode,name from v$database; OPEN_MODE NAME ------------------------------------- MOUNTED TESTDB
Now drop the database, this will drop entire database with datafiles, control files and log files and respective files in it
sys@TESTDB> drop database; Database dropped. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
===========Hence tested & verified in our test env============