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

Get Oracle Data Guard 11gR2 Administration Beginner's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial