================
Issue
================
In Golden Gate
There is no error, but data is not replicating for one of tables defined for P flow
Checking EXTRACT DPM_S_01 - is not OK, returns "No active extraction maps".
Need to fix DPM_S_01
================
Details
================
GGSCI (my_host) 24> INFO ALLProgram 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 DPM_S_01 STATS
Sending STATS request to EXTRACT DPM_S_01 ...
No active extraction maps.
GGSCI (my_host) 17> INFO DPM_S_01
EXTRACT DPM_S_01 Last Started 2022-03-21 15:35 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:03 ago)
Process ID 3497
Log Read Checkpoint File /software/ogg/191/software/ogg/191/dirdat/01/out/es000000475
First Record RBA 0
The path is not correct.
Need to unregister and register the datapump
DBLOGIN USERID OGG PASSWORD PASSWD
GGSCI (my_host as OGG@igt) 58> STOP EXTRACT DPM_S_01
Sending STOP request to EXTRACT DPM_S_01 ...
Request processed.
GGSCI (my_host as OGG@igt) 60> DELETE EXTRACT DPM_S_01
2022-03-21 15:55:35 INFO OGG-14052 No Heartbeat entries with [DPM_S_01], none deleted.
Deleted EXTRACT DPM_S_01.
GGSCI (my_host as OGG@igt) 61> ADD EXTRACT DPM_S_01 EXTTRAILSOURCE /software/ogg/191/dirdat/01/out/es
EXTRACT added.
GGSCI (qanfv-1-dbs-1a as OGG@igt) 63> ADD RMTTRAIL /software/ogg/191/dirdat/01/in/es EXTRACT DPM_S_01
RMTTRAIL added.
GGSCI (my_host as OGG@igt) 64> START EXTRACT DPM_S_01
Sending START request to MANAGER ...
EXTRACT DPM_S_01 starting
GGSCI (my_host as OGG@igt) 65> INFO DPM_S_01
EXTRACT DPM_S_01 Last Started 2022-03-21 15:56 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:02 ago)
Process ID 20942
Log Read Checkpoint File /software/ogg/191/dirdat/01/out/es000000000
First Record RBA 0
GGSCI (my_host as OGG@igt) 66> SEND EXTRACT DPM_S_01 STATS
Sending STATS request to EXTRACT DPM_S_01 ...
No active extraction maps.
Now the path is correct
But the sequence is 0 instead of actual 475
oracle@my_host:/software/ogg/191/dirprm>% ls -ltr /software/ogg/191/dirdat/01/out/ | grep es
-rw-r----- 1 oracle dba 29207662 Mar 21 15:58 es000000475
=========================
Setting sequence to correct value
=========================
GGSCI (my_host as OGG@igt) 67> STOP EXTRACT DPM_S_01
Sending STOP request to EXTRACT DPM_S_01 ...
Request processed.
GGSCI (my_host as OGG@igt) 68> ALTER EXTRACT DPM_S_01, EXTSEQNO 475 EXTRBA 0
EXTRACT altered.
GGSCI (my_host as OGG@igt) 69> START DPM_S_01
Sending START request to MANAGER ...
EXTRACT DPM_S_01 starting
GGSCI (my_host as OGG@igt) 70> SEND DPM_S_01 STATS
Sending STATS request to EXTRACT DPM_S_01 ...
Start of Statistics at 2022-03-21 16:03:33.
Now the response is fine
No comments:
Post a Comment