O'Reilly logo

Oracle Data Guard 11gR2 Administration Beginner's Guide by Nassyam Basha, Emre Baransel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Time for action – cascade standby database

Perform the following steps for a cascade standby database:

  1. Verify whether each destination's status is valid or not from v$archive_dest as follows:
    ID STATUS    DB_MODE         TYPE RECOVERY_MODE           PROTECTION_MODE      SRLs ACTIVE   ARCHIVED_SEQ#
    --- --------- --------------- ---- ----------------------- -------------------- ---- ------ ---------------
      1 VALID     OPEN            ARCH IDLE                    MAXIMUM PERFORMANCE     0      0             731
      2 VALID     OPEN_READ-ONLY  LGWR MANAGED REAL TIME APPLY MAXIMUM PERFORMANCE     6      1             731
      3 VALID     OPEN_READ-ONLY  LGWR MANAGED REAL TIME APPLY MAXIMUM PERFORMANCE     6      1             731

    All remote destinations are using real-time apply with read only for reporting purpose in the Maximum Performance mode. It is to ensure that the standby database has ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required