Golden Gate extract struck from last 26 hours, tried to restart extract process but it’s not allowing to stop
GGSCI (racnode01)> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING DINCS3 00:00:00 00:00:03
EXTRACT RUNNING EINCS3 00:00:03 26:38:07
GGSCI (racnode01)>stop EINCS3
OGG-15163 There was a problem sending a message to EXTRACT EINCS3 (Timeout waiting for message).
Review ggserr.log:
2021-08-21T10:09:41.158-0700 ERROR OGG-01260 Oracle GoldenGate Capture for Oracle, eincs3.prm: No sufficient space on directories : de: /ACFS_OGG/gg/dirtmp, bytes: 0x00000000400000, co_uid: 0x000000029415bc, mb_uid: 0x000000002006, co: 0x00007f26cff020, mb: 0x000072f41c70, mf: 0x00007f2640140.
2021-08-21T10:09:41.158-0700 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, eincs3.prm: PROCESS ABENDING.
Process abended with error No sufficient space on directories : de: /ACFS_OGG/gg/dirtmp,
But in ggsci it’s still show as running , we can kill process forcefully
GGSCI (racnode01)> kill extract EINCS3
CACHEMGR parameter is to control the amount of virtual memory and temporary disk space that is available for caching uncommitted transaction data,
Add CACHEMGR, CACHEDIRECTORY size 100G to extract param file:
GGSCI (racnode01)>edit params EINCS3
CACHEMGR CACHESIZE 2G,CACHEDIRECTORY /ACFS_OGG/gg/dirtmp 100G
Start extract:
GGSCI (racnode01)>start EINCS3
Monitor extract lag timing:
GGSCI (racnode01)> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING DINCS3 00:00:00 00:00:03
EXTRACT RUNNING EINCS3 20:50:03 00:00:07
GGSCI (racnode01)> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING DINCS3 00:00:00 00:00:03
EXTRACT RUNNING EINCS3 00:50:03 00:00:07
No comments:
Post a Comment