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

Last updated on DECEMBER 19, 2019

Applies to:

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

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