Golden Gate Extracts are in ABENDED state. Error: Missing Log File WAITING FOR REDO: FILE NA

Golden Gate Extracts are in ABENDED state with error:

ERROR   OGG-02870  Missing Log File WAITING FOR REDO: FILE NA, THREAD 1, SEQUENCE 0, SCN 0x00000003465f1e7d. Read Position SCN: 3.1180639857 (14065541745).
ERROR   OGG-01668  PROCESS ABENDING.

The Integrated Extract is "looking" for a archive log which was deleted, and cannot be recovered.

Option 1.

Start Integrated Extract now, need to unregister + register Extract.
This would mean loosing old transactions.

DBLOGIN USERID OGG PASSWORD XXXXXX

STOP EXTRACT EXT_S_01

UNREGISTER EXTRACT EXT_S_01 DATABASE

DELETE EXTRACT EXT_S_01

REGISTER EXTRACT EXT_S_01 DATABASE

ADD EXTRACT EXT_S_01 INTEGRATED TRANLOG, BEGIN NOW

ADD EXTTRAIL /software/ogg/191/dirdat/01/out/es EXTRACT EXT_S_01

START EXTRACT EXT_S_01

Option 2 - If archive log files are still available, restore archive logs via RMAN, and start Extract. But it might not be available, as in this example:

oracle@my_server:/oracle_db/db2/db_igt/arch>% rman target /

Recovery Manager: Release 12.2.0.1.0 - Production on Sun Jun 27 19:34:04 2021

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

connected to target database: IGT (DBID=1255688165)

RMAN> RESTORE ARCHIVELOG FROM SEQUENCE 297470 UNTIL SEQUENCE 297501;

Starting restore at 27-JUN-21

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=606 device type=DISK

archived log for thread 1 with sequence 297501 is already on disk as file /oracle_db/db2/db_igt/arch/arch0001_297501_1017403749.arc

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of restore command at 06/27/2021 19:34:12

RMAN-06026: some targets not found - aborting restore

RMAN-06025: no backup of archived log for thread 1 with sequence 297500 and starting SCN of 28088222868 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 297499 and starting SCN of 28088222153 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 297498 and starting SCN of 28088220469 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 297497 and starting SCN of 28088219284 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 297496 and starting SCN of 28088218181 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 297495 and starting SCN of 28088217156 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 297494 and starting SCN of 28088216516 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 297493 and starting SCN of 28088111765 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 297492 and starting SCN of 28088068835 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 297491 and starting SCN of 28088067820 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 297490 and starting SCN of 28088066631 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 297489 and starting SCN of 28088065907 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 297488 and starting SCN of 28088022437 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 297487 and starting SCN of 28088021554 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 297486 and starting SCN of 28088020909 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 297485 and starting SCN of 28088020341 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 297484 and starting SCN of 28088018858 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 297483 and starting SCN of 28088015844 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 297482 and starting SCN of 28087942561 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 297481 and starting SCN of 28087891891 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 297480 and starting SCN of 28087885099 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 297479 and starting SCN of 28087881524 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 297478 and starting SCN of 28087874736 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 297477 and starting SCN of 28087861817 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 297476 and starting SCN of 28087855120 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 297475 and starting SCN of 28087804793 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 297474 and starting SCN of 28087802216 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 297473 and starting SCN of 28087790188 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 297472 and starting SCN of 28087787782 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 297471 and starting SCN of 28087774056 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 297470 and starting SCN of 28087770060 found to restore