Printable View
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!
make sure your tns entries are correct and your loag archive dest parameters use the corrrect entries
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)
)
)
What else should I check apart from this configuration?