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

Last updated on JULY 18, 2023

Applies to:

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.

Changes

Cause

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