1. Oracle GoldenGate Classic Architecture Documentation
  2. Replicat
  3. Configuring Oracle GoldenGate Replicat
  4. About Checkpoint Table

About Checkpoint Table

The checkpoint table is a required component of Replicat.

A Replicat maintains its recovery checkpoints in the checkpoint table, which is stored in the target database. Checkpoints are written to the checkpoint table within the Replicat transaction. Because a checkpoint either succeeds or fails with the transaction, Replicat ensures that a transaction is only applied once, even if there is a failure of the process or the database. See Before You Add a Replicat in the Oracle GoldenGate Microservices Documentation to learn to create checkpoint tables from the Microservices web interface.

Note:

Oracle recommends using checkpoint tables. Multiple classic or coordinated Replicats can share the same checkpoint table, but that may not result in the best performance. With high volume environments, you must ensure that the checkpoint tables do not reside on different drives to become a point of conflict.

See unresolvable-reference.html#GUID-72BB2C1A-75AF-449C-8B18-1026AD2104EE for more information.