This discussion is archived
1 Reply Latest reply: Apr 23, 2012 5:35 AM by hitgon RSS

Bidirectional Replication.

928093 Newbie
Currently Being Moderated
I am planning to set up a bidirectional Active Active Db set up. I am using Streams for this requirements. I just read about the update conflicts in streams. i have a basic question on that.

If i have updated a data in DB1 and it is propagated to DB2 and a the same time if the same record is also updated in DB2 and is propagated to Db1, how the data correctness is maintained using streams?
  • 1. Re: Bidirectional Replication.
    hitgon Expert
    Currently Being Moderated
    Hello

    Please find the answer

    http://www.dba-oracle.com/t_streams_conflict_resolution.htm
    Conflict Resolution in a Streams Environment

    http://docs.oracle.com/cd/B19306_01/server.102/b14228/conflict.htm#i1006358

    Prebuilt Update Conflict Handlers
    Custom Conflict Handlers

    Regards
    Hitgon

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points