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
REPLICAT
How to Resolve ORA-01438 in GoldenGate
ORA-01438 with OGG-00869 in GoldenGate REPLICAT was found as ABENDED in the daily check on GoldenGate. ORA-01438 with OGG-00869 is found in REPLICAT report: 2018-06-21… Read More »How to Resolve ORA-01438 in GoldenGate
How to Resolve OGG-01168 Encountered an update for target table XXX
OGG-01168 The REPLICAT stopped due to the following error. 2017-09-14 19:52:01 ERROR OGG-01168 Encountered an update for target table HR.MAIN_TEAMS_RECRUIT, which has no unique… Read More »How to Resolve OGG-01168 Encountered an update for target table XXX
How to Resolve OGG-00519 Error Message
OGG-00519 In the remote database, you may not create all objects to resolve dependency problems. Here are some OGG-00519 DDL errors in REPLICAT report below:… Read More »How to Resolve OGG-00519 Error Message
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