Oracle 11g Physical standby data Guard Failover steps – Active Data Guard Part-V

Oracle 11g Physical standby data Guard Failover:

In case of worst situation with data guard primary database, or not available for production than we can activated standby database as a primary production database.

Previously, we have covered: how to apply primary database redo information to standby database while standby database is in read only mode – Active Data guard feature – Data Guard Part-IV

Lets consider above scenario and bring standby database up as a primary database:
Verify database name its open mode and its role from following SQL command:

SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
RTS MOUNTED PHYSICAL STANDBY

Following sort of SQL command will help to bring up standby as primary:

SQL> alter database recover managed standby database finish;
Database altered.
SQL> alter database activate standby database;
Database altered.

Managed recovery process has been stopped between primary and standby database and standby becomes primary database.

Bounce your database and verify database name its open mode and its role:

SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1469792256 bytes
Fixed Size 2213456 bytes
Variable Size 905972144 bytes
Database Buffers 553648128 bytes
Redo Buffers 7958528 bytes
Database mounted.
Database opened.
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
RTS READ WRITE PRIMARY

Note:

Now your old standby database is become primary database, it is highly recommended to consider immediate full backup of primary database.

After primary database available, you need to switch role between standby to primary database:

Stay Tune. 🙂

Leave a Reply