Manual switchover of RAC database using Data Guard

The following post will provide the list of steps that needs to be performed while performing a manual switchover to DR database when Data guard is configured between these database. These commands are helpful if we are not using broker for switchover operations:

Primary DB -  ERPDB
Standby DB  DERPDB*  

STEP1:(ERPDB)

srvctl status database -d ERPDB
srvctl stop instance  -d ERPDB  -i ERPDB2 -o immediate
srvctl status database -d ERPDB

STEP2: (DERPDB)

srvctl status database -d DERPDB
srvctl stop instance  -d DERPDB  -i DERPDB1 -o immediate
srvctl status database -d DERPDB

STEP3:(ERPDB)

SELECT  NAME,DB_UNIQUE_NAME,DATABASE_ROLE,SWITCHOVER_STATUS FROM V$DATABASE;

STEP4:(DERPDB)

SELECT  NAME,DB_UNIQUE_NAME,DATABASE_ROLE,SWITCHOVER_STATUS FROM V$DATABASE;

STEP5:(ERPDB) - Convert ERPDB to Physical standby database

ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;

AT this stage DERPDB will become primary and ERPDB will be standby



STEP 6: (DERPDB)

ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN ;
SHUTDOWN IMMEDIATE;
STARTUP OPEN;

STEP 7: (ERPDB)

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;

STEP 8: (ERPDB)

SELECT NAME, DATABASE_ROLE,OPEN_MODE,SWITCHOVER_STATUS FROM V$DATABASE;
SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY where process = 'MRP0' ;

Hope Its helps  :)

Thanks for reading.

regards,
X A H E E R