DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




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.

Step:1
Select name,open_mode,database_role from v$database;

Step:2
alter database recover managed standby database cancel;

Step:3
alter database recover managed standby database finish;

Step:4
alter database activate standby database;

Step:5
shutdown immediate;

Step:6
Startup

Step:7

select name,open_mode,database_role from v$database;

No comments: