Questions for Oracle advanced replication

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 - 01:25:34 CDT