ADG extract: Could not find archived log for sequence
(Doc ID 2304772.1)
Last updated on DECEMBER 19, 2019
Applies to:Oracle GoldenGate - Version 22.214.171.124.0 and later
Generic (Platform Independent)
Customer reported that in their ADG extract they were getting below message very often:
ERROR OGG-01028 Oracle GoldenGate Capture for Oracle, esvmulti.prm: Could not find archived log for sequence 316190 thread 1 under default destinations SQL <SELECT name FROM v$archived_log WHERE sequence# = :ora_seq_no AND thread# = :ora_thread AND resetlogs_id = :ora_resetlog_id AND archived = 'YES' AND deleted = 'NO' >, error retrieving redo file name for sequence 316190, archived = 1, use_alternate = 0.
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