Re: Working example of TAF for RAC with DATAGUARD

From: Yechiel Adar <>
Date: Thu, 11 Sep 2008 13:08:48 +0300
Message-id: <>

Hello Steve

You can achieve this using two address lists. my-database =
(address_list = rac with failover and load balancing) (address_list= DG)

Sql net will try the first address list and if it can not connect to any of the addresses it will use the second address list. See oracle net services reference 10.2, chapter 6.

Adar Yechiel
Rechovot, Israel

steve montgomerie wrote:
> Good morning,
> I'm guessing / hoping it's possible to configure tnsnames to connect
> to the VIP's on the cluster
> with a failover entry for the standby sites. Does anyone have a
> working example of how this might be done?
> I have failover working on the cluster fine it's just the DG part that
> is throwing me for a loop. Ideally
> I'd like to switchover to the standby with no changes to the
> application server tnsnames files.
> Thanks much
> steve

Received on Thu Sep 11 2008 - 05:08:48 CDT

Original text of this message