We're here to help!

Adjusting the progress counter for a particular table

Follow
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

Have more questions? Submit a request

Comments