Oracle GoldenGate Error Messages

OGG-01143

before image missing from key update for table {0}


Cause

A primary key was updated, but the before image is not in the Oracle redo log record. Supplemental logging for this table was not enabled before starting capture of its data.


Action

First, make certain that database-level supplemental logging is enabled. Next, do the following, without delay between steps, so that Extract lag is kept to a minimum: Stop Extract, then remove the table from the TABLE parameter, then restart Extract. Next issue ADD TRANDATA for the table. Stop activity on the table, and resynchronize it with the target. Stop Extract, then add the table back to the TABLE parameter. Start Extract and enable user activity on the table.