OGG extract configured to read from remote archive fails (Doc ID 2081473.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms

When using Dblogreader, the extract is capable of reading from remote REDO but fails when reading from archives.
When the extract is configured to read from remote archive, it fails with error similar to

2015-10-14 19:43:32 ERROR OGG-00446 Could not find archived log for sequence 1271 thread 1 under default destinations
SQL <SELECT name FROM v$archived_l og WHERE sequence# = :ora_seq_no AND thread# = :ora_thread AND resetlogs_id = :ora_resetlog_id
AND archived = 'YES' AND deleted = 'NO' AND standby_dest = 'NO' order by name DESC>, error retrieving redo file name for
sequence 1271, archived = 1, use_alternate = 0Not able to establish initial position for sequence 1271, rba 39440.

 

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