If drop database command is run under RMAN then it will drop datafiles, online redo logs ,controlfiles , backups and also unregister database from recovery catalog. Only thing I noticed that was left unclean was flashback logs that has to be deleted manually.
In order to drop database within RMAN, make sure that database is in mount state and in restrictive mode.
RMAN> CONNECT TARGET /
connected to target database: TESTDB1 (DBID=39523451)
RMAN> STARTUP FORCE MOUNT
RMAN> SQL 'ALTER SYSTEM ENABLE RESTRICTED SESSION';
RMAN> DROP DATABASE INCLUDING BACKUPS NOPROMPT;
NOPROMPT will not ask for confirmation so if you want to be sure then use
RMAN> DROP DATABASE INCLUDING BACKUPS;
Above command will use controlfile of the database so in order to user catalog use
RMAN > CONNECT TARGET SYS@TESTDB CATALOG RMAN@RMANCAT
In order to drop database within RMAN, make sure that database is in mount state and in restrictive mode.
RMAN> CONNECT TARGET /
connected to target database: TESTDB1 (DBID=39523451)
RMAN> STARTUP FORCE MOUNT
RMAN> SQL 'ALTER SYSTEM ENABLE RESTRICTED SESSION';
RMAN> DROP DATABASE INCLUDING BACKUPS NOPROMPT;
NOPROMPT will not ask for confirmation so if you want to be sure then use
RMAN> DROP DATABASE INCLUDING BACKUPS;
Above command will use controlfile of the database so in order to user catalog use
RMAN > CONNECT TARGET SYS@TESTDB CATALOG RMAN@RMANCAT
No comments:
Post a Comment