GoldenGate suspected BUG: info all cannot view extract
Symptom:
Info all cannot view extract ext2, but info ext2 can display the status.
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
Extract running PMP_APP 00:00:00 00:00:07
GGSCI (UNID1) 22> info ext2
EXTRACT EXT2 Initialized Status STOPPED
Checkpoint Lag Not Available
Log Read Checkpoint Not Available
First Record 0
Task SOURCEISTABLE
Analysis: the error is caused by a gg bug. The OS version is 11.2.1.0.5 and the OS version is OEL5.4.
Solution: delete EXT2 and recreate
GGSCI> delete extract EXT2
GSCI> add extract EXT2 <paramaters>
Verification:
GGSCI> INFO ALL
GGSCI> send extract EXT2, REPORT
GGSCI> view report EXT2
Management OGG-HA in RAC Environment
Configure OGG synchronization in RAC Environment
GoldenGate unidirectional table DML Synchronization
Oracle GoldenGate series: restoration principles of Extract processes
Oracle GoldenGate installation Configuration
OGG-01004 OGG-1296 error for Oracle goldengate