My Oracle Support Banner

I-Extract Abends On Archive Log Older Than Begin Position OR Shows Incorrect Lag (Doc ID 2332202.1)

Last updated on JANUARY 02, 2018

Applies to:

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

Symptoms

In an Oracle GoldenGate (OGG) environment with Integrated extract and incorrectly set OS time zone:

a) I-extract created or altered to BEGIN NOW:     ADD EXTRACT <extract_name>, INTEGRATED TRANLOG, BEGIN NOW
will abend if looking for archive log files that are older than the extract registration.  An example error:  ORA-00308: cannot open archived log '+ARCHLOG/ORCTL_1_18359_846435713.arc'

b) lag for I-extract can be misreported as too large a value, even when there is no true lag


ggsci> info all

Program Status       Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING   EXT1     05:00:03     00:00:03
EXTRACT RUNNING   EXT2     05:00:03     00:00:09
EXTRACT RUNNING   PMP1    05:00:04     00:00:03
EXTRACT RUNNING   PMP2    05:00:03     00:00:03

Changes

 On investigation of the issue, the OS time zone for I-extract was found to be different than the source database OS time zone.

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
Changes
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.