When restarting the Mine process, there will be some additional work required to ensure all changes are captured and there are no gaps in the replication.
To ensure complete transactional integrity, the Mine process will have to go back to the last uncommited SCN for a transaction and start mining for any changes since that SCN. There may have been a future commit for that transaction and Mine needs to ensure that all the changes have been mined. This may mean that Dbvisit Replicate will go to the archive redo logs to capture the full transaction history.
When restarting Mine, the Dbvisit Replicate console will initially report what appears to be incorrect progress counters:
-MINE IS running. Currently at plog 66 (redo sequence 1424 [1] 1831 [2]) and SCN 47476178 (04/13/2012 18:57:13).
APPLY IS running. Currently at plog 52 and SCN 0 (01/01/1988 00:00:00).
Progress of replication orcl:MINE->APPLY: total/this execution
--------------------------------------------------------------------------------------------------------------------------------------------
SCOTT.AVI_OBJECTS: 133% Mine:6000/6000 Unrecov:0/0 Applied:8000/0 Conflicts:0/0 Last:--/--
--------------------------------------------------------------------------------------------------------------------------------------------
The Apply SCN is set to 0 while the Mine process goes back to the last uncommitted SCN. The % progress will also not reflect the true number while this initialization is carried out.
Once the initialization has been completed, the progress counters will return to normal:
-MINE IS running. Currently at plog 67 (redo sequence 1424 [1] 1832 [2]) and SCN 47521517 (04/13/2012 20:11:06).
APPLY IS running. Currently at plog 67 and SCN 47521475 (04/13/2012 20:11:00).
Progress of replication orcl:MINE->APPLY: total/this execution
--------------------------------------------------------------------------------------------------------------------------------------------
SCOTT.AVI_OBJECTS: 100% Mine:10000/10000 Unrecov:0/0 Applied:10000/2000 Conflicts:0/0
The initialization is not required when Mine process has been paused. Only when the Mine process has been restarted.