Adjusting the progress counter for a particular table

Problem Description

Sometimes it may be necessary to adjust the progress counters for a specific table. This maybe due to conflicts or re-synching a table. 

Solution

The steps are:

1. Determine the difference between mine and apply counts (=subtract those two progress numbers when apply and mine are in sync).

2. Determine object_id of the table in question on the SOURCE.

   select object_id from dba_objects where owner='...' and object_name='...';

3. Stop the apply process.

4. Update apply stats on the TARGET with SQL.

   update dbvrep.dbrsapply_stats set lcr_count = lcr_count + (the difference) where object_id=(...); commit;

5. Start the apply process.

Arjen Visser July 13, 2013 06:55