=========================
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
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