Thursday, April 2, 2015

Enable Real Time Query in Oracle Data Guard

I have a physical standby database called stdby. I am going to enable real time query on it:

1. export ORACLE_SID=stdby
2. sqlplus / as sysdba
3. alter database recover managed standby database cancel;
4. alter database open;
5. alter database recover managed standby database using current logfile disconnect;


To disable real time query:

1. export ORACLE_SID=stdby
2. sqlplus / as sysdba
3. shutdown immediate
4. startup mount
5. alter database recover managed standby database disconnect;

No comments:

Post a Comment