Re: Client failover with 10g DG
Date: Tue, 18 Jan 2011 12:07:27 +0100
Message-ID: <4D35746F.7060804_at_usn-it.de>
Hi,
I am doing it this way
http://www.usn-it.de/index.php/2007/06/28/how-to-fail-over-a-client-transparently-in-a-dataguard-switchoverfailover-scenario/
for years now, it works like a charm.
Regards
Martin Klier
Ram Raman schrieb:
> Listers,
>
> I am doing some research on setting up v10.2 DG for couple of our
> databases. They both will be single instance DBs. We are looking into
> the new client connections automatically going to the standby in case of
> failover and the configuration of client tns. I am looking into creating
> services based on this
> <http://prutser.files.wordpress.com/2008/12/client_connectivity.pdf>
> paper. It seems to
>
> What do other listers do to automate client failover in case of primary
> instance failure. Is using triggers with services a reliable way of
> failing over to standby (the new primary) ? Any surprises there?
>
> Thanks.
>
-- Usn's IT Blog for Linux, Oracle, Asterisk http://www.usn-it.de -- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 18 2011 - 05:07:27 CST