Starting on Oracle GoldenGate 23.7

ERROR   OGG-03200  Replicat requires DB checkpoint.

All Replicats without checkpoints are desupported. The creation of integrated and classic Replicat without checkpoint tables is not supported in Oracle Database. Additionally, any Replicats that were created without the checkpoint tables, will not start successfully.

For existing Replicats to run successfully, you must alter the Replicat to add a checkpoint table or add the checkpoint table to GLOBALS and then restart the Replicat. See ADD REPLICAT CHECKPOINTTABLE in the Command Line Interface Reference for Oracle GoldenGate for details.

Here’s a quick example of how to throw a checkpoint table into the replicat.

Stop replicat REPA
 
Info replicat REPA
 
Replicat   REPA   Last Started 2025-02-05 12:17   Status STOPPED
INTEGRATED
Checkpoint Lag       00:00:00 (updated 00:59:18 ago)
Log Read Checkpoint  File /<deployment_home>/var/lib/data/REPA/mf000000010
                     2025-02-05 12:23:47.695357  RBA 322765324
Encryption Profile   LocalWallet
 
Delete replicat REPA

ADD CHECKPOINTTABLE oggadmin.checkpointtable
 
add replicat REPA, integrated, exttrail /<deployment_home>/var/lib/data/remote/REPA/mf CHECKPOINTTABLE oggadmin.checkpointtable
 
alter replicat REPA extseqno 10 extrba 322765324
 
start replicat REPA