Wednesday, April 23, 2014

DROP DATABASE

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