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

krandryc (AT) hotmail (DOT) com (~K) wrote in
news:2d760bc3.0408081658.2c864168 (AT) posting (DOT) google.com:

~K wrote:

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