OGG-00715 OGG-00712 OGG-00723

环境信息

操作系统：Red Hat 6.4
Oracle: 11.2.0.4 RAC
OGG：12.2.0.2.2
OGG抽取模式：集成模式

故障现象

因存储原因，对该套环境所有存储进行更换，由于ogg也是问题存储。所以今天也进行更换，更换存储之前直接停止了mgr管理进行，而后进行存储更换。换上新存储后，启动抽取进程，RBA一直不动，延迟时间一直增加。

抽取进程信息如下所示

GGSCI (zdrygknode02) 144> info EXT_RC1

EXTRACT    EXT_RC1   Last Started   2023-05-29 15:20   Status RUNNING
Checkpoint Lag       01:07:44 (updated 00:00:55 ago)
Log Read Checkpoint  Oracle Redo Logs
                     2023-05-29 14:13:36  Thread 1, Seqno 2071329, RBA 1435267476
                     SCN 4361.3918970603 (182734271348459)
Log Read Checkpoint  Oracle Redo Logs
                     2023-05-29 14:13:37  Thread 2, Seqno 1236146, RBA 4228679320
                     SCN 4361.3918972229 (182734271340085)

ggserr.log日志信息

2023-05-29 15:10:56  WARNING OGG-00723 Oracle GoldenGate Capture for Oracle, ext_rc1 rpm:  Record with class# 492, slt# 69, at seqno 1236095, rba 1912523280 SCN 4361.3878860153 (18734231238009) has secondary transaction ID that is duplicate of existing open uncommitted transaction.
2023-05-29 15:10:56  WARNING OGG-00715 Oracle GoldenGate Capture for Oracle, ext_rc1 rpm:  [Thread #2] Purging transaction (transaction id: 238.69.88406344, start time: 2023-05-29 11:18:41, start seqno: 1236095, start RBA: 1203039248).
2023-05-29 15:10:56  WARNING OGG-00712 Oracle GoldenGate Capture for Oracle, ext_rc1 rpm:  Updating I/O checkpoint after purging orphaned transactions on thread 2 with current position (Seq#: 1236095, RBA: 1913245548).

尝试使用重新注册，改RBA等方法都无法消除延迟。。。。

几经周折，最终解决办法如下

GGSCI (zdrygknode02) 147> alter extract EXT_RC1, thread 1, BEGIN 2023-05-29 14:13:00
EXTRACT altered.


GGSCI (zdrygknode02) 148> alter extract EXT_RC1, thread 2, BEGIN 2023-05-29 14:13:00
EXTRACT altered.

随后重启抽取进程恢复正常

参考资料：http://blog.itpub.net/13885898/viewspace-1651350/