OGG extract process is abended due to the missing archive logs as showing in GG error log:
2023-01-21T01:19:23.197+1100 ERROR OGG-01028 Oracle GoldenGate Capture for Oracle, CAP01.prm: Could not find archived log for sequence 99 thread 2 under default destinations SQL <SELECT name FROM v$archived_log WHERE sequence# = :1 AND thread# = :2 AND resetlogs_id = :3 AND archived = 'YES' AND deleted = 'NO' AND standby_dest = 'NO' order by name DESC>, error retrieving redo file name for sequence 99, archived = 1, use_alternate = 0.
You can restore the missing archive logs using RMAN from tape backup if they are still available, then restart the extract process.
Otherwise we have to skip the archive log, certainly the data might be missed due to skipping the log files. In this case, let OGG to skip logfile by issuing following command:
GGSCI >ALTER EXTRACT CAP01, extseqno 100
Sometimes we can skip the transactions based on date and time, like :
GGSCI> ALTER EXTRACT CAP01 BEGIN 2024-02-24 15:00
Make DBA Life Easy 