Re: REplication vs. Standby database

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Wed, 28 Jul 1999 09:02:29 -0700
Message-ID: <379F2995.2230897C@us.oracle.com>

No the two aren't the same. Replication is trigger based, standby is log based. There are pros and cons to each. What exactly are you trying to achieve? Also, what OS, RDBMS versions? Throughput requirements, data loss capabilities, failback requirements, etc. all make a difference in deciding which to use. If you can let us know some of those, we can provide more information.

HTH. Pete

dkight wrote:

> We had a situation recently where our entire raid device suffered a hardware
> failure. I am looking at updating our disaster recovery scheme by using
> either a standby database or Replication. I understand that both apply
> archive redo logs to a secondary database.
>
> Why does Oracle have a standby database product is replication is
> essentially provides the same functionality and the replicated is available
> for user access?

--
Regards

Pete

Received on Wed Jul 28 1999 - 11:02:29 CDT