ogg源端目标端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

ogg error code doc

https://www.yumpu.com/en/document/read/13627234/oracle-goldengate-error-messages-guide-docs-oracle

https://blog.csdn.net/huoshuyinhua/article/details/60129685

上一篇:wordpress日志审计插件audit-trail安装


下一篇:Origin——在对象管理器中操作图层和绘图