Re: Advanced replication 1

I will preface this by saying I am making a few assumptions:

1. You are using asyncrounous replication.
2. You are using Oracle's row-level replication, not procedural replication that you have written.
3. You are using Oracle 8 Advanced Replication.
4. Anything I may say may not be used against me. Here it goes:
5. Oracle by default does not resolve this conflict, it just identifies it for you to fix. Yipee!
6. I believe that the data in site A will look like what it was changed too and the data in site b will look like what it was changed to and the conflicts will be stored as changes not yet done in def_error in the respective database (site b's changes will be stored in def error on site a and vice versa). Since you mentioned site c, site c's status cannot be determined because I do not know where c is getting it's data from. if from both A and B then site c will look like whichever change it receives first and hold the second change in def_error. There are things, however, that you can do to have oracle resolve these errors by itself (by site priority, by time, I can't remember). 2.1 Depends. 2.2 I do not think that they are, you just have to keep checking def_error. --glen

Issa Semaan wrote:
>
> QUESTION 1 :
>
> In an environment of replication Muti-Master with 3 masters sites (A, B and
> C) , all master sites containing in their main group the same table X filled
> with the same data :
> - A Local application on site A removes a data D of table X, then validates
> (transaction 1).
> - Another local application on the site B then tries to update the same data
> d of table X (transaction 2).
> In this case, Oracle detects a conflict of replication and tries to solve
> it.
> 1. How does Oracle try to resolve this conflict?
> 2. If Oracle does not manage to resolve this conflict, how does it reacts?
> 2.1. Are the transactions rolled back ? If yes, which one and on which site
> ??
> 2.2. How are the applications informed of the failure of the transactions?

--
|-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-| Glen Upreti
Senior Oracle DBA
Northern Arizona University
Phone (520)523-8393 Fax(520)523-7407 Glen.Upreti_at_NOSPAMnau.edu

Received on Tue Jun 29 1999 - 09:38:34 CDT