Pages

Sunday, June 18, 2023

Data Pump is stuck at RBA: 0, Timestamp: Not Available

 
GGSCI 44> SEND DPM_S_01 STATUS
Sending STATUS request to EXTRACT DPM_S_01 ...
EXTRACT DPM_S_01 (PID 2637)
  Current status: Recovery complete: At EOF
  Current read position:
  Sequence #: 441
  RBA: 0
  Timestamp: Not Available
  Extract Trail: /software/ogg/191/dirdat/01/out/es
ALTER EXTRACT DPM_S_01, BEGIN NOW

GGSCI 45> INFO DPM_S_01

EXTRACT    DPM_S_01  Last Started 2023-06-18 20:12   Status STOPPED
Checkpoint Lag       00:00:00 (updated 00:00:03 ago)
Log Read Checkpoint  File /software/ogg/191/dirdat/01/out/es000000441
                     First Record  RBA 0

GGSCI 46> SEND DPM_S_01 STATUS

Sending STATUS request to EXTRACT DPM_S_01 ...
EXTRACT DPM_S_01 (PID 2637)
  Current status: Recovery complete: At EOF

  Current read position:
  Sequence #: 441
  RBA: 0
  Timestamp: Not Available
  Extract Trail: /software/ogg/191/dirdat/01/out/es

  Current write position:
  Sequence #: 63214
  RBA: 0
  Timestamp: 2023-06-18 20:14:21.631210
  Extract Trail: /software/ogg/191/dirdat/01/in/es


GGSCI 49> ALTER EXTRACT DPM_S_01, BEGIN NOW
EXTRACT altered.

GGSCI 50> START EXTRACT DPM_S_01
Sending START request to MANAGER ...
EXTRACT DPM_S_01 starting


EXTRACT    DPM_S_01  Last Started 2023-06-18 20:15   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:06 ago)
Process ID           7431
Log Read Checkpoint  File /software/ogg/191/dirdat/01/out/es000032125
                     2023-06-18 17:29:50.354524  RBA 181742

GGSCI 55> SEND DPM_S_01 STATUS
Sending STATUS request to EXTRACT DPM_S_01 ...
EXTRACT DPM_S_01 (PID 7431)
  Current status: Recovery complete: At EOF
  Current read position:
  Sequence #: 32125
  RBA: 182808
  Timestamp: 2023-06-18 20:15:46.000000
  Extract Trail: /software/ogg/191/dirdat/01/out/es
  Current write position:
  Sequence #: 63214
  RBA: 4759
  Timestamp: 2023-06-18 20:15:55.830421
  Extract Trail: /software/ogg/191/dirdat/01/in/es

No comments:

Post a Comment