Monday, 9 June 2014

Drop database for RAC and NON RAC

Drop database for non-Rac Database for cloning.

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: