Golden gate DATAPUMP is not working

 ===================

General

===================

Golden Gate DATAPUMP is not working

In the status, DATAPUMP is RUNNING

But no data is getting replicated

How to troubleshoot and fix

===================

Troubleshoot and Fix

===================

GGSCI (my_server) 1> INFO ALL

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

EXTRACT     RUNNING     DPM_I_01    00:00:00      00:00:01

EXTRACT     RUNNING     DPM_N_01    00:00:00      00:00:06

EXTRACT     RUNNING     DPM_P_01    00:00:00      00:00:00

EXTRACT     RUNNING     DPM_S_01    00:00:00      00:00:01

EXTRACT     RUNNING     EXT_I_01    00:00:00      00:00:05

EXTRACT     RUNNING     EXT_N_01    00:00:00      00:00:01

EXTRACT     RUNNING     EXT_P_01    00:00:00      00:00:04

EXTRACT     RUNNING     EXT_S_01    00:00:03      00:00:04

REPLICAT    RUNNING     REP_I_01    00:00:00      00:00:06

REPLICAT    RUNNING     REP_N_01    00:00:00      00:00:03

REPLICAT    RUNNING     REP_P_01    00:00:00      00:00:06

REPLICAT    RUNNING     REP_S_01    00:00:00      00:00:08

GGSCI (my_server) 6> SEND EXTRACT DPM_N_01 STATS

Sending STATS request to EXTRACT DPM_N_01 ...

No active extraction maps.

GGSCI (my_server as OGG@igt) 10> INFO DPM_N_01

EXTRACT    DPM_N_01  Last Started 2021-11-28 10:06   Status RUNNING

Checkpoint Lag       00:00:00 (updated 00:00:04 ago)

Process ID           31970

Log Read Checkpoint  File /software/ogg/191/dirdat/01/out/en000000000

                     First Record  RBA 0

GGSCI (my_server as OGG@igt) 11> DBLOGIN USERID OGG PASSWORD XXXXX

GGSCI (my_server as OGG@igt) 12> INFO EXT_N_01 DETAIL

  Trail Name                                       Seqno        RBA     Max MB Trail Type

  /software/ogg/191/dirdat/01/out/en                  10     198769        500 EXTTRAIL

GGSCI (my_server as OGG@igt) 14> SEND EXTRACT DPM_N_01, FORCESTOP

Sending FORCESTOP request to EXTRACT DPM_N_01 ...

STOP request will be executed immediately (recovery aborted).

GGSCI (my_server as OGG@igt) 15> STOP EXTRACT DPM_N_01

EXTRACT DPM_N_01 is already stopped.

GGSCI (my_server as OGG@igt) 16> ALTER EXTRACT DPM_N_01, EXTSEQNO 10 EXTRBA 198769

EXTRACT altered.

GGSCI (my_server as OGG@igt) 17> START DPM_N_01

Sending START request to MANAGER ...

EXTRACT DPM_N_01 starting

GGSCI (my_server as OGG@igt) 18> INFO DPM_N_01

EXTRACT    DPM_N_01  Last Started 2021-11-28 13:02   Status RUNNING

Checkpoint Lag       00:00:00 (updated 00:00:06 ago)

Process ID           23935

Log Read Checkpoint  File /software/ogg/191/dirdat/01/out/en000000010

                     First Record  RBA 198769

GGSCI (my_server as OGG@igt) 19>  INFO DPM_N_01

EXTRACT    DPM_N_01  Last Started 2021-11-28 13:02   Status RUNNING

Checkpoint Lag       00:00:00 (updated 00:00:03 ago)

Process ID           23935

Log Read Checkpoint  File /software/ogg/191/dirdat/01/out/en000000010

                     2021-11-28 13:02:07.000000  RBA 203030

Now the RBA in Datapump is advancing