How TAF works in MAA architecture (RAC Plus Data gaurd)
I have configured completed MAA architecture, my Primary and Standby databases are RAC and , My within RAC, Failover and Load balancing work as expected. Even my following TNS entery is also working as expected. But still I have some questions.
My tns enetry.
DV00AIX_DBA=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =standby-node1)(PORT = 1527))
(ADDRESS = (PROTOCOL = TCP)(HOST =standby-node2)(PORT = 1527))
(ADDRESS = (PROTOCOL = TCP)(HOST =Primary-node1)(PORT = 1527))
(ADDRESS = (PROTOCOL = TCP)(HOST =Primary-node2)(PORT = 1527))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DV00AIX_DBA)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 4)
(DELAY = 1)
)
)
)
My questions
1) When I try to connect to database using DV00AIX_DBA, tns enerty, will the sqlplus will even try to connect to STANDBY node's as well or only Primary nodes?