Re: Failover to DG physical standby

From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Date: Mon, 08 Sep 2014 14:48:31 -0600
Message-ID: <540E161F.9040501_at_gmail.com>

A lot depends on the kind of apps, and whether you have a failover infrastructure. If the apps connect using TNSNAMES.ora you might have an easier time of it than with JDBC, but that is version dependent.

The GI can help, as it can send out messages of impending doom - look for Fast Application Notification and RAC Callouts. Some use other clusterware to handle this.

Another variant is TAF -
http://www.oracle.com/technetwork/database/features/oci/taf-10-133239.pdf

Virtual IP relocation or DNS management, similar to the way SCAN works, might be useful.

Big topic - Have fun ...
/Hans

On 08/09/2014 2:21 PM, Lyall personal wrote:
> All, more of a theoretical question then specifics and syntax needed.
> Therefore no version/OS info given
>
> We are working on a DR scenario at our company with two data centers.
> Trying to figure out how apps will connect to the DBs still when a
> disaster happens. How do you do it?
> I'm trying these tns features for FAILOVER and LOAD_BALANCE
>
> Thanks, Lyall
>
> Sent from my BlackBerry 10 smartphone.
> -- http://www.freelists.org/webpage/oracle-l .

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

Received on Mon Sep 08 2014 - 22:48:31 CEST