Golden Gate - No Replication, Datapump is broken, "No active extraction maps."

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

Issue

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

In Golden Gate

There is no error, but data is not replicating for one of tables defined for P flow

Checking EXTRACT  EXT_P_01 - seems OK

Checking EXTRACT  DPM_P_01 - is not OK - returns No active extraction maps.

Need to fix DPM_P_01

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

Details

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

GGSCI (my_host) 24>  INFO ALL
Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING
EXTRACT     RUNNING     DPM_I_01    00:00:00      00:00:00
EXTRACT     RUNNING     DPM_P_01    00:00:00      00:00:01
EXTRACT     RUNNING     DPM_S_01    00:00:00      00:00:01
EXTRACT     RUNNING     EXT_I_01    00:00:01      00:00:00
EXTRACT     RUNNING     EXT_P_01    00:00:01      00:00:03
EXTRACT     RUNNING     EXT_S_01    00:00:02      00:00:09
REPLICAT    RUNNING     REP_I_01    00:00:06      00:00:08
REPLICAT    RUNNING     REP_P_01    00:00:00      00:00:03
REPLICAT    RUNNING     REP_S_01    00:00:00      00:00:05

GGSCI (my_host) 26> SEND EXT_P_01 STATS

Sending STATS request to EXTRACT EXT_P_01 ...

Start of Statistics at 2022-03-21 13:50:18.

This return valid stats for Extract. EXT_P_01 seems to be OK

GGSCI (my_host) 10> SEND DPM_P_01 stats
Sending STATS request to EXTRACT DPM_P_01 ...
No active extraction maps.

Datapump DPM_P_01 is not handling transactions generated by EXT_P_01

GGSCI (my_host) 17> INFO DPM_P_01
EXTRACT    DPM_P_01  Last Started 2022-03-15 09:26   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:04 ago)
Process ID           5311
Log Read Checkpoint  File /software/ogg/191/dirdat/01/out/ep000000000
                     First Record  RBA 0

Actual files are with sequence 104 and higher

oracle@my_host:/software/ogg/191/dirdat/01/out>% ls -ltr | grep ep
-rw-r----- 1 oracle dba    467429 Mar 15 08:56 ep000000104
-rw-r----- 1 oracle dba 170266735 Mar 15 09:13 ep000000105
-rw-r----- 1 oracle dba   1084712 Mar 15 09:27 ep000000106
-rw-r----- 1 oracle dba 499999980 Mar 18 21:45 ep000000107
-rw-r----- 1 oracle dba 499999964 Mar 21 01:18 ep000000108
-rw-r----- 1 oracle dba 165503175 Mar 21 13:40 ep000000109

Need to sync datapump with actual files

STOP EXTRACT DPM_P_01
ALTER EXTRACT DPM_P_01, EXTSEQNO 104 EXTRBA 0
START DPM_P_01

GGSCI (my_host) 20> INFO DPM_P_01
EXTRACT    DPM_P_01  Last Started 2022-03-21 13:43   Status RUNNING
Checkpoint Lag       148:46:38 (updated 00:00:01 ago)
Process ID           25666
Log Read Checkpoint  File /software/ogg/191/dirdat/01/out/ep000000105
                     2022-03-15 08:57:01.000000  RBA 117859931

GGSCI (my_host) 21>  INFO DPM_P_01
EXTRACT    DPM_P_01  Last Started 2022-03-21 13:43   Status RUNNING
Checkpoint Lag       65:30:53 (updated 00:00:05 ago)
Process ID           25666
Log Read Checkpoint  File /software/ogg/191/dirdat/01/out/ep000000107
                     2022-03-18 20:12:57.000000  RBA 491824952

 
GGSCI (my_host) 25> INFO DPM_P_01
EXTRACT    DPM_P_01  Last Started 2022-03-21 13:43   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:09 ago)
Process ID           25666
Log Read Checkpoint  File /software/ogg/191/dirdat/01/out/ep000000109
                     2022-03-21 13:44:18.000000  RBA 166207382

Now it is running, and files sequence is advancing