当前位置:Gxlcms > mysql > GoldenGate疑似BUG:infoall查看不到extract

GoldenGate疑似BUG:infoall查看不到extract

时间:2021-07-01 10:21:17 帮助过:34人阅读

GoldenGate疑似BUG:info all查看不到extract

GoldenGate疑似BUG:info all查看不到extract

现象:
info all查看不到extract ext2,但是info ext2却可以显示状态。
GGSCI (UNID1) 20> ADD EXTRACT ext2, SOURCEISTABLE
ERROR: EXTRACT EXT2 already exists.
GGSCI (UNID1) 21> info all
Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING EXT_APP 00:00:00 00:00:04
EXTRACT RUNNING PMP_APP 00:00:00 00:00:07
GGSCI (UNID1) 22> info ext2
EXTRACT EXT2 Initialized 2013-11-08 09:08 Status STOPPED
Checkpoint Lag Not Available
Log Read Checkpoint Not Available
First Record Record 0
Task SOURCEISTABLE

分析:怀疑是GG的BUG导致,版本为11.2.1.0.5,,OS为OEL5.4
解决方法:删除EXT2并重建
GGSCI> DELETE EXTRACT EXT2
GSCI> ADD EXTRACT EXT2
验证:
GGSCI> INFO ALL
GGSCI> SEND EXTRACT EXT2 , REPORT
GGSCI> VIEW REPORT EXT2

相关阅读:

RAC环境下管理OGG-HA

RAC环境下配置OGG同步

GoldenGate单向表DML同步

Oracle GoldenGate 系列:Extract 进程的恢复原理

Oracle GoldenGate安装配置

Oracle goldengate的OGG-01004 OGG-1296错误

linux

人气教程排行