ogg源端目标端trail文件不对应缺失解决

最新推荐文章于 2021-04-10 22:56:19 发布

原创最新推荐文章于 2021-04-10 22:56:19 发布 · 2.3k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#ogg #数据库

数据库专栏收录该内容

29 篇文章

订阅专栏

本文记录了一次Oracle GoldenGate在运行过程中遇到的错误及解决过程。详细介绍了从错误日志中发现问题到采取措施重置trail文件和投递进程的具体步骤，并提供了相关错误代码的文档链接。

错误

2020-10-09 17:10:28  INFO    OGG-00993  Oracle GoldenGate Capture for Oracle, PUMPHC.prm:  EXTRACT PUMPHC started.
2020-10-09 17:10:33  INFO    OGG-01226  Oracle GoldenGate Capture for Oracle, PUMPHC.prm:  Socket buffer size set to 100000 (flush size 300000).
2020-10-09 17:10:33  INFO    OGG-01055  Oracle GoldenGate Capture for Oracle, PUMPHC.prm:  Recovery initialization completed for target file ./dirdat/hc000426, at RBA 16854.
2020-10-09 17:10:33  INFO    OGG-01478  Oracle GoldenGate Capture for Oracle, PUMPHC.prm:  Output file ./dirdat/hc is using format RELEASE 11.2.
2020-10-09 17:10:33  INFO    OGG-01026  Oracle GoldenGate Capture for Oracle, PUMPHC.prm:  Rolling over remote file ./dirdat/hc000427.
2020-10-09 17:10:33  ERROR   OGG-01337  Oracle GoldenGate Capture for Oracle, PUMPHC.prm:  Trail file ./dirdat/hc000427, IO error 0 ().
2020-10-09 17:10:34  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, PUMPHC.prm:  PROCESS ABENDING.
2020-10-09 17:14:52  INFO    OGG-01085  Oracle GoldenGate Command Interpreter for Oracle:  ggsci received window closed event.

重置trail文件

# 重置投递
stop EXTRACT  pumphc  
ALTER EXTRACT pumphc  EXTSEQNO 0
ALTER EXTRACT pumphc  EXTRBA 0
 ALTER EXTRACT pumphc  ETROLLOVER
start EXTRACT  pumphc  
# 重置复制进程
stop replicat RHCP
ALTER replicat RHCP EXTSEQNO 0
ALTER replicat RHCP EXTRBA 0
 ALTER replicat RHCP ETROLLOVER
start  replicat   RHCP