Datapump Extract - not running. How to restart
DBLOGIN USERID OGG PASSWORD XXXXXXX
GGSCI (qanfv-2-dbs-01) 58> INFO DPM_S_01 DETAIL
EXTRACT DPM_S_01 Last Started 2022-08-29 08:30 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:04 ago)
Process ID 15414
Log Read Checkpoint File /software/ogg/191/software/ogg/191/dirdat/01/out/es000000000
First Record RBA 0
==================
Drop and create
==================
STOP EXTRACT dpm_s_01
DELETE EXTRACT dpm_s_01
ADD EXTRACT dpm_s_01 EXTTRAILSOURCE /software/ogg/191/dirdat/01/out/es
ADD RMTTRAIL /software/ogg/191/dirdat/01/in/es EXTRACT dpm_s_01
START EXTRACT dpm_s_01
==================
Resync
==================
Might need to reset the extract to the correct file
GGSCI (qanfv-2-dbs-01) 59> INFO DPM_S_01
EXTRACT DPM_S_01 Last Started 2022-08-29 09:12 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:00 ago)
Process ID 23093
Log Read Checkpoint File /software/ogg/191/dirdat/01/out/es000000000
First Record RBA 0
oracle@qanfv-2-dbs-01:/software/ogg/191>% ls -l /software/ogg/191/dirdat/01/out/es*
-rw-r----- 1 oracle dba 12194 Aug 29 08:15 /software/ogg/191/dirdat/01/out/es000008488
-rw-r----- 1 oracle dba 784527 Aug 29 09:14 /software/ogg/191/dirdat/01/out/es000008489
STOP EXTRACT DPM_S_01
ALTER EXTRACT DPM_S_01, EXTSEQNO 8488 EXTRBA 0
START DPM_S_01
SEND DPM_S_01 STATS
INFO DPM_S_01
GGSCI (qanfv-2-dbs-01 as OGG@igt) 69> INFO DPM_S_01
EXTRACT DPM_S_01 Last Started 2022-08-29 09:20 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:03 ago)
Process ID 24073
Log Read Checkpoint File /software/ogg/191/dirdat/01/out/es000008489
2022-08-29 09:20:07.000000 RBA 790916
No comments:
Post a Comment