My Oracle Support Banner

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

Last updated on JUNE 05, 2019

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

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
Goal
Solution


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