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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Howard Latham Sent: Thursday, January 29, 2009 4:40 AM To: oracle-l@xxxxxxxxxxxxx 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 -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l