💡 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.
