WARNING OGG-01519

最新推荐文章于 2024-08-03 17:27:00 发布

weixin_30699955

最新推荐文章于 2024-08-03 17:27:00 发布

阅读量529

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/oracle-ziyuhou/p/10373223.html

本文详细介绍了如何解决在使用Oracle GoldenGate时遇到的OGG-01519错误，该错误通常发生在GoldenGate Replicat在读取trail文件时遇到未标记为完成的文件，而后续的trail文件已经存在。文章提供了具体的步骤，包括停止Replicat进程，执行ALTER EXTSEQNO命令，并重新启动Replicat以忽略重复交易。

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

2019-02-14 05:13:09 WARNING OGG-01519 Waiting at EOF on input trail file /home/u01/app/ogg/dirdat/MB000000002,
which is not marked as complete; but succeeding trail file /home/u01/app/ogg/dirdat/MB000000003 exists. If ALTE
R ETROLLOVER has been performed on source extract, ALTER EXTSEQNO must be performed on each corresponding downst
ream reader.

--解决方法：

GGSCI (rst.wonders.oracle) 7> stop lr02

Sending STOP request to REPLICAT LR02 ...
Request processed.

GGSCI (rst.wonders.oracle) 8> alter replicat lr02 extseqno 3 extrba 0

2019-02-14 10:29:26 INFO OGG-06594 Replicat LR02 has been altered. Even the start up position might be updated, duplicate suppression remains active in next startup. To override duplicate suppression, start LR02 with NOFILTERDUPTRANSACTIONS option.

REPLICAT (Integrated) altered.

GGSCI (rst.wonders.oracle) 9> start lr02 NOFILTERDUPTRANSACTIONS

GGSCI (rst.wonders.oracle) 12> view report lr02

2019-02-14 10:29:58 INFO OGG-02232 Switching to next trail file /home/u01/app/ogg/dirdat/MB000000005 at 201
9-02-14 10:29:58.643080 due to EOF. with current RBA 1,474.
Processed extract process graceful restart record at seq 5, rba 1412.

转载于:https://www.cnblogs.com/oracle-ziyuhou/p/10373223.html