Activate Standby Database when the Primary Database is not available

Activate Standby Database when the Primary Database is not available

My Primary database is not accessible and server is crashed so we can open the standby database for use.

Steps:

 
1. Start the standby database in mount stage

shut immediate;

startup mount;

2. Check the standby database protection_mode and database_role

SQL> SELECT OPEN_MODE,PROTECTION_MODE,DATABASE_ROLE FROM V$DATABASE;

OPEN_MODE PROTECTION_MODE DATABASE_ROLE

---------- -------------------- ----------------

MOUNTED MAXIMUM PERFORMANCE PHYSICAL STANDBY

NOTE: If protection_mode is other than maximum performance, then alter it as below.

SQL> ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE;

3. Recover standby database

SQL> RECOVER STANDBY DATABASE;

Make sure all archives has been applied in this process and Put CANCEL

4. Finish the recovery process on standby

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH;

Database altered

5. Activate the standby database:

SQL> ALTER DATABASE ACTIVATE PHYSICAL STANDBY DATABASE;

Database altered.

6. Check the status 

SQL> SELECT OPEN_MODE,PROTECTION_MODE,DATABASE_ROLE FROM V$DATABASE;

OPEN_MODE PROTECTION_MODE DATABASE_ROLE

---------- -------------------- ----------------

MOUNTED MAXIMUM PERFORMANCE PRIMARY

7. Open the database

SQL> ALTER DATABASE OPEN;

If you like please follow and comment