set up data guard cascade ??

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Sat, 11 Sep 2010 09:53:51 -0700 (PDT)
Message-ID: <441458.46688.qm_at_web120520.mail.ne1.yahoo.com>

I plan to setup DG whcih can perform archive log cascade on 11GR2 LINUX system.

what I plan to do is :

primary DB ==> standby 1 ==> standby 2 (casecde)

since "standby 2" on WAN , I don't want archivelog (redo log) from Primary database.

Currently my setup work only from Primary database to "standby 1". "standby 1" did NOT push archive log to "standby 2".

I list my init.ora file setup for you to reference:

primary DB: (PRMDB)

---

*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(PRMDB,STBY1DB)'
*.log_archive_dest_1='LOCATION=/backup/Archive/PRMDB/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=PRMDB REOPEN=60'
*.log_archive_dest_2='SERVICE=STBY1DB lgwr async VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=STBY1DB'
*.LOG_ARCHIVE_DEST_STATE_1=ENABLE
*.LOG_ARCHIVE_DEST_STATE_2=ENABLE
Stabdby 1 (STBY1DB)

---

*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(STBY1DB,STBY2DB,PRMDB)'
*.log_archive_dest_1='LOCATION=/backup/Archive/PRMDB/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=STBY1DB REOPEN=60'
*.log_archive_dest_2='SERVICE=PRMDB lgwr async VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PRMDB'
*.log_archive_dest_3='SERVICE=STBY2DB lgwr async VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=STBY2DB'
*.LOG_ARCHIVE_DEST_STATE_1=ENABLE
*.LOG_ARCHIVE_DEST_STATE_2=ENABLE
*.LOG_ARCHIVE_DEST_STATE_3=ENABLE
SQL> SELECT DEST_ID "ID",

      STATUS "DB_status",
      DESTINATION "Archive_dest",
      ERROR "Error"
      FROM V$ARCHIVE_DEST;
   
        ID DB_status Archive_dest                             Error
---------- --------- ---------------------------------------- -----------------------------------------------------------------
         1 VALID     /backup/Archive/PRMDB/arch
         2 VALID     PRMDB
         3 VALID     STBY2DB

Stabdby 2 (STBY2DB)

---

*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(PRMDB,STBY2DB)'
*.log_archive_dest_1='LOCATION=/backup/Archive/PRMDB/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=STBY2DB REOPEN=60'
*.log_archive_dest_2='SERVICE=PRMDB lgwr async VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PRMDB'
*.LOG_ARCHIVE_DEST_STATE_1=ENABLE
*.LOG_ARCHIVE_DEST_STATE_2=ENABLE
any ideal why?       

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Sep 11 2010 - 11:53:51 CDT