Sometimes it may be necessary to adjust the progress counters for a specific table. This maybe due to conflicts or re-synching a table.
The steps are:
- Determine the difference between mine and apply counts (=subtract those two progress numbers when apply and mine are in sync).
- Determine object_id of the table in question on the SOURCE.
where owner='...' and object_name='...';
- Stop the apply process.
- Update apply stats on the TARGET with SQL.
update dbvrep.dbrsapply_stats set lcr_count = lcr_count + (the difference) where object_id=(...); commit;
- Start the apply process.
Arjen Visser July 13, 2013 06:55