Oracle 12c-Step by Step Manual Data Guard Failover

Oracle 12c-Step by Step Manual Data Guard Failover

Details	Primary Side	Standby Side
Server Name	Primary	Standby
DB Name	Warangal	Mumbai
IP Adresses	192.168.182.128	192.168.182.129

Ø Check the database role and open_mode

Ø Cancel the MRP process

Ø The below commands will help to bring up standby as primary

Ø alter database activate standby database;

Ø Bounce your database and verify database name its open mode and its role.

Ø Check the database role and open_mode

Login in to Standby Server:-

1.    Check the database role and open_mode

Select name,open_mode,database_role from v$database;

2.    Cancel the MRP process

alter database recover managed standby database cancel;

3.    The below commands will help to bring up standby as primary

4.    alter database activate standby database;

5.    Bounce your database and verify database name its open mode and its role.

shutdown immediate;

Startup

6.    select name,open_mode,database_role from v$database;

After failover activity,

Details	Primary Side	Standby Side
Server Name	Primary	Primary
DB Name	Warangal	Mumbai
IP Adresses	192.168.182.128	192.168.182.129