RE: Failover to another site Full DR.

From: Goulet, Richard <Richard.Goulet_at_parexel.com>
Date: Thu, 29 Jan 2009 16:44:53 -0500
Message-ID: <23C4836D8E9C5F4280A66C0C247BC16F2306FCDD_at_US-BOS-MX011.na.pxl.int>

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-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Howard Latham Sent: Thursday, January 29, 2009 4:40 AM To: oracle-l_at_freelists.org
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
--

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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jan 29 2009 - 15:44:53 CST