ALTARCHIVELOGDEST Oracle GoldenGate Extract (Doc ID 1060870.1)

Last updated on JANUARY 13, 2017

Applies to:

Oracle GoldenGate - Version 9.5.1.87 and later
Information in this document applies to any platform.
***Checked for relevance on 07-Dec-2011***
***Checked for relevance on 03-Jun-2013***

Symptoms

User attempts to define two directories for alternate archive log locations. This is legal.
TRANLOGOPTIONS EXCLUDEUSER ggcds2, altarchivelogdest primary instance cdsdev01 /tmp, altarchivelogdest instance cdsdev01 /opt/oracle/oraarch
extract abends with error:
Warning: NLS_LANG is not set. Please refer to user manual for more information.
2010-01-14 16:09:35.033  Redo thread 1:
2010-01-14 16:09:35.033  Redo thread 1: Default destinations: count 1
2010-01-14 16:09:35.033  Redo thread 1: </opt/oracle/oraarch>
2010-01-14 16:09:35.033  Redo thread 1:
2010-01-14 16:09:35.033  Redo thread 1: Alternative destinations: count 2
2010-01-14 16:09:35.033  Redo thread 1: </tmp/>
2010-01-14 16:09:35.033  Redo thread 1: </opt/oracle/oraarch/>
2010-01-14 16:09:35.033  Redo thread 1:
2010-01-14 16:09:35.033  Redo thread 1: Default format <LOG%s_%t_%r.ARC>
2010-01-14 16:09:35.033  Redo thread 1:
2010-01-14 16:09:35.033  Redo thread 1: No alternative log format for thread 1 was established
2010-01-14 16:09:35.033  Redo thread 1:
2010-01-14 16:09:35.033  Redo thread 1: Alternative formats from other threads: count 0
2010-01-14 16:09:35.033  Redo thread 1: Not able to establish initial position for sequence 66, rba 1595920.
Moving the archived log to another directory (/opt/oracle) instead of /tmp caused to this work.  Not sure if it was the characteristics of /tmp or some other difference that allowed success.
GoldenGate Source Context :
 SourceModule            : [er.main]
 SourceID                : [$Id: //depot/releases/OpenSys/v10.4.0/src/app/er/rep.c#16 $]
 SourceFunction          : [extract_start_point]
 SourceLine              : [12000]
 ThreadBacktrace         : [6] elements
                         : [/opt/oracle/gg/extract(_ZN15CMessageContext16AddThreadContextEv+0x26) [0x604e86]]
                         : [/opt/oracle/gg/extract(_ZN15CMessageFactory13CreateMessageEP14CSourceContextjz+0x386) [0x5fd856]]
                         : [/opt/oracle/gg/extract [0x4c4fad]]
                         : [/opt/oracle/gg/extract(main+0x2cf) [0x4d7fdf]]
                         : [/lib64/libc.so.6(__libc_start_main+0xf4) [0x334801d8b4]]
                         : [/opt/oracle/gg/extract(__gxx_personality_v0+0x471) [0x45f169]]
2010-01-14 16:09:35  GGS ERROR       500  error 22 (Invalid argument) opening redo log /tmp/LOG66_1_696028620.ARC for sequence 66Not
able to establish initial position for sequence 66, rba 1595920.
2010-01-14 16:09:35  GGS ERROR       190  PROCESS ABENDING.

Cause

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