Monday, 13 February 2017

DROP Database in RAC

Steps to drop database

srvctl stop database -d TEST

sqlplus / as sysdba

SQL>startup nomount

SQL> alter system set cluster_database=FALSE scope=spfile sid='*';

SQL> shutdown abort;

SQL> startup mount exclusive restrict

SQL>  select logins,parallel from v$instance;

SQL> drop database;



Or

SQL> alter system set cluster_database=FALSE scope=spfile sid='*';

srvctl stop database -d TEST

SQL> startup mount exclusive restrict

SQL>  select logins,parallel from v$instance;

SQL> drop database;


No comments:

Post a Comment