Re: Questions for Oracle advanced replication

I agree. If you are pretty new then I would suggest that you might have someone who knows at least look over your shoulder.

                                                Tapan

Pete Sharman wrote:
>
> 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 - 13:40:25 CDT