DROP A DATABASE USING SQLPLUS OR RMAN COMMAND PROMPT

DROP A DATABASE USING SQLPLUS COMMAND

Please find the steps to drop a cluster database using a SQLPLUS command prompt or RMAN command prompt.

I have a 4 node cluster and i am going to drop the database in the cluster environment. We need to make the cluster_database parameter to false and mount the database in the restrict mode.

STEP#1

Shutdown the cluster database by issuing

$ srvctl stop database -d BHUVAN

STEP#2

Mount one instance in the restrict mode in Oracle 10g (if it is oracle 11g, we can drop the database in the normal mode itself)

SQL> STARTUP MOUNT RESTRICT;

$ rman target /

RMAN> DROP DATABASE INCLUDING BACKUPS NOPROMPT; 

I am using RMAN to drop all the database files including the backup which are taken for this database.

SQL> DROP DATABASE;

You can issue the above command, if there is no backup to clean on the disk or tape. This command will drop all the Datafiles; redo log files, control files, spfile

Note: when we specify “NO PROMPT” in the RMAN prompt, Oracle won’t ask for any confirmation before dropping the database & backup.