RE: Failover to another site Full DR.

From: Goulet, Richard <>
Date: Thu, 29 Jan 2009 16:44:53 -0500
Message-ID: <>

An answer that I used with some success was to add a second address line to the TNSNAMES.ora. When the primary was out of commission the users would connect automatically to the backup.

Dick Goulet

-----Original Message-----

[] On Behalf Of Howard Latham Sent: Thursday, January 29, 2009 4:40 AM To:
Subject: Failover to another site Full DR.

Oracle 11 - Redhat Linux 64bit
How do you failover over in dataguard/(AKA Log shipping) to another site with a completely different IP range.?

Where does a users url get redirected ? and what about ip addresses / host names on their pcs?

It seems to me there is going to be a single point of failure whatever you do.

And has anybody written a manual that enables a non dba to do a failover ? ( I'm guessing not!)


Howard A. Latham

-- Received on Thu Jan 29 2009 - 15:44:53 CST

Original text of this message