Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Questions for Oracle advanced replication

Questions for Oracle advanced replication

From: Shi yousong <yousong_at_bigpond.com>
Date: Tue, 28 Sep 1999 16:25:34 +1000
Message-ID: <37F05F5D.AFAF7F65@bigpond.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US