Opening standby for read only AND read/write

on August 27, 2008 at 2:04 pm
Posted In: Oracle Data Guard Notes (Cat)

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

ALTER DATABASE OPEN;

 

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

OR to enable real-time apply, include the USING CURRENT LOGFILE clause:

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE;

 

Â