Oracle 12c-Step by Step Manual 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.

Login in to Standby Server:-

Step:1 Check the database role and open_mode


select name,open_mode,database_role from v$database;

Step:2 Cancel the MRP process

alter database recover managed standby database cancel;

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

alter database recover managed standby database finish;

Step 3:

alter database activate standby database;

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

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

shutdown immediate;

Startup

Step 6:

select name,open_mode,database_role from v$database;

Note:

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

The original primary database can now be configured as a standby. If Flashback Database was enabled on the primary database.If not, the whole setup process must be followed, but this time using the original primary server as the standby.

Related posts

How to deal with ORA-00020: maximum number of processes (%s) exceeded

How to resolve ORA-01111 ORA-01110 ORA-01157 in a physical standby database 

Công cụ tự động khai báo datafile – Oracle