My Oracle Support Banner

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 11.1.1.0.0 to 11.1.1.1.0 [Release 11.1.1 to 11.1.1.1]
Information in this document applies to any platform.
Add ***Checked for relevance on 20-Aug-2013***

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

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
Symptoms
Changes
Cause
Solution


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