Tuesday, September 13, 2016
Step by Step Failover Datagurd
In case of our bad situation with data guard primary database, or not available for production than we can activated standby database as a primary production database.
Select name,open_mode,database_role from v$database;
alter database recover managed standby database cancel;
alter database recover managed standby database finish;
alter database activate standby database;
select name,open_mode,database_role from v$database;