Thursday, March 3, 2016

ERROR OGG-01705 Input checkpoint position for input trail file is greater than the size of the file

Pump, Extract or Replicat may get stuck on a trail file even if there are more trail files available in machine for the reader object to process. This issue occurs when the pump extract / Replicat read checkpoint RBA is larger than the local trail file size that it reads.
Here my Replicat got abended with the following error message …….

ERROR   OGG-01705  Input checkpoint position 33144618 for input trail file './dirdat/c4001256' is greater than the size of the file (33079717).  Please consult Oracle Knowledge Management Doc ID 1138409.1. for instructions.


GGSCI (oracledev01) 9> info REPDEV

REPLICAT   REPDEV  Last Started 2016-03-01 19:10   Status ABENDED
Checkpoint Lag       00:00:00 (updated 240:44:11 ago)
Log Read Checkpoint  File ./dirdat/c4001256
                     2016-02-20 19:19:49.000207  RBA 33144618

Now let’s check the trail file size…………

 [oracle@oracledev01 GG11]$ ls -l dirdat/c4001256
-rw-r----- 1 oracle oinstall 33079717 Feb 22 11:48 dirdat/c4001256

From above we can see that RBA is greater than the trail file size

FILTERDUPTRANSACTIONS
When using this option to start the replicat, it will use the information already stored in the checkpoint table and filter out transactions already applied.
This option is valid only for Replicat in nonintegrated mode. Integrated mode handles duplicate transactions transparently.

[oracle@oracledev01 GG11]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.14 17547423 OGGCORE_11.2.1.0.0OGGBP_PLATFORMS_131022.0605_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Oct 22 2013 11:03:39
Copyright (C) 1995, 2013, Oracle and/or its affiliates. All rights reserved.

GGSCI (oracledev01) 1> start replicat REPDEV FILTERDUPTRANSACTIONS
Sending START request to MANAGER ...
REPLICAT REPDEV starting

GGSCI (oracledev01) 2> info REPDEV
REPLICAT   REPDEV  Last Started 2016-03-01 20:06   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:04 ago)
Log Read Checkpoint  File ./dirdat/c4001257
                                         First Record  RBA 0


GGSCI (oracledev01) 3> info REPDEV
REPLICAT   REPDEV  Last Started 2016-03-01 20:06   Status RUNNING
Checkpoint Lag       240:46:27 (updated 00:00:03 ago)
Log Read Checkpoint  File ./dirdat/c4001257
                   2016-02-20 19:19:57.964167  RBA 276602

From the above we can see my replicat has moved on to the next trail file “c4001257” and it is up and running fine J

Refer:

OGG Extract / Replicat Checkpoint RBA Is Larger than Local Trail Size (Doc ID 1138409.1)

0 comments:

Post a Comment

Auto Scroll Stop Scroll