Hi my dear friends Veera and all,
GG = 11.1
Db = 9.2.0.6
OS = OEL 5.3
We current GG replication setup made by previous dba.
I checked and startup extr but extract processes keep on abending
GGSCI (oracle.local) 3> start ZEXTR
Sending START request to MANAGER ...
EXTRACT ZEXTR starting
GGSCI (oracle.local) 1> status all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT ABENDED ZEXTR 00:00:00 1100:15:08
EXTRACT RUNNING ZPUMP 00:00:00 00:00:08
I checked the logs, and I saw these errors:
GGSCI (oracle.local) 4> view ggsevt
2015-01-28 06:32:48 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oratest): start ZEXTR.
2015-01-28 06:32:48 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host 192.168.0.192 (START EXTRACT ZEXTR ).
2015-01-28 06:32:48 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT ZEXTR starting.
2015-01-28 06:32:48 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, zextr.prm: EXTRACT ZEXTR starting.
2015-01-28 06:32:48 INFO OGG-01639 Oracle GoldenGate Capture for Oracle, zextr.prm: BOUNDED RECOVERY: ACTIVE: for object pool 1: p5490_extr.
2015-01-28 06:32:48 INFO OGG-01640 Oracle GoldenGate Capture for Oracle, zextr.prm: BOUNDED RECOVERY: recovery start XID: 6.35.2181861.
2015-01-28 06:32:48 INFO OGG-01641 Oracle GoldenGate Capture for Oracle, zextr.prm: BOUNDED RECOVERY: recovery start position: SeqNo: 280, RBA: 80565776, SCN: 1391.2351121844
(5976650630580), Timestamp: 2014-12-13 10:13:26.000000.
2015-01-28 06:32:48 INFO OGG-01642 Oracle GoldenGate Capture for Oracle, zextr.prm: BOUNDED RECOVERY: recovery end position: SeqNo: 280, RBA: 80638976, SCN: 1391.2351121984 (5
976650630720), Timestamp: 2014-12-13 10:13:37.000000.
2015-01-28 06:32:48 INFO OGG-01643 Oracle GoldenGate Capture for Oracle, zextr.prm: BOUNDED RECOVERY: CANCELED: for object pool 1: p5490_extr.
2015-01-28 06:32:48 INFO OGG-01579 Oracle GoldenGate Capture for Oracle, zextr.prm: BOUNDED RECOVERY: VALID BCP: CP.ZEXTR.000000046.
2015-01-28 06:32:48 INFO OGG-01629 Oracle GoldenGate Capture for Oracle, zextr.prm: BOUNDED RECOVERY: PERSISTED OBJECTS RECOVERED: <<NONE TO RECOVER>>.
2015-01-28 06:32:48 ERROR OGG-00730 Oracle GoldenGate Capture for Oracle, zextr.prm: No minimum supplemental logging is enabled. This may cause extract process to handle key up
date incorrectly if key column is not in first row piece.
2015-01-28 06:32:48 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, zextr.prm: PROCESS ABENDING.
Please help.....
Thanks,