Pages

Thursday, January 14, 2021

Golden Gate Extract Error: ERROR OGG-01091 Unable to open file

=========================
General
=========================
 Golden Gate Pump Extract Error
2021-01-14 14:29:10  ERROR   OGG-01091  Unable to open file "/software/ogg/191/dirdat/01/out/ep000000065" (error 2, No such file or directory)
Indeed, there is no such file. There is only file ep000000066.
Need to advance extract to read from existing file.
=========================
Solution
=========================
GGSCI (qanfv-2-dbs-01) 4> INFO ALL
Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING
EXTRACT     ABENDED     DPM_I_01    00:00:00      00:01:38
EXTRACT     STOPPED     DPM_P_01    00:00:00      00:00:19
> ALTER EXTRACT DPM_P_01, EXTSEQNO 66
EXTRACT altered.
> START DPM_P_01
Sending START request to MANAGER ...
EXTRACT DPM_P_01 starting
> INFO DPM_P_01
EXTRACT    DPM_P_01  Last Started 2021-01-14 14:34   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:07 ago)
Process ID           16129
Log Read Checkpoint  File /software/ogg/191/dirdat/01/out/ep000000066
                     2020-12-17 13:55:12.649300  RBA 294731942

Datapump
DBLOGIN USERID ogg PASSWORD pass
STOP DPM_I_01
ALTER EXTRACT DPM_I_01, EXTSEQNO 9789, EXTRBA 0
ALTER EXTRACT DPM_I_01 ETROLLOVER
START DPM_I_01

No comments:

Post a Comment