ADG extract: Could not find archived log for sequence
Last updated on SEPTEMBER 14, 2017
Applies to:Oracle GoldenGate - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
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.
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