My Oracle Support Banner

Re-starting ODI Journal Drops All J$ Tables in Consistent Set (Doc ID 2690385.1)

Last updated on AUGUST 30, 2023

Applies to:

Oracle Data Integrator - Version 12.2.1.3.0 and later
Information in this document applies to any platform.

Symptoms

When adding a model to an existing (Changed Data Capture) CDC Consistent Set Journalization with knowledge module "JKM Oracle to Oracle Consistent (OGG Online)" on Oracle Data Integrator (ODI) 12.2.1.3.0, all the existing J$ tables are dropped after the Journal "restart". 

This behavior contradicts the ODI documentation where it is indicated that the Consistent Set JKMs support restarting the journals without losing any data.

Developing Integration Projects with Oracle Data Integrator
Setting up and Starting Journalizing
https://docs.oracle.com/en/middleware/fusion-middleware/data-integrator/12.2.1.4/odidg/using-journalizing.html#GUID-0A9704B5-2CC7-4C0A-ACF3-36198C4DF39E

In the section 'Start/Drop the journals' the following is mentioned:

Note: Dropping the journals deletes all captured changes as well as the infrastructure. For simple journalizing, starting the journal in addition deletes the journal contents. Consistent Set JKMs support restarting the journals without losing any data.

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
References


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