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;
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;
SQL> select logins,parallel from v$instance;
SQL> drop database;
No comments:
Post a Comment