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

程序员文章站 2024-02-12 13:58:16

...

现象：
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