To know what are the files will be droped.
select name from v$datafile;
select member from v$logfile;
select name from v$controlfile;
in SQL>
SQL> shutdown abort;
SQL> startup mount exclusive restrict;
SQL> DROP DATABASE; -- to delete datafile,logfile and controlfile.
RMAN> DROP DATABASE INCLUDING BACKUPS; -- Will delete archivelogs and backup pieces.
Drop database for FOR RAC Database for cloning
srvctl stop database -d <DB NAME> -o abort
from one node
sqlplus "/as sysdba"
SQL>alter system set cluster_database=false scope=spfile sid='*';
SQL> shutdown abort;
SQL> startup mount exclusive restrict;
SQL> DROP DATABASE; -- to delete datafile,logfile and controlfile.
RMAN> DROP DATABASE INCLUDING BACKUPS; -- Will delete archivelogs and backup pieces.
No comments:
Post a Comment