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

有理想的coder CSDN认证博客专家 全栈工程师 终生学习者 懂营销的程序猿
坐标郑州,从业经验10余年,擅长javaweb技术栈,实战经验丰富。目前感兴趣方向:打造副业,网络安全,高可用高并发,架构,营销。更多干货请关注微信公众号lovepythoncn,关注我交个朋友!
已标记关键词 清除标记
©️2020 CSDN 皮肤主题: 代码科技 设计师:Amelia_0503 返回首页