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
When I temporarily change the retention hour of extract tail to only 1 hour, I want it to take effect immediately. [oracle@test dirprm]$ vi mgr.prm… Read More »How to Reload Manager Parameter
Use the Latest OPatch First of all, we have to download the latest OPatch utility for GoldenGate. In this case, we downloaded OPatch 11.2.0.3.25 for… Read More »How to Patch Oracle GoldenGate 12c
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
OGG-01973 The redo record indicates data loss on object Found an extract abended when I checked the synchronization status of Golden Gate. [oracle@test ogg]$ ./ggsci… Read More »How to Resolve OGG-01973 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