This discussion is archived
0 Replies Latest reply: Aug 13, 2012 4:28 AM by 668512 RSS

Handling Error queue and Resolving issues - Best practices

668512 Newbie
Currently Being Moderated
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.

Legend

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