Database Administration (MOSC)

MOSC Banner

active data guard standby in read only with apply mode

edited May 21, 2013 5:37AM in Database Administration (MOSC) 2 commentsAnswered
Hello 

I am going to perform a switchover on a 11.2.0.3 RAC database. As part of the switchover I am going to start up the standby in readonly with apply mode.

I plan to first shutdwon the primary  DB.
srvctl stop database -d DB1

then start up one instance

 

srvctl start instance -d DB1 -i DB11

 

than switch that instance to standby

 

alter database commit to switchover to physical standby with session shutdown;

shutdown immediate;

exit

 

then start that instance in read only mode

 

sqlplus / as sysdba

STARTUP NOMOUNT;

ALTER DATABASE MOUNT STANDBY DATABASE;

alter database open readonly;

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center