OGG-06601 Oracle GoldenGate Capture for Oracle, dodspu.prm: Mismatch between the length of seqno from checkpoint (9) and recovery (devil) for extract trail

Error: -

OGG-06601  Oracle GoldenGate Capture for Oracle, dodspu.prm:  

Mismatch between the length of seqno from checkpoint (9) and recovery (devil) for extract trail 

PUMP is Abended with Above Error on Source side . Golden Gate Version in Both Sides Are 12.2.0.1.1. 

Occurring Scenarios :- 

usually when system/cluster/db  maintenance happens on Target side  when properly not stopped GG during the period of maintenance You might Get into this scenario where PUMP will keep on Abend with Above error. 

On the Target System, process works fine, but not receive new trails, because pump process are abended.

GGSCI (lab2.learnwithmedb.net) 001> info SUNILRT01

REPLICAT SUNILRT01 Last Started 2017-03-20 12:08 Status RUNNING

Checkpoint Lag 00:00:00 (updated 00:00:09 ago)

Process ID 13563

Log Read Checkpoint File ./dirdat/rt000045

2017-04-09 09:53:31.004144 RBA 308786567545 

Go to the source system.

GGSCI (host) 010> info SUNILPU 

EXTRACT SUNILPU                               Status ABENDED

Checkpoint Lag 06:10:32 (updated 00:00:01 ago) 

Process ID 13213 

Log Read Checkpoint File ./dirdat/EX000130

2017-04-09 05:59:02.000012 RBA 238799 

Copy the red line above, to reposition extract process avoiding data loss.

GGSCI (host) 4> STOP SUNILEX

GGSCI (host) 4> ALTER SUNILEX ETROLLOVER

GGSCI (host) 5> ALTER SUNILEX BEGIN 2017-04-09 04:59:02.000012 ( from above output from info SUNILPU )

GGSCI (host) 6> START SUNILEX

GGSCI (host) 010> info SUNILPU

EXTRACT SUNILPU                               Status ABENDED

Checkpoint Lag 06:10:50 (updated 00:00:02 ago) 

Process ID 13213 

Log Read Checkpoint File ./dirdat/EX000130

2017-04-09 05:59:02.000012 RBA 238799 

Go ./dirdat/EX*, to find new trail generated by etrollover.

GGSCI (host) 010> sh ls -lart ./dirdat/EX* (use second red line copied)

-rw-r----- 1 oracle oinstall 83729605 Apr 22 00:12 ./dirdat/EX000127

-rw-r----- 1 oracle oinstall 83821063 Apr 22 00:35 ./dirdat/EX000128

-rw-r----- 1 oracle oinstall 99998927 Apr 22 01:52 ./dirdat/EX000129

-rw-r----- 1 oracle oinstall   563291 Apr 22 02:30 ./dirdat/EX000130

-rw-r----- 1 oracle oinstall     3291 Apr 22 06:52 ./dirdat/EX000131 (this is the new trail, genereted by etrollover)

GGSCI (host) 014> STOP SUNILPU

GGSCI (host) 015> ALTER SUNILPU extseqno 131 extrba 0

GGSCI (host) 016> START SUNILPU

After you perform above steps , check Pump and replicat process until they are online and running continuously.