Replicat processes hangs and you see time since last checkpoint just increase (Doc ID 1426286.1)

Last updated on AUGUST 10, 2023

Applies to:

Symptoms

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
BEGIN
IF IsReplicationDML = 'TRUE' THEN return; END IF;
:new.AUD_UPDATE_TS := systimestamp;
END;
/*  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

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.