当尝试启动OGG的所有Extract进程时，发现它们一直挂载无法正常运行。通过查看日志，发现存在错误提示。解决思路包括检查日志中的SCN号，并通过SQL查询获取相关信息。使用V$log视图获取FIRST_CHANGE#和NEXT_CHANGE#的时间戳，进一步分析问题。最终，通过调整SCN并重启进程，问题得到解决。
场景
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 
最低0.47元/天 解锁文章
1596
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
