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.
Shutdown the cluster database by issuing
$ srvctl stop database -d BHUVAN
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.