Pages

Showing posts with label to delayed apply. Show all posts
Showing posts with label to delayed apply. Show all posts

Monday, January 7, 2013

how to change data guard real time apply to delayed apply



########## ON STANDBY: Real time Apply to Delayed apply ##########


SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DELAY 30 DISCONNECT FROM SESSION;




########## ON STANDBY: Revoking delayed apply to No delay apply #######

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE NODELAY DISCONNECT FROM SESSION;

--