ADG extract: Could not find archived log for sequence (Doc ID 2304772.1)

Last updated on SEPTEMBER 14, 2017

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.

Symptoms

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.

Cause

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