Golden Gate Datapump is not pushing the files to remote host

Issue
Golden Gate Datapump is not pushing the files to remote host.

Files are generated in source host but not pushed to target host

On source server, under dirdat/99/out/ there are many files

But on Target server, under dirdat/99/in/ there are no files

In General

Extract process -> writing files to dirdat/99/out on source server

Datapump process -> reading files from dirdat/99/out on source server on writing files to dirdat/99/in on target server

The EXTSEQNO on the source server, must be in sync between Extract and Datapump

To manually sync these values (after system downtime, corruption, etc)

Fix

for example - the group name is 07

check for first file name, in this case it was es000001016

DBLOGIN USERID USER PASSWORD PASSWORD

STOP EXTRACT DPM_S_07, FORCESTOP

ALTER EXTRACT DPM_S_07 EXTSEQNO 1016

ALTER EXTRACT DPM_S_07 EXTRBA 0

ALTER EXTRACT DPM_S_07 ETROLLOVER

START EXTRACT DPM_S_07

Now, check on the target server, under dirdat/07/in

es0000000xx files are starting to generate

These will be picked up by REPLICAT processes on the remote server

Note - that the sequence for the files on target server is not same as sequence of files on source server.

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

Note - without ETROLLOVER - it will not work!!! 

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

The Datapump Extract is not advancing to the next file.

29> INFO DPM_I_01

EXTRACT    DPM_I_01  Last Started 2022-11-14 16:58   Status ABENDED

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

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

                     First Record  RBA 499335302

30> ALTER EXTRACT DPM_I_01, EXTSEQNO, 9035 EXTRBA  0

31> START  DPM_I_01

32> INFO DPM_I_01

EXTRACT    DPM_I_01  Last Started 2022-11-14 16:58   Status RUNNING

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

Process ID           9995

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

                     First Record  RBA 0

33> INFO DPM_I_01

EXTRACT    DPM_I_01  Last Started 2022-11-14 16:58   Status ABENDED

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

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

                     First Record  RBA 499335302

Now with ETROLLOVER

65> INFO DPM_I_01

EXTRACT    DPM_I_01  Last Started 2022-11-14 17:04   Status ABENDED

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

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

                     First Record  RBA 499335302

66> ALTER EXTRACT DPM_I_01, EXTSEQNO 9035

EXTRACT altered.

67> ALTER EXTRACT DPM_I_01, EXTRBA  0

EXTRACT altered.

68> ALTER EXTRACT DPM_I_01, ETROLLOVER

2022-11-14 17:06:35  INFO    OGG-01520  Rollover performed.  For each affected output trail of Version 10 or higher format, after starting the source extract, issue ALTER EXTSEQNO for that trail's reader (either pump EXTRACT or REPLICAT) to move the reader's scan to the new trail file;  it will not happen automatically.

EXTRACT altered.

69> START DPM_I_01

Sending START request to MANAGER ...

EXTRACT DPM_I_01 starting

70> INFO DPM_I_01

EXTRACT    DPM_I_01  Last Started 2022-11-14 17:06   Status RUNNING

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

Process ID           346

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

                     First Record  RBA 0

71> INFO DPM_I_01

EXTRACT    DPM_I_01  Last Started 2022-11-14 17:06   Status RUNNING

Checkpoint Lag       00:28:05 (updated 00:00:02 ago)

Process ID           346

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

                     2022-11-14 16:38:59.000000  RBA 253484099