The following error occurs when an extract is started today:
22:41:02 ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, e1_rks2. prm: cocould not find archived log for sequence 10770 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 10770, archived = 1, use_alternate = 0Not able to establish initial position for sequence 10770, rba 78960656.
22:41:02 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, e1_rks2. prm: process abending.
The reason is that the archived log required by extract has been cleared and is not in the directory specified by log_archive_dest. The solution is simple, you only need to copy the sequence from 10770 to the current archived log back to the log_archive_dest directory.