Oracle GoldenGate cannot Extract Mariadb 10.2.9 binlog to Oracle 12c
Dear
I use OGG 12c for CDC of MySQL 5.5.6 source to Oracle target It worked well. But I configure for MariaDB 10.2.9 source to Oracle taget with same config (binlog_format=ROW). The Extract raised Error: ---> ERROR OGG-00146 Oracle GoldenGate Capture for MySQL, ecdc_bde.prm: Call to VAMControl returned with error status 600: VAM Client Report <CAUSE OF FAILURE : Sanity Check Failed for events WHEN FAILED : While reading log event from binary log WHERE FAILED : MySQLBinLog Reader Module CONTEXT OF FAILURE : No Information Available!>. ERROR OGG-01668 Oracle GoldenGate Capture for MySQL, ecdc_bde.prm: PROCESS ABENDING. <---
Maybe, MariaDB's binlog change campared MySQL 5.5.6.
Have you ever face this issue and any solution to fix it. Plz share to me. Thank you!
Answer
To be clear, you should have all of the following set:
log-bin binlog-format=ROW binlog-row-image=FULL binlog-annotate-row-events=OFF