My Oracle Support Banner

Replicat: Data not getting applied to target due to incorrect SOURCECATALOG (Doc ID 2680808.1)

Last updated on JUNE 24, 2020

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.

Symptoms

This particular case, extract, pump and replicat were all running and current but no DMLs were actually being applied to the target database.

As seen from the checkpoint analysis:
EXTRACT <extname> Last Started 2020-06-04 17:54 Status RUNNING Checkpoint Lag 00:00:13 (updated 00:00:09 ago)
writing to Sequence #: 86 RBA: 205375147 Timestamp: 2020-06-11 12:03:12.881585 Extract Trail: <dir_path>/en Seqno Length: 9 Trail Type: EXTTRAIL

PUMP <pumpname> Last Started 2020-06-04 17:54 Status RUNNING Checkpoint Lag 00:00:00 (updated 00:00:08 ago)
reading from Sequence #: 86 RBA: 205375550 Timestamp: 2020-06-11 12:11:43.000000 Extract Trail: <dir_path>/en Seqno Length: 9
writing to Sequence #: 110 RBA: 216969644 Timestamp: 2020-06-11 12:12:50.015116 Extract Trail: ./dirdat/pn Seqno Length: 9 Trail Type: RMTTRAIL

REPLICAT <repname> Last Started 2020-06-08 22:42 Status RUNNING Checkpoint Lag 00:00:00 (updated 00:00:00 ago)
reading from Sequence #: 110 RBA: 216968836 Timestamp: 2020-06-11 11:50:56.701449 Extract Trail: dirdat/pn

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
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.