使用rman drop database
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;
使用sqlplus drop database
SQL> shutdown immediate;
SQL> startup mount
SQL> alter system enable restricted session;
sql> drop database;
使用rman可以在删除database的时候同时删除备份,sqlplus的话则只能删除数据库