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;
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