ALTER EXTSEQNO must be performed on each corresponding downstream reader

最新推荐文章于 2025-03-06 15:41:20 发布

转载最新推荐文章于 2025-03-06 15:41:20 发布 · 150 阅读

本文记录了在使用 Oracle GoldenGate (OGG) 过程中遇到的问题及解决办法。主要内容包括 OGG 在处理文件 ./dirdat/bm000002 时出现的警告信息，提示该文件未标记为完成但后续文件已存在，以及如何通过执行 ALTER ETROOLVER 和 ALTER EXTSEQNO 命令来解决这一问题。同时，还展示了从 GGSCI 接收到的多个命令，如 STATS 和 GETLAG 的执行情况。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

2009-10-26 23:28:19 WARNING OGG-01519 Waiting at EOF on input trail file ./dirdat/bm000002, which is not marked as complete; but succeeding trail file ./dirdat/bm000003 exists. If ALTER ETROLLOVER has been performed on source extract, ALTER EXTSEQNO must be performed on each corresponding downstream reader. 2009-10-26 23:30:20 INFO OGG-01021 Command received from GGSCI: STATS. 2009-10-26 23:32:25 INFO OGG-01021 Command received from GGSCI: GETLAG. 2009-10-26 23:32:50 INFO OGG-01021 Command received from GGSCI: STATS. 2009-10-26 23:33:20 INFO OGG-01021 Command received from GGSCI: GETLAG. 2009-10-26 23:34:15 INFO OGG-01021 Command received from GGSCI: STATS. 2009-10-26 23:39:02 WARNING OGG-01519 Waiting at EOF on input trail file ./dirdat/bm000002, which is not marked as complete; but succeeding trail file ./dirdat/bm000003 exists. If ALTER ETROLLOVER has been performed on source extract, ALTER EXTSEQNO must be performed on each corresponding downstream reader.