My Oracle Support Banner

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

Last updated on FEBRUARY 12, 2019

Applies to:

Oracle GoldenGate - Version 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.





To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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