-
Standby receiving redo logs although the log_archive_dest_n were wronly...
Hi,
The Primary site has two servers, each with one instance, using RAC.
The Standby site has another two servers and two instances using also RAC.
This is a logical Standby database, the Dataguard is working fine and the data is being replicated.
This is the configuration of the second instance of the Standby site (Server1b)
SQL> show parameter arch
NAME TYPE VALUE
============================================================
archive_lag_target integer 0
log_archive_config string dg_config=(DB_S1, DB_S2)
log_archive_dest string
log_archive_dest_1 string LOCATION=+DB_ARCHIVE/DB/ VALID_FOR=(ONLINE_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=DB_S1
log_archive_dest_5 string service="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=xxxx)))(CONNECT_DATA=( SERVICE_NAME=DB_S2_XPT)(INSTANCE_NAME=DB1)(SERVER=dedicated)))", LGWR NOAFFIRM delay=0 OPTIONALmax_failure=0 reopen=10 async=61440 db_unique_name="DB_S2" register nonet_timeout valid_for=(online_logfile,primary_role)
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_2 string ENABLE
log_archive_dest_state_3 string enable
log_archive_dest_state_4 string ALTERNATE
log_archive_dest_state_5 string ENABLE
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
log_archive_duplex_dest string
log_archive_format string %t_%s_%r.dbf
log_archive_local_first boolean TRUE
log_archive_max_processes integer 10
log_archive_min_succeed_dest integer 1
log_archive_start boolean FALSE
log_archive_trace integer 0
remote_archive_enable string true
standby_archive_dest string
SQL>
ID DESTINATION STATUS TARGET SCHEDULE PROCESS MID
================================================================
1 +DB_ARCHIVE/db/ VALID PRIMARY ACTIVE ARCH 0
2 INACTIVE PRIMARY INACTIVE ARCH 0
3 INACTIVE PRIMARY INACTIVE ARCH 0
4 INACTIVE PRIMARY INACTIVE ARCH 0
5 (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=xxxx)))(CONNECT_DATA=( SERVICE_NAME=DB_S2_XPT)(INSTANCE_NAME=DB1)(SERVER=dedicated)))
VALID VALID STANDBY PENDING LGWR 0
6 INACTIVE PRIMARY INACTIVE ARCH 0
7 INACTIVE PRIMARY INACTIVE ARCH 0
8 INACTIVE PRIMARY INACTIVE ARCH 0
9 INACTIVE PRIMARY INACTIVE ARCH 0
10 INACTIVE PRIMARY INACTIVE ARCH 0
11 /opt/oracle/product/10.1.0/db_1/dbs VALID STANDBY ACTIVE RFS 0/arch
Here the configuration does not make sense at all. So, how is it possible that this Server (Server1b) is receiving redo logs from the Primary site?
Thank you.
Last edited by lulon; 10-22-2009 at 03:45 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|