Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

N/w configuration for DR Dataabses

JhilFeb 26 2020 — edited Feb 27 2020

Experts,

Primary is 2 node RAC and Standby is 2 node RAC

On Primary DB, Log_dest_2 is configured as given below

log_archive_dest_2                   string      service="(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=XX.XX.XX.XX)(PORT=1521))

                                                 (CONNECT_DATA=(SERVICE_NAME=XXXXX)(SERVER=DEDICATED)))", ASYNC NOAFFIRM

                                                 delay=0 optional compression=disable max_failure=0     

                                                  max_connections=1 reopen=300 db_unique_name="XXXXX" net_timeout=30,

                                                  valid_for=(online_logfile,all_roles)

When I checked tnsnames.ora file on Primary DB Server,  I do not any find any entry related to corresponding SERVICE_NAME or HOST IP.

If so, how archives are moving to Standby site ? I am in confusion.

DB & GRID Versions are 12.2
This post has been answered by AndrewSayer on Feb 27 2020
Jump to Answer

Comments

Post Details

Added on Feb 26 2020
#general-database-discussions
4 comments
108 views