1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Dataguard. Standby configuration question.

Discussion in 'General' started by lulon, Oct 24, 2009.

  1. lulon

    lulon Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    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)(PO
    RT=xxxx)))(CONNECT_DATA=(SERVICE_NAME=DB_S2_XPT)(INSTANCE_NAME=DB1)(SERVER=dedica
    ted)))", 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=xx
    xx)))(CONNECT_DATA=(SERVICE_NAME=DB_S2_XPT)(INSTANCE_NAME=DB1)(SERVER=dedicated))
    ) 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.