On Mon, Sep 03, 2001 at 08:45:24AM -0800, nlzanen1_at_EY.NL wrote:
>
>
> Hi All,
>
>
> I'm resaerching standby database on 8.0.5 here and have a question.
> Setting up the standby database is quite well documented, but how to
> configure the clients in such a way that they will first try the primary
> site and if that's not responding try the standby site. Oracle
> documentation did not give me satisfactory result.
--
I don't think you want to do what you are saying.
For standby environment you would need to have some manual intervention
at the prod failure (well, I guess you could script it, but I
wouldn't). What I'd do is configure the old prod host ip address on
the new prod host (the old standby that has been activated). That way
you don't have to mess with a dns restart. You may need to clear some
arp caches in some layer 2 & 3 network elements along the way,
however. As an alternative, you could move the dns pointer record for
the db from the old prod host dns entry to the old standby entry, which
isn't a standby anymore, it is the new prod host. Whichever is
easier.
===============================================================
Ray Stell stellr_at_vt.edu (540) 231-4109 KE4TJC 28^D
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ray Stell
INET: stellr_at_stell.cns.vt.edu
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Mon Sep 03 2001 - 16:19:58 CDT
