You then, can re-position demoex01 extract group in Oracle GoldenGate as follows[1]:
GGSCI (oraclelinux6.localdomain) 6> alter demoex01, vam, lognum 3, logpos 120
EXTRACT altered.
After the change, you can use the stats command to check if all the DML operations are captured by Oracle GoldenGate:
GGSCI (oraclelinux6.localdomain) 9> stats demoex01
Sending STATS request to EXTRACT DEMOEX01 ...
Start of Statistics at 2014-07-23 11:48:36.
Output to ./dirdat/extract/de:
Extracting from test.TCUSTMER to test.TCUSTMER:
*** Total statistics since 2014-07-23 11:47:25 ***
Total inserts 3.00
Total updates 1.00
Total deletes 1.00
Total discards 0.00
Total operations 5.00
*** Daily statistics since 2014-07-23 11:47:25 ***
Total inserts 3.00
Total updates 1.00
Total deletes 1.00
Total discards 0.00
Total operations 5.00
*** Hourly statistics since 2014-07-23 11:47:25 ***
Total inserts 3.00
Total updates 1.00
Total deletes 1.00
Total discards 0.00
Total operations 5.00
*** Latest statistics since 2014-07-23 11:47:25 ***
Total inserts 3.00
Total updates 1.00
Total deletes 1.00
Total discards 0.00
Total operations 5.00
,,,
References
- Positioning Extract to a specific start point, Oracle GoldenGate for MySQL 12.1.2 Documentation
- mysqlbinlog — Utility for Processing Binary Log Files, MySQL 5.6 Documenation