set up data guard cascade ??
- From: dba1 mcc <mccdba1@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sat, 11 Sep 2010 09:53:51 -0700 (PDT)
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?
--
//www.freelists.org/webpage/oracle-l
Other related posts:
