Issue
Golden Gate Datapump is not pushing the files to remote host.
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
