Re: Oracle 9i: Keep multiple servers in sync

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Mon, 09 Aug 2004 02:31:09 GMT
Message-ID: <NlBRc.73369$T_6.22923@edtnps89>

~K wrote:

> I have 3 Oracle servers that I would like to keep in sync. Only one is
> used as my production, the other is a backup and the third is used for
> development purposes. In case my primary Oracle server goes down, I
> would like to immediately use the secondary server. My question is,
> what is the best way to keep all the servers up to date such that if
> tables are updated on my primary server they immediately are updated
> in the subsequent servers.
>
> Thanks,
> ~K

Oracle Streams
Oracle DataGuard - Physical
Oracle DataGuard - Logical (iffy until 10g)

I hate to direct you to the docs for 'how' without a chance to understand the 'why' for the above. (Basically Data Guard does auto/manual fail/switch over and switch back. Streams is the 'high speed' replacement for replication.)

Unfortunately, with last week's improvements to OTN, attempts to find the Oracle9i DataGuard white papers gives me an HTML-500 error.

Perhaps you can look through the 10g white papers and then adjust expectations back to the 9i version. (see High Availability > Disaster Recovery at http://otn.oracle.com > database section.)

/Hans Received on Sun Aug 08 2004 - 21:31:09 CDT