active data guard standby in read only with apply mode
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;