Re: Oracle 10 Failover

sybrandb_at_hccnet.nl wrote:

> I already explained Streams and CDC are asynchronous.

I know.

> This means transaction consistency is NOT guaranteed. Dataguard
> potentially
> guarantees transaction consistency.

Do you mean that in case of a switch- or failover the running client transaction is maintained?
AFAIK this is a RAC feature, isn't it?
Or what do you mean with transaction consistency?

> Are we discussing a distributed environment? As far as I am concerned
> we are discussing misusing distributed multi-directional technologies
> (replication, streams) to mimic unidirectional fallback technologies
> (Dataguard).

OK, so you advice that one should use DG and not replication/streams to create a failover/standby server?
DG needs the Oracle EE. What option do I have on SE?

> The main purpose of RAC is to protect servers (and to offer additional
> scalability).
> The main purpose of Dataguard is to protect disks.
> I do not see where distributed environment comes into play, nowhere
> you described you have a distributed environment.

Who uses for the failover/standby database the same server? So this should always be distributed (at least 2 servers). Or do you mean with distributed different locations?

My use case is that the two databases are on different locations to protect against a disaster (fire, water etc.) at one of the locations. Sorry, forgot to mention this.

Thank you. Received on Wed Sep 10 2008 - 14:56:19 CDT