Alter Extract/Replicat With Incorrect Syntax Do Not Throw Error

(Doc ID 2341041.1)

Last updated on JANUARY 04, 2018

Applies to:

Oracle GoldenGate - Version 12.1.2.1.10 and later
Information in this document applies to any platform.

Symptoms

Alter extract/ replicat with incorrect syntax do not throw error and due to
this it gets incorrectly assigned to trail file 0

for ex:

EXTRACT EXPCL Last Started 2016-09-09 17:59 Status STOPPED
Checkpoint Lag 00:00:00 (updated 77:29:59 ago)
Log Read Checkpoint File ./dirdat/cl000002
2016-09-20 14:44:05.000000 RBA 3977853

GGSCI (celclnx1.us.oracle.com) 4> alter ext EXPCL, extseqno 02, extseqno 0
EXTRACT altered.

GGSCI (celclnx1.us.oracle.com) 6> info ext expcl, detail

EXTRACT EXPCL Initialized 2016-09-23 20:15 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:03:17 ago)
Log Read Checkpoint File ./dirdat/cl000000
First Record RBA 3977853

---

Here instead of using extrba use extseqno twice

alter ext EXPCL, extseqno 02, extrba 0


used


alter ext EXPCL, extseqno 02, extseqno 0

The extract got altered to trail file sequence 0 wherein it should have been 02.
As it does not generate any syntax error, it went unnoticed that extrba was not used and later found data discrepency issues in the target.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms