Dataguard question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Dataguard question

  1. #1
    Join Date
    Jun 2009
    Posts
    40

    Dataguard question

    Hello,

    It is a logical Standby database with the following scenario:

    - Primary site with two servers as RAC.
    - Standby site with two servers as RAC.
    - Both Primary servers send the redo logs to the 1st server of the Standby site.
    - 1st server of the Standby receives the redo logs and applies them.

    How can I check that, if the 1st server of the Standby fails, then the two Primary servers will send the redo logs to the 2nd server of the Standby?

    Thank you!

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    make sure your tns entries are correct and your loag archive dest parameters use the corrrect entries

  3. #3
    Join Date
    Jun 2009
    Posts
    40
    This is what I have for example in the 1st server of the Primary:

    - In log_archive_dest:

    log_archive_dest_2 string
    service="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=[IP_oracle_1st_server_Standby])(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=DB_S1_XPT)(INSTANCE_NAME=DB1)(SERVER=dedicated)))", LGWR NOAFFIRM delay=0 OPTIONAL max_failure=0 reopen=10 async=61440 db_unique_name="DB_S1" register nonet_timeout valid_for=(online_logfile,primary_role)


    - In tnsnames.ora of the 1st server of Primary:

    DB_S1 =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = [IP_1st_server_Standby])(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = [IP_2nd_server_Standby])(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = DB_S1_DGMGRL)
    )
    )

    DB_S1_1=
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = [IP_1st_server_Standby])(PORT = 1526))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SID = DB1)
    )
    )

    DB_S1_2=
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = [IP_2nd_server_Satndby])(PORT = 1526))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SID = DB2)
    )
    )
    Last edited by lulon; 11-03-2009 at 12:33 PM.

  4. #4
    Join Date
    Jun 2009
    Posts
    40
    What else should I check apart from this configuration?

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