I-Extract Abends On Archive Log Older Than Begin Position OR Shows Incorrect Lag
Last updated on JANUARY 02, 2018
Applies to:Oracle GoldenGate - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
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
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
On investigation of the issue, the OS time zone for I-extract was found to be different than the source database OS time zone.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms