How to Drop a Database using RMAN

 The following Steps will Drop your DATABASE using RMAN

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.