0 Replies Latest reply on Aug 13, 2012 11:28 AM by 668512

    Handling Error queue and Resolving issues - Best practices

      This is related to Oracle 11g R2 streams replication.

      I have a table A in Source and Table B in destination. During the replication by Oracle streams, if there is an error at apply process, the LCR record will go to error queue table.

      Please share the best practices on the following:
      1. Maintaining error table operation,
      2. monitor the errors in such a way that other LCRs are not affected,
      3. Reapply the resolved LCRs from error queue back to Table B, and
      4. Retain the synchronization without degrading the performance of streams

      Please share some real time insight into the error queue handling mechanism.

      Appreciate your help in advance.