Pages

Sunday, June 18, 2023

Data Pump Extract STATS "No active extraction maps". - 2nd case

GGSCI 258> SEND DPM_S_01 STATS
Sending STATS request to EXTRACT DPM_S_01 ...
No active extraction maps.

GGSCI 259> SEND DPM_S_01 STATUS
Sending STATUS request to EXTRACT DPM_S_01 ...
EXTRACT DPM_S_01 (PID 5923)
  Current status: In recovery[1]: At EOF
  Current read position:
  Sequence #: 0
  RBA: 0
  Timestamp: Not Available
  Extract Trail: /software/ogg/191/dirdat/01/out/es  < local server:  /software/ogg/191/dirdat/01/out/es000032125
  Current write position:
  Sequence #: 0
  RBA: 0
  Timestamp: 2023-06-18 16:33:50.811444
  Extract Trail: /software/ogg/191/dirdat/01/in/es


GGSCI 264> STOP EXTRACT DPM_S_01 (or SEND EXTRACT DPM_S_01, FORCESTOP )
GGSCI 265> ALTER EXTRACT DPM_S_01, EXTSEQNO 32125 EXTRBA 0

GGSCI 266> START EXTRACT DPM_S_01

GGSCI 267> SEND DPM_S_01 STATUS

Sending STATUS request to EXTRACT DPM_S_01 ...
EXTRACT DPM_S_01 (PID 3307)
  Current status: Recovery complete: At EOF
  Current read position:
  Sequence #: 32125
  RBA: 120958
  Timestamp: 2023-06-18 19:17:46.000000
  Extract Trail: /software/ogg/191/dirdat/01/out/es
  Current write position:
  Sequence #: 63213
  RBA: 123599
  Timestamp: 2023-06-18 19:18:29.275072
  Extract Trail: /software/ogg/191/dirdat/01/in/es

No comments:

Post a Comment