How to recover OGG process if checkpoint file is accidentally removed? (Doc ID 2199555.1)

Last updated on SEPTEMBER 18, 2024

Applies to:

Purpose

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).

Details

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.