Replicat processes hangs and you see time since last checkpoint just increase
Last updated on JULY 17, 2017
Applies to:Oracle GoldenGate - Version 126.96.36.199.0 to 188.8.131.52.0 [Release 11.1.1 to 184.108.40.206]
Information in this document applies to any platform.
Add ***Checked for relevance on 20-Aug-2013***
The Replicat process will hang and you will see the time since last checkpoint increasing.
When you have DDLOPTIONS Report enabled, you will see that the last details in the report file were something like this where a CREATE or REPLACE TRIGGER statement had been done.
the last messages in your replicat were
2012-01-27 19:37:23 INFO OGG-00482 DDL found, operation [CREATE OR REPLACE TRIGGER MAC.CORPORATE#UPD BEFORE
UPDATE ON "MAC"."CORPORATE"
REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW
IF IsReplicationDML = 'TRUE' THEN return; END IF;
:new.AUD_UPDATE_TS := systimestamp;
/* This is comment code
END; (size 1999)].
2012-01-27 19:37:23 INFO OGG-00490 DDL operation is of unmapped scope.
2012-01-27 19:37:23 INFO OGG-00488 DDL operation excluded [EXCLUDE ALL], optype [CREATE], objtype [TRIGGER], objowner [MAC], objname [CORPORATE].
The replicat is in a Running status, with the time since last checkpoint increasing but the RBA is not changing.
The replicat process is not using CPU
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms