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.
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;
name,open_mode,database_role from v$database;
Step:2
alter
database recover managed standby database cancel;
database recover managed standby database cancel;
Step:3
alter
database recover managed standby database finish;
database recover managed standby database finish;
Step:4
alter
database activate standby database;
database activate standby database;
Step:5
shutdown
immediate;
immediate;
Step:6
Startup
Step:7
select
name,open_mode,database_role from v$database;
name,open_mode,database_role from v$database;
Recent Posts