My Oracle Support Banner

How Recover/resume GoldenGate Replication After Checkpoint Table Dropped On Target Database (Doc ID 1568876.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle GoldenGate - Version to [Release 11.2]
Information in this document applies to any platform.

Oracle® GoldenGate Windows and UNIX Reference Guide 11g Release 2 Patch Set 1 (

If the checkpoint table is deleted while Replicat is still running and transactions are
occurring, Replicat will abend with an error that the checkpoint table could not be found.
However, the checkpoints are still maintained on disk in the checkpoint file. To resume
processing, add the checkpoint table back under the same name. Data in the trail resumes
replicating. ...


How do you resume GoldenGate REPLICAT(ion) after the Checkpoint table was accidentally dropped?


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

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