Ogg V12.3 Pump Not Pushing Heartbeat Records When Using Format Release 12.2

(Doc ID 2393206.1)

Last updated on MAY 15, 2018

Applies to:

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

Symptoms

When using ogg v12.3 pump and Format release 12.2, the pump extract will not push the heartbeat records to the target but pushes all other table records.

for ex:

GGSCI (oradb.us.oracle.com) 1> view params ext2

EXTRACT ext2
USERID gg, PASSWORD gg
LOGALLSUPCOLS
UPDATERECORDFORMAT FULL
--DDL include mapped
EXTTRAIL ./dirdat/tm, format release 12.2
TABLE scott.*;

GGSCI (oradb.us.oracle.com) 3> stats ext2

Sending STATS request to EXTRACT EXT2 ...

Start of Statistics at 2017-11-20 02:15:06.

Output to ./dirdat/tm:

Extracting from GG.GG_HEARTBEAT to GG.GG_HEARTBEAT:

*** Total statistics since 2017-11-18 03:05:43 ***
Total inserts 0.00
Total updates 2830.00
Total deletes 0.00
Total discards 0.00
Total operations 2830.00

Extracting from GG.GG_HEARTBEAT_SEED to GG.GG_HEARTBEAT_SEED:

*** Total statistics since 2017-11-18 03:05:43 ***
Total inserts 0.00
Total updates 2830.00
Total deletes 0.00
Total discards 0.00
Total operations 2830.00
----

GGSCI (oradb.us.oracle.com) 2> view params pmp2

EXTRACT PMP2
PASSTHRU
RMTHOST localhost, mgrport 7809
rmttrail ./dirdat/rk
--RMTTRAIL ./dirdat/rk, FORMAT RELEASE 12.2
--RMTHOST localhost, mgrport 7809
TABLE SCOTT.*;
Table GG.*;

GGSCI (oradb.us.oracle.com) 4> stats pmp2

Sending STATS request to EXTRACT PMP2 ...

No active extraction maps.
====

The following warning is been seen in the pump report

2018-03-19 19:35:08 WARNING OGG-02555 Heartbeat table
OGGADMIN.GG_HEARTBEAT_SEED is not captured, because trail file format does
not support the heartbeat table.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms