How Recover/resume GoldenGate Replication After Checkpoint Table Dropped On Target Database

(Doc ID 1568876.1)

Last updated on JANUARY 10, 2017

Applies to:

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

Oracle® GoldenGate Windows and UNIX Reference Guide 11g Release 2 Patch Set 1 (11.2.1.0.1)
E29399-01

DELETE CHECKPOINTTABLE
...
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. ...

Goal

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

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms