My Oracle Support Banner

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

Last updated on APRIL 17, 2023

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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