Replicat processes hangs and you see time since last checkpoint just increase
(Doc ID 1426286.1)
Last updated on FEBRUARY 03, 2020
Applies to:Oracle GoldenGate - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 11.1.1 to 126.96.36.199]
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 SCHEMANAME.TRIGGERNAME#UPD BEFORE
UPDATE ON "SCHEMANAME"."XXXXXTEST"
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 [SCHEMANAME], objname [TRIGGERNAME].
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document