DROP DATABASE

Say if you have to drop the database, this can be carried out if the database is registed with RMAN.
Easy steps.

Verify the Database.

export ORACLE_SID=khan
$ sqlplus / as sysdba
SQL> startup
SQL>  select name from v$datafile;
SQL> select member from v$logfile;
SQL> select name from v$controlfile;
SQL> select name , open_mode , log_mode from v$database;
SQL> shutdown immediate;

On RMAN CONSOLE**

Connect to RMAN

$ORACLE_HOME/bin/rman catalog=rcat_testdb_khant/rcat@rman
RMAN> connect target/
RMAN> startup force mount
RMAN> SQL 'ALTER SYSTEM ENABLE RESTRICTED SESSION';
sql statement: ALTER SYSTEM ENABLE RESTRICTED SESSION

RMAN> DROP DATABASE INCLUDING BACKUPS NOPROMPT;


This drops the database and backups and unregister the database from catalog Database.