Goldengate Checkpoint Table Is already upted, biosiscorrupted

Goldengate Checkpoint Table Is already upted, biosiscorrupted

Replicat maintains checkpoints that provide a known position in the trail from which
Start after an expected or unexpected shutdown. By default, a record of these checkpoints
Is maintained in a file on disk in the Oracle GoldenGate directory. Optionally,
Checkpoint record can also be maintained in a checkpoint table in the target database.

Using database checkpointing is recommended because it enables the checkpoint to be
Included within Replicat's transaction, which improves recovery in certain situations.

However, if a Checkpoint problem occurs, we cannot use it during restoration.

The following solutions are provided on MOS:

My Checkpoint Table Is already upted. What Do I Do? (Documentation ID 965703.1)

Go to the bottom

 

In this Document Goal   Fix Applies: Oracle GoldenGate-Version 4.0.0 and later Information in this document applies to any platform. * ** Checked for relevance on 14-12-2012 *** FIX Problem How do I restore the checkpoint table so Replicat can use it again? Typical error Depending on the problem, these errors can appear as "No data found" or "Table does not exist ". Such: Ggs error 516 Extract read, No data found selecting position from checkpoint table HR. REPCHECK for group REPORA, key 1181389907 (0 × 4669453 ). Or... 13:22:16 ggs error 516 Extract read, Checkpoint table HR. REPCHECK does not exist. Please create the table or recreate the REPORA group using the correct table. Cause The table is probably updated upt, was deleted, or is missing a row (s ). Solution 1. issue the info replicat <group> command in GGSCI to verify that the checkpoint FILE on disk is intact. if it errors, the file is missing or missing upt, and you shoshould contact GoldenGate technical support. if the file is intact, continue with these steps. 2. If the table was deleted, recreate it with same schema and name as before... Or, if it is upt or missing a row, truncate it. 3. From the GoldenGate home location, run the convchk utility with the following command, specifying the checkpoint table as shown: Convchk <group name> <schema>. <table> 4. Restart Replicat. 5. SELECT from the checkpoint table to verify that checkpoints are being added again. Running convchk causes the checkpoint FILE to become the master source for the group's checkpoints. on restart, Replicat will populate the new or truncated checkpoint table with the data from the checkpoint file, in effect resynchronizing them. * ** Checked for relevance on 19-May-2011 ***