OGG extract configured to read from remote archive fails
Last updated on NOVEMBER 28, 2016
Applies to:Oracle GoldenGate - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
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.
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