Drop DATABASE in SQL and RMAN
############# SQL ##############
startup mount exclusive restrict;
drop database;
exit
############# RMAN ###############
RMAN> CONNECT TARGET SYS@test1
target database Password: password
connected to target database: TEST1 (DBID=39525561)
RMAN> STARTUP FORCE MOUNT
RMAN> SQL 'ALTER SYSTEM ENABLE RESTRICTED SESSION';
RMAN> DROP DATABASE INCLUDING BACKUPS NOPROMPT;
RMAN> exit
No comments:
Post a Comment