环境说明:
mysql to oracle ogg同步
问题说明:
2023-12-05 16:57:32 ERROR OGG-00146 Call to VAMRead returned with error status 600: VAM Client Report <CAUSE OF FAILURE : Column count for the current record does not match with the column count
of the table metadata for table as.matters
WHEN FAILED : While Sending Insert and Delete Record
WHERE FAILED : MySQLBinLog Reader Module
CONTEXT OF FAILURE : No Information Available!>.
问题原因:
源端MySQL做了字段增减,但是OGG异构不支持DDL操作,所以源端抽取进程异常断开。
但是已经重新创建了异构文件了,重启抽取进程的时候仍然失败。怎么让抽取进程重新识别到新的异构文件呢?请求广大网友,谢谢
MOS相关文档:
Mysql Remote Capture Abends With OGG-00146 After DDL Change On Table (Doc ID 2833656.1)
临时处理方案:
从原来的同步进程删除该表,重新创建新的同步进程。