Hi guru's,
I have a question regarding to tnsnames entries in a rac dataguard soluiton with policy maneged databases involved.
We have a rac (11.2.0.4) with multiple databases. Now we want to build a dr-rac with dataguard between these two rac systems (both 3 nodes).
But our databases are policy managed so instance names can change. Is it really needed to name every instance name like below in the the local tnsnames file and what if the change update al the entries ? and how show datagaurd broker entries looklike ? (I can't find documentation/info about dataguard/rac/policy-maneged configurations).
I hope somebody has info about this,
thanks in adv !
tnsnames config example one every node.;
test =
(DESCRIPTION = (LOAD_BALANCE=on)(FAILOVER=on)
(ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = service_test )
(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC) )
)
)
test_1 =
(DESCRIPTION =
(ADDRESS_LIST =
(LOAD_BALANCE=ON)
(FAILOVER=ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip)(PORT = 1548))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = test_1)
))
test_3 =
(DESCRIPTION =
(ADDRESS_LIST =
(LOAD_BALANCE=ON)
(FAILOVER=ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = node2vip)(PORT = 1548))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = test_3)
))
test_5 =
(DESCRIPTION =
(ADDRESS_LIST =
(LOAD_BALANCE=ON)
(FAILOVER=ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = node3-vip)(PORT = 1548))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = test_5)
))
or could I use something as;
test =
(DESCRIPTION =
(ADDRESS_LIST=
(ADDRESS= (PROTOCOL = TCP)(HOST = node1-vip)(PORT = 1548))
(ADDRESS= (PROTOCOL = TCP)(HOST = node2-vip)(PORT = 1548))
(ADDRESS= (PROTOCOL = TCP)(HOST = node3-vip)(PORT = 1548))
(FAILOVER = on)
) (CONNECT_DATA=
(SERVICE_NAME = service_test)
))