Re: Working example of TAF for RAC with DATAGUARD

You might also review the information in these whitepapers--I found them to be very helpful in a similar situation to yours: http://www.oracle.com/technology/deploy/availability/pdf/MAA_WP_10gR2_FastStartFailoverBestPractices.pdf http://www.oracle.com/technology/deploy/availability/pdf/MAA_WP_10gR2_ClientFailoverBestPractices.pdf

There are a lot of similar papers at
http://www.oracle.com/technology/deploy/availability/htdocs/maa.htm

Dan

Yechiel Adar wrote:
> 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.
>>
>>

--
http://www.freelists.org/webpage/oracle-l