参考文档:
GoldenGate Main Extract or Extract Pump Abend With OGG-01449 Scan failed in trail file (Doc ID 1469350.1)
Extract Abend OGG-01449 Oracle GoldenGate Capture for Oracle: Scan failed in trail file (Doc ID 1512392.1)
Pump Extract Status Command Stuck With Waiting at EOF message (Doc ID 1589655.1)
问题
数据库主机宕机后,上面的ogg进程,部分ext异常,其他ext正常,其他所有的pump,rep进程都正常。唯独两个ext进程异常。
1 ogg的抽取进程ext02 ,ext03 状态异常
2 ogg的log中提示
- 2022-09-08 15:21:23 ERROR OGG-01449 Oracle GoldenGate Capture for Oracle, epccb02.prm: Scan failed in trail file ./dirdat/ext02/EX002512, with scan start seqno 2512, rba 8732602.
- 2022-09-08 15:24:10 ERROR OGG-01449 Oracle GoldenGate Capture for Oracle, epccb03.prm: Scan failed in trail file ./dirdat/ext03/EX005548, with scan start seqno 5548, rba 199486127.
解决办法:
针对OGG-01449 ,执行以下命令
ALTER EXT ext02, ETROLLOVER
ALTER EXT ext03, ETROLLOVER
随后查看ogg的log ,发现这两个ext进程对应的pump进程,pump的rba没有反应 。
解决方法:
alter extract pump2, extseqno 2513, extrba 0 -- 坏的2512 ,从新的tail 文件开始
alter extract PUMP3, extseqno 5549, extrba 0 -- 坏的5548 ,从新的tail 文件开始
END