1 Reply Latest reply: Apr 23, 2012 7:35 AM by hitgon RSS

    Bidirectional Replication.

    928093
      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
          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