service definition for primary RAC cluster to RAC physical standby 19c
service definition for primary RAC cluster to RAC physical standby 19c
when defining a service in log_archive_dest on the a primary RAC cluster should you specify a service that connects to a specific instance of a RAC standby , or can you use a service that connects to any instance.
i.e. which one of these is correct
STANDBY_SCAN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = standby-scan.domain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = standby.domain)
)
)
STANDBY_VIP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = standby_HOST1-vip.domain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = standby.domain)
(INSTANCE_NAME = standby_1)