Skip to Main Content
Forums

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

OGG-01668 Oracle GoldenGate Capture for Oracle, zextr.prm: PROCESS ABENDING

unknown-2698904Jan 28 2015 — edited Jan 28 2015

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,

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 25 2015
Added on Jan 28 2015
#goldengate
6 comments
6,306 views