Pages

Thursday, January 27, 2022

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

No comments:

Post a Comment