How to recover OGG process if checkpoint file is accidentally removed?
(Doc ID 2199555.1)
Last updated on FEBRUARY 18, 2020
Applies to:Oracle GoldenGate - Version 220.127.116.11.1 and later
Information in this document applies to any platform.
Checkpoint files are critical for ogg replication. losing them will interrupt the replication. Besides recreating and resyncing the data, here lists the options to recover them without resync.
please note that there may be limitations, and assuming that all other files are available except checkpoint files.
First, check if the related ogg processes are still running (even after the checkpoint file was deleted). if so, for extract it needs to be killed, while for pump and replicat the upstream extract/pump may be stopped first and let the pump/replicat to complete processing the existing trails before killing the process. in later case (pump/replicat process were running), the pump/replicat may be re-added and position to the next trail file after starting the immediate upstream process (there will not no need to go through following procedures).
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document