Dataguard question

[lulon]

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!

[davey23uk]

make sure your tns entries are correct and your loag archive dest parameters use the corrrect entries

[lulon]

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)
)
)

[lulon]

What else should I check apart from this configuration?