High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

How TAF works in MAA architecture (RAC Plus Data gaurd)

 All,

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center