Pages

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;

 --


Posted by at
Labels: , ,

3 comments:

  1. UnknownDecember 18, 2017 at 4:37 AM

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

    ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DELAY 30 DISCONNECT FROM SESSION


    ERROR at line 1:
    ORA-00274: illegal recovery option DELAY

    ReplyDelete
  2. Amar NandanJanuary 31, 2022 at 9:07 AM

    alter system set log_archive_dest_2='SERVICE=pegadevstby async noaffirm valid_for=(online_logfiles,all_roles) DELAY=60 DB_UNIQUE_NAME=pegadevstby';

    ReplyDelete

Subscribe to: Post Comments (Atom)