场景
ogg 所有Extract 进程起不起来,一直挂载中,查看日志,报错如下
2019-08-26T14:13:12.177+0800 ERROR OGG-00868 Oracle GoldenGate Capture for Oracle, e_xxl3.prm: Gap found in DDL metadata records.
2019-08-26T14:13:12.182+0800 ERROR OGG-00508 Oracle GoldenGate Capture for Oracle, e_xxl3.prm: Fragment number gap detected (faulty data) in DDL object versioning table, fragment #3 for SCN , query [SELECT metadata_text, fragmentNo, optime FROM ogg_admin.GGS_DDL_HIST WHERE seqno = (SELECT MAX(seqno) FROM ogg_admin.GGS_DDL_HIST WHERE objectid = (SELECT objectId FROM ogg_admin.GGS_DDL_HIST_ALT WHERE altObjectId = :object_id AND rownum=1) AND startSCN = (SELECT MAX (startSCN) FROM ogg_admin.GGS_DDL_HIST WHERE objectid = (SELECT objectId FROM ogg_admin.GGS_DDL_HIST_ALT WHERE altObjectId = :object_id AND rownum=1))) ORDER BY fragmentNo ].
2019-08-26T14:13:12.182+0800 ERROR