When restarting the Mine process, there will be some additional internal work required by the Mine process to ensure all changes are captured and there are no gaps in the replication. This work is done automatically on startup by the Mine process.
To ensure complete transactional integrity, the Mine process will have to go back to the last uncommited SCN for a transaction and start mining parsing 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. . Plogs are written again on Mine restarts.
The Apply process is not impacted when there is a restart on the Mine process. If it already has a plog delivered, it will not ask mine for the new copy. It knows that SCN of last applied transaction and can carry on from the last applied SCN.
When restarting Mine, the Dbvisit Replicate console will initially report what appears to be incorrect progress counters:
...
| Section | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
To find out how far back the Mine process will go on a restart, run the following command. This lists the last redo log no longer required by the Mine process:
| Section | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
The initialization is not required when Mine process has been paused. Only when the Mine process has been restarted.