Goldengate - OGG-01705 while starting Goldengate replicat

OGG-01705 while starting Goldengate Replicat

==============================================

Today after some disk space issue, machine went for abrupt reboot.

After reboot, replicat was not coming up.

[oracle@testing ggs]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 11.2.1.0.20 18227972 OGGCORE_11.2.1.0.0OGGBP_PLATFORMS_140727.2135.1_FBO

Linux, x64, 64bit (optimized), Oracle 11g on Oct  10 2016 03:02:15

Copyright (C) 1995, 2014, Oracle and/or its affiliates. All rights reserved.

GGSCI (testing.localdomain) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

REPLICAT    ABENDED     REPAJ01    00:00:00      00:24:58

-- Looking at ggserror.log, I see following error.

2016-10-10 03:16:51  ERROR   OGG-01705  Oracle GoldenGate Delivery for Oracle, REPAJ01.prm: 

Input checkpoint position 714293 for input trail file '/u02/gg/trail/dirdat/rb4358' is greater than the size of the file (699690). 

Please consult Oracle Knowledge Management Doc ID 1138409.1. for instructions.

2016-10-10 03:16:51  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, REPAJ01.prm:  PROCESS ABENDING.

-- Looking at info of replicat

GGSCI (testing.localdomain) 1> info REPAJ01

REPLICAT   REPAJ01  Last Started 2016-10-10 03:10   Status ABENDED

Checkpoint Lag       00:00:00 (updated 00:25:11 ago)

Log Read Checkpoint  File /u02/gg/trail/dirdat/rb4358

                     2016-10-10 03:00:41.002122  RBA 714293

RBA 714293 is greater than size of file rb4358 (699690)

So, it has reached EOF.

-- looking at trail file directories, I see trail files rb4358 as well as rb4359 available.

-rw-r----- 1 oracle dba 757548 Oct 10 07:52 /u02/gg/trail/dirdat/rb4355

-rw-r----- 1 oracle dba 767556 Oct 10 07:53 /u02/gg/trail/dirdat/rb4356

-rw-r----- 1 oracle dba 242212 Oct 10 08:14 /u02/gg/trail/dirdat/rb4357

-rw-r----- 1 oracle dba 699690 Oct 10 08:14 /u02/gg/trail/dirdat/rb4358

-rw-r----- 1 oracle dba 799872 Oct 10 08:14 /u02/gg/trail/dirdat/rb4359

-rw-r----- 1 oracle dba 699432 Oct 10 08:14 /u02/gg/trail/dirdat/rb4360

-- To get around this issue, workaround is provided in Oracle Doc ID 1536741.1  

GGSCI (testing.localdomain) 2> start replicat REPAJ01 filterduptransactions

Sending START request to MANAGER ...

REPLICAT REPAJ01 starting

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 solution is valid from OGG v11.2.1.07 onwards.

-- Checking the info

GGSCI (testing.localdomain) 4> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

REPLICAT    RUNNING     REPAJ01    00:00:00      00:00:00

-- Checking info of replicat

GGSCI (testing.localdomain) 33> info REPAJ01

REPLICAT   REPAJ01  Last Started 2016-10-10 04:31   Status RUNNING

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

Log Read Checkpoint  File /u02/gg/trail/dirdat/rb4371

                     2016-10-10 04:16:07.001048  RBA 734243

Hope that Helps.