My Oracle Support Banner

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

Last updated on JUNE 05, 2019

Applies to:

Oracle GoldenGate - Version 11.2.1.0.1 and later
Information in this document applies to any platform.

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 tho=rough following procedures).

 

Details

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
Purpose
Details

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