===================
General
===================
Golden Gate REPLICAT is not working
In the status, REPLICATE is RUNNING
But no data is getting replicated
How to troubleshoot and fix
===================
Troubleshoot and Fix
===================
GGSCI (my_server) 1> INFO ALL
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING DPM_I_01 00:00:00 00:00:01
EXTRACT RUNNING DPM_N_01 00:00:00 00:00:06
EXTRACT RUNNING DPM_P_01 00:00:00 00:00:00
EXTRACT RUNNING DPM_S_01 00:00:00 00:00:01
EXTRACT RUNNING EXT_I_01 00:00:00 00:00:05
EXTRACT RUNNING EXT_N_01 00:00:00 00:00:01
EXTRACT RUNNING EXT_P_01 00:00:00 00:00:04
EXTRACT RUNNING EXT_S_01 00:00:03 00:00:04
REPLICAT RUNNING REP_I_01 00:00:00 00:00:06
REPLICAT RUNNING REP_N_01 00:00:00 00:00:03
REPLICAT RUNNING REP_P_01 00:00:00 00:00:06
REPLICAT RUNNING REP_S_01 00:00:00 00:00:08
GGSCI (my_server) 1> SEND REPLICAT REP_N_01 STATS
Sending STATS request to REPLICAT REP_N_01 ...
No active replication maps.
Integrated Replicat Statistics:
Total transactions 0.00
Redirected 0.00
Replicated procedures 0.00
DDL operations 0.00
Stored procedures 0.00
Datatype functionality 0.00
Operation type functionality 0.00
Event actions 0.00
Direct transactions ratio 0.00%
GGSCI (my_server) 1> INFO REP_N_01
REPLICAT REP_N_01 Last Started 2021-11-28 10:06 Status RUNNING
INTEGRATED
Checkpoint Lag 00:00:00 (updated 00:00:00 ago)
Process ID 31883
Log Read Checkpoint File /software/ogg/191/dirdat/01/in/en000000000
First Record RBA 0
oracle@qanfv-2-dbs-01:/software/ogg/191/dirdat/01/in>% ls -ltr | grep en
-rw-r----- 1 oracle dba 499997601 Aug 1 08:01 en000007644
-rw-r----- 1 oracle dba 499999336 Aug 1 08:03 en000007645
-rw-r----- 1 oracle dba 499997863 Aug 1 08:04 en000007646
-rw-r----- 1 oracle dba 499999493 Aug 1 08:06 en000007647
-rw-r----- 1 oracle dba 499998290 Aug 1 08:08 en000007648
-rw-r----- 1 oracle dba 499995601 Aug 1 08:10 en000007649
-rw-r----- 1 oracle dba 499997099 Aug 1 08:11 en000007650
-rw-r----- 1 oracle dba 499996252 Aug 1 08:13 en000007651
-rw-r----- 1 oracle dba 499996558 Aug 1 08:16 en000007652
-rw-r----- 1 oracle dba 499997959 Aug 1 08:18 en000007653
-rw-r----- 1 oracle dba 499998548 Aug 1 08:19 en000007654
-rw-r----- 1 oracle dba 331578832 Aug 1 08:38 en000007655
-rw-r----- 1 oracle dba 499999030 Aug 1 08:46 en000007656
-rw-r----- 1 oracle dba 499999386 Aug 1 08:48 en000007657
-rw-r----- 1 oracle dba 159395611 Nov 28 10:06 en000007658
-rw-r----- 1 oracle dba 5460356 Nov 28 11:56 en000007659
GGSCI (my_server) 2> STOP REPLICAT REP_N_01
Sending STOP request to REPLICAT REP_N_01 ...
Request processed.
GGSCI (my_server) 3> ALTER REPLICAT REP_N_01, EXTSEQNO 7658
2021-11-28 11:59:33 INFO OGG-06594 Replicat REP_N_01 has been altered. Even the start up position might be updated, duplicate suppression remains active in next startup. To override duplicate suppression, start REP_N_01 with NOFILTERDUPTRANSACTIONS option.
REPLICAT altered.
GGSCI (my_server) 8> START REPLICAT REP_N_01
Sending START request to MANAGER ...
REPLICAT REP_N_01 starting
GGSCI (my_server) 11> INFO REPLICAT REP_N_01
REPLICAT REP_N_01 Last Started 2021-11-28 12:02 Status RUNNING
INTEGRATED
Checkpoint Lag 00:00:00 (updated 00:00:20 ago)
Process ID 15945
Log Read Checkpoint File /software/ogg/191/dirdat/01/in/en000007658
First Record RBA 0
GGSCI (my_server) 12> SEND REPLICAT REP_N_01 STATS
Sending STATS request to REPLICAT REP_N_01 ...
Start of Statistics at 2021-11-28 12:03:13.
Integrated Replicat Statistics:
Total transactions 3.00
Redirected 0.00
Replicated procedures 0.00
DDL operations 0.00
Stored procedures 0.00
Datatype functionality 0.00
Operation type functionality 0.00
Event actions 0.00
Direct transactions ratio 0.00%
Replicating from LAB_QANFV_ALLQQ.SGA_W_IPN_SUBSCRIBER to LAB_QANFV_ALLQQ.SGA_W_IPN_SUBSCRIBER:
*** Total statistics since 2021-11-28 12:03:06 ***
Total inserts 0.00
Total updates 0.00
Total deletes 0.00
Total upserts 0.00
Total discards 0.00
Total ignores 1181.00
Total operations 0.00
*** Daily statistics since 2021-11-28 12:03:06 ***
Total inserts 0.00
Total updates 0.00
Total deletes 0.00
Total upserts 0.00
Total discards 0.00
Total ignores 1181.00
Total operations 0.00
*** Hourly statistics since 2021-11-28 12:03:06 ***
Total inserts 0.00
Total updates 0.00
Total deletes 0.00
Total upserts 0.00
Total discards 0.00
Total ignores 1181.00
Total operations 0.00
*** Latest statistics since 2021-11-28 12:03:06 ***
Total inserts 0.00
Total updates 0.00
Total deletes 0.00
Total upserts 0.00
Total discards 0.00
Total ignores 1181.00
Total operations 0.00
End of Statistics.
Issue is fixed.
No comments:
Post a Comment