RE: Question for Dataguard users

Also played around with the backup method as per oracle's example:

http://download.oracle.com/docs/cd/B19306_01/network.102/b14212/advcfg.htm#sthref1304

change the method parameter to basic instead of pre-connect but I never got 
enough time get a workable one for me. But it's a thought as well. Like always 
milage varies.

________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Amaral, Rui
Sent: Wednesday, July 27, 2011 2:11 PM
To: 'RStorey@xxxxxxxxxxxxxxxxxx'; oracle-l-freelists
Subject: RE: Question for Dataguard users

One setup that worked for me when I played with it (we decided to eventually go 
with a network based switch method for other reasons [like jdbc can't parse 
those sorts of connections strings]) was something like this:

db_connect=
 (DESCRIPTION=
  (ADDRESS_LIST=
   (LOAD_BALANCE=off)
    (ADDRESS=(PROTOCOL=tcp)(HOST=server1)(PORT=1521))
    (ADDRESS=(PROTOCOL=tcp)(HOST=server2)(PORT=1521)))
  (CONNECT_DATA=
     (SERVICE_NAME=db_service_name)
     (FAILOVER_MODE=
       (TYPE=select)
       (METHOD=basic)
       (RETRIES=20)
       (DELAY=15))))

With load_balance=off the connect attempts to access he db via the first entry 
and makes 20 attempts with a 15 second delay between attempts then tries the 
next entry in sequential order.  Worked fine with the standard oci client but 
your mileage may vary on your environment.

________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Storey, Robert (DCSO)
Sent: Wednesday, July 27, 2011 1:43 PM
To: oracle-l-freelists
Subject: Question for Dataguard users

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

NOTICE: Confidential message which may be privileged. Unauthorized 
use/disclosure prohibited. If received in error, please go to www.td.com/legal 
for instructions.
AVIS : Message confidentiel dont le contenu peut ?tre privil?gi?. 
Utilisation/divulgation interdites sans permission. Si re?u par erreur, pri?re 
d'aller au www.td.com/francais/avis_juridique pour des instructions.

Other related posts: