Re: Questions for Oracle advanced replication

One thing I would add to Tapan's comments. If you are just starting out with replication, get yourself on the training for it, or get someone who knows it to set it up for you. There are some issues that you can cause yourself untold pain with if you configure it incorrectly. Once you know what you're doing though, it's pretty straight forward.

Pete

Shi yousong wrote:

> Hi,
>
> I am involved in a project to setup a replication infrastructure and
> plan to use the Row-Level async replication facility to implement a
> failover Oracle database infrastructure, so any change to the DB1 will
> be propagated to DB2 and vice versa. Here the questions are raised.
> What will happen if the connection between DB1 and DB2 is cut off?
> a. Say transaction A updates a table in DB1. Now can the transaction
> A be seen on DB1 when DB2 is not available? How about the resources
> occupied by transaction A ? released or still held on ?
> b. At the moment if DB1 and DB2 are identical to each other ?
> c. After 2-3 hours, the connection is restored for example, can Oracle
> automatically make the 2 DB consistent again?
>
> Thanks in advance.
>
> Database Developer
> Sam Shi

Received on Tue Sep 28 1999 - 12:11:30 CDT