GoldenGate Extract Abends With "Out Of Order SCN" Error (Doc ID 2553299.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

Oracle goldengate v12.2.0.1.1 classic extract is abending with "OGG-02244 Error reading LCR from TranLog data source. Out of order SCN". 

***********************************************************************

Oracle GoldenGate Capture for Oracle

Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO

AIX 6, ppc, 64bit (optimized), Oracle 12c on Jan 22 2016 01:26:58

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

Starting at 2019-06-09 05:21:22

***********************************************************************

Database Version:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

PL/SQL Release 12.1.0.2.0 - Production

CORE 12.1.0.2.0 Production

TNS for IBM/AIX RISC System/6000: Version 12.1.0.2.0 - Production

NLSRTL Version 12.1.0.2.0 - Production

Source Context :

SourceModule : [er.extract.processloop]

SourceID : [<path>/processloop.cpp]

SourceFunction : [ggs::er::ExtractContext::processExtractLoop()]

SourceLine : [477]

2019-06-09 05:21:41 ERROR OGG-02171 Error reading LCR from data source. Status 500, data source type 3.

Source Context :

SourceModule : [er.redo.ora]

SourceID : [<PATH>/er/redo/oracle/redoora.c]

SourceFunction : [RedoCE::readLCR(CommonLCR **, int64_t &, bool &)]

SourceLine : [11395]

2019-06-09 05:21:41 ERROR OGG-02244 Error reading LCR from TranLog data source. Out of order SCN 1828.3098259290 (7854298476378) in record for sequence 839646 (last SCN 1828.3098259291 (7854298476379)).

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.