Tag Archives: Oracle RAC drop

How to drop a RAC database manually

As we’re all used since the advent of the “new” command “drop database” on oracle, that sometimes, for a clean and total remove of oracle’s database it’s used. But if you try just use on a RAC environment, it’s necessary a little trick.

The steps are:

1) on cluster (or on the instance it self) do a:

srvctl stop database -d <databasename>

2) startup on restrict mode:

sqlplus / as sysdba

startup mount restrict exclusive;

3) The Trick !!! Change the parameter CLUSTER_DATABASE to false!!!

alter system set cluster_database=false scope=spfile;

4) restart it again restricted:

shutdown immediate;
startup mount restricted exclusive;

5) Finally: drop database !!! (becareful, it has no rollback!!!)

drop database;

6) Done !

Cheers!

Optimization WordPress Plugins & Solutions by W3 EDGE