This discussion is archived
10 Replies Latest reply: Dec 13, 2012 7:33 AM by jason_goucf RSS

How to disable REAL TIME QUERY in DG 11gr2 ?

SamTrashers Newbie
Currently Being Moderated

With 11gr2, by default, on STARTUP, the standby database is open
-> in READ ONLY mode
-> with Intended State: APPLY-ON

so the ACTIVE DATAGUARD option is in use ....

is there a way to deactivate REAL TIME QUERY permanently,
so whether on STARTUP or STARTUP MOUNT, the standby stay only mounted with Intended State: APPLY-ON

The only way i found is to do the following :

SQL> startup
DGMGRL> edit database 'PHNXENT' set state='APPLY-OFF';

SQL> startup mount
DGMGRL> edit database 'PHNXENT' set state='APPLY-ON';

but this can leads to mistake ....



  • Correct Answers - 10 points
  • Helpful Answers - 5 points