Posts Tagged ‘rac database drop’

Drop database in 11gR2 RAC & Updating OCR

July 24, 2013 Leave a comment

1. Login as oracle user and stop the database

srvctl stop database -d racdb


2. Start the first instance in mount state

srvctl start instance -d racdb -i racdb1


3. Set CLUSTER_DATABASE=FALSE and shut it down

alter system set cluster_database=false scope=spfile sid=’*’

shut immediate


4. Start the database in restrict mode

startup exclusive restrict mount

drop database;


To remove archivelogs and backups

RMAN> drop database including backups;


Updating OCR

Issue below commands to update OCR

srvctl remove database -d racdb


If there is any issue in removing database details from OCR due to unknown state, remove the resource using crsctl

crsctl delete resource ora.racdb.db

Categories: RAC Tags: ,
Oracle database internals by Riyaj

Discussions about Oracle performance tuning, RAC, Oracle internal & E-business suite.


Where all the Action Is !!!!

Pavan DBA's Blog

The DBA Knowledge Store

ORACLE-BASE - Latest Articles

Where all the Action Is !!!!