Standby receiving redo logs although the log_archive_dest_n were wronly...
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 1 of 1

Thread: Standby receiving redo logs although the log_archive_dest_n were wronly...

  1. #1
    Join Date
    Jun 2009
    Posts
    40

    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
  •  



Click Here to Expand Forum to Full Width