GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

How to resolve lag issue

edited Oct 22, 2018 9:05AM in GoldenGate, Streams and Distributed Database (MOSC) 7 commentsAnswered ✓

Hello Gurus,

I'm facing a weird issue and need help with troubleshooting the info command shows lag of 50 hours . How to make sure that GG extract start processing the records from source again?

[oracle@lnx3 ogg12c]$ ./ggsciOracle GoldenGate Command Interpreter for OracleVersion 12.1.2.1.11 21831216 OGGCORE_12.1.2.1.0OGGBP_PLATFORMS_151121.0201.1_FBOLinux, x64, 64bit (optimized), Oracle 12c on Mar  2 2016 11:46:42Operating system character set identified as UTF-8.Copyright (C) 1995, 2016, Oracle and/or its affiliates. All rights reserved.GGSCI (lnx3.etslan.org) 1> info allProgram     Status      Group       Lag at Chkpt  Time Since ChkptMANAGER     RUNNINGEXTRACT     RUNNING     EODOAMFT    51:03:07      00:00:06EXTRACT     RUNNING     EODOAMPT    00:00:05      00:00:07EXTRACT     RUNNING     PODOAMFT    00:00:00      00:00:08EXTRACT     RUNNING     PODOAMPT    00:00:00      00:00:08GGSCI (lnx3.etslan.org) 2>GGSCI (lnx3) 2> lag EODOAMFTSending GETLAG request to EXTRACT EODOAMFT ...No records yet processed.GGSCI (lnx3) 3> send EODOAMFT statusSending STATUS request to EXTRACT EODOAMFT ...EXTRACT EODOAMFT (PID 7227)  Current status: In recovery[1]: Processing

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center