Re: Oracle 9i Replication to a Remote Site

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 16 May 2005 08:04:28 +0200
Message-ID: <budg81hvt1dairb3hvdelurh1fafkv58ek@4ax.com>

On 15 May 2005 20:01:24 -0700, "Edwinah63" <edwinah_at_customercare.com.au> wrote:

>what we are trying to set up:
>* failover so if the main server crashes, users will transparently swap
>over to the remote backup system until the main server is back up.
>
>* once main server is up, any data captured on the remote backup will
>be copied across. users will then flick back over to the main server
>again.

Can not be done by replication. You'll need Dataguard for this.

--
Sybrand Bakker, Senior Oracle DBA

Received on Mon May 16 2005 - 01:04:28 CDT