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 22.214.171.124.0 and later
Information in this document applies to any platform.
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
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