How to Check if GoldenGate is in Sync
Is Data in Sync? After building OGG data synchronization, we'd like to make sure all EXTRACT log are applied to the REPLICAT database in Oracle… Read More »How to Check if GoldenGate is in Sync
EXTRACT
OGG-15163 Force Stop Extract or Replicat
OGG-15163 When we tried to stop a GoldenGate service process, we may see OGG-15163 to alert us that the process is unstoppable. Let's see what… Read More »OGG-15163 Force Stop Extract or Replicat
How to Resolve OGG-00458 Cannot find metadata property
OGG-00458 One EXTRACT of GoldenGate was found abended on the production server by the following error: 2017-09-23 20:05:18 ERROR OGG-00458 Cannot find metadata property DDL_MD_COL_PREC. … Read More »How to Resolve OGG-00458 Cannot find metadata property
How to Resolve OGG-05500 Detected database metadata mismatch between current trail file
OGG-05500 Saw an error after trying to resume a pump extract that was stopped a few weeks ago. 2017-05-10 14:34:34 ERROR OGG-05500 Detected database… Read More »How to Resolve OGG-05500 Detected database metadata mismatch between current trail file
How to Resolve OGG-00519 with ORA-00942
Recently, I initialized a set of EXTRACT / PUMP / REPLICAT for one schema, but some days after, the REPLICAT abended with this error: 2017-05-10… Read More »How to Resolve OGG-00519 with ORA-00942