OGG报错：ERROR OGG-00446 ERROR OGG-00508 ERROR OGG-00868

OGG报错解决方案：ERROR OGG-00446, ERROR OGG-00508, ERROR OGG-00868

最新推荐文章于 2025-03-27 17:43:22 发布

原创

最新推荐文章于 2025-03-27 17:43:22 发布 · 764 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#OGG #Oracle

博客内容涉及OGG在源端启动Extract进程时遇到ERROR OGG-00446, ERROR OGG-00508, ERROR OGG-00868错误。错误可能是由于断电或服务器重启时仍在写入Oracle，导致Extract进程无法启动。尝试了两种解决方法，包括重新生成和调整extseqno及extrba，但问题未完全解决。" 71515819,2103967,React Native版本升级与降级指南,"['React Native', 'Native开发', '库更新', '版本控制']

OGG报错：ERROR OGG-00446 ERROR OGG-00508 ERROR OGG-00868

报错源端启动 Extract进程

2019-09-06T16:29:09.443+0800  ERROR   OGG-00868  Oracle GoldenGate Capture for Oracle, e_testb.prm:  Gap found in DDL metadata records.
2019-09-06T16:29:09.446+0800  ERROR   OGG-00508  Oracle GoldenGate Capture for Oracle, e_testb.prm:  Fragment number gap detected (faulty data) in DDL object versioning table, fragment #3 for SCN 86309701, query [SELECT h.metadata_text, h.fragmentNo, h.optime, '', '' FROM ogg_admin.GGS_DDL_HIST h WHERE   h.seqno = (SELECT MIN(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 MIN (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) AND startSCN >= :csn))  UNION  SELECT '',0,'',b.name, a.name FROM sys.obj$ a,  sys.user$  b WHE