Ogg V12.3 Pump Not Pushing Heartbeat Records When Using Format Release 12.2 (Doc ID 2393206.1)

Last updated on JULY 18, 2023

Applies to:

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.region.organization.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 abc.*;

GGSCI (oradb.region.organization.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.region.organization.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 ABC.*;
Table GG.*;

GGSCI (oradb.region.organization.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

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