Hello all,
I'm reviewing a Dataguard 11gR2 setup (1 primary --> 1 physical standby). I was just curious to know, given the below tns, wouldn't the client receive/wait a TCP timeout after 3 minutes if the primary server was actually complete down.
Here si the scenario, I do a switchover from primary to standby --> all the connections already connected get passed to the new primary using TAF.
Now all those already connected before the swtichover are ok, but now the new standby(original primary) goes completely down, would I need to change the TNS entry to use VIP instead for the new connections not to TCP timeout?
POMS=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = orap01.intm.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = orap02.intm.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = POMSDG.mf.galderma.com)
)
)
Below is a reference Tom Kyte, but was wondering if someone else had already put this into place.
Here it solution:
-----------------
1) tnsnames.ora entry will have connect time failover configured for primary and standby.
2) If primary database is down but primary node is up. The above will work fine.
3) But if primary database is down and primary node is also down. The each attempt to connect using
tnsnames.ora will go through a TCP timeout.
solution for 3:
b) On another node in primary subnet - bind/start the Failed database node IP. This can be done via
a script.
Make sure to shut this down, when bringing up the failed primary node. (This is kind of a manual
VIP failover)
Thanks in advance for your advice or assistance in thsi matter.
Jan S.