RE: Question for Dataguard users
- From: Laimutis.Nedzinskas@xxxxxx
- To: oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 28 Jul 2011 09:57:02 +0300
Well, since the problem is really more than Oracle's problem then my
current company threw clusterware into that. VIP (Virtual IP) follows the
active node by using a customized script and that's it.
Downside - additional software, licenses, etc. But since all that is in
place anyway then why not to use it ?
What else - increased downtime by nn seconds until clusterware detects (by
simply checking dgmgrl or v$database) which is the active node.
Upside - no messing with tnsnames, no multi-entries in tnsnames (which
slows down new connections)
brgds, Laimis N
From: "Storey, Robert (DCSO)" <RStorey@xxxxxxxxxxxxxxxxxx>
To: oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>
Date: 07/27/2011 12:44 PM
Subject: Question for Dataguard users
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
Okay, have a question for the dataguard users. Probably more for the
non-RAC folks than anything.
My setup is a primary and a single physical standby.
In the event of a switchover, all user connections are broken and the
switch occurs. Then users have to reconnect.
But, I’m looking for the best way to structure the TNSNAMES file. I’m
probably over thinking this, but, there has to be a way to create both
entries for both servers in the file, but only have them use the production
one. Something tickles my brain from way back that it will run the TNS
list in order looking for a connection.
Just curious how others have set up their files.
Thanks
--
//www.freelists.org/webpage/oracle-l
Other related posts:
