• Home
    • 2018
    • 2017
  • Oracle GoldenGate
    • Core Platform
    • Cloud Service
    • For Oracle DB
    • For Big Data
    • For MySQL
    • For DB2 z/OS
    • For DB2 LUW
    • For DB2 i
    • For Informix
    • For SQL Server
    • For Teradata
    • For AWS Aurora
    • Foundation Suite
    • Use Cases
  • Data Management
    • General
    • Big Data
    • Oracle Database
    • MySQL
    • MS SQL Server
    • IBM DB2
    • IBM Informix
    • Teradata
    • SAP ASE
  • Data Science
  • IT
    • IT Management
    • IT Technology
  • Reading
  • About
Jinyu's Blog
About Data, Database, Integration and IT 

Oracle GoldenGate Heartbeat Table

4/6/2018

0 Comments

 
Starting Oracle GoldenGate 12.2, heartbeat table is provided within Oracle GoldenGate. Loren wrote an A-Team blog on this, I would not repeat. Please refer to his paper at:
  • ​Oracle GoldenGate: Integrated Heartbeat  by Loren Penton, 12/18/2017. 
The following are some highlights:
  • You need to specify a schema (in GLOBALS file) both on the source and the target to store the heartbeat tables.
  • You can enable or disable heartbeat table feature with ENALBEL_HEARTBEAT_TABLE | DISABLE_HEARTBEAT_TABLE in extract/replicat process or per instance using GLOBALS. 
  • The database user managing the heartbeat tables should have sufficient privileges to create tables, views, and scheduler jobs within this schema.
  • You can add heartbeat table with GGSCI add heartbeat table command. You can specify the how often the heartbeat tables are updated (60 seconds by default), how long data retained in the heartbeat table (30 days by default) and how often the data is purged (1 day by default). 
  • GoldenGate processes have to restart to use the heartbeat feature. 
  • You can login to the Oracle GoldenGate schema and run the GGSCI lag rtpc command to check the end-to-end lag. 
Resources 
  1. Oracle GoldenGate 12.2 Documentation 12.2: ​18.4 Using Automatic Heartbeat Tables to Monitor
0 Comments

    Oracle GoldenGate

    This blog has updates, tips and tricks for Oracle GoldenGate.

    Categories

    All
    12.1 New Feature
    12.2 New Feature
    12.3 New Feature
    Azure
    Basic Concepts
    Best Practices
    Cloud
    Customer Story
    DB2 For ISeries
    DB2 For LUW
    DB2 For Z/OS
    Disaster Recovery
    Globalization
    GoldenGate Fundamentals
    GoldenGate Security
    How To
    HP NonStop
    Informix IDS
    Installation
    JD_Edward
    Manager
    MySQL
    Network
    News
    Oracle DB
    Release
    SQL Server
    Sybase
    Teradata
    Top
    Troubleshooting
    Tutorial
    Use Case
    User Story

    Archives

    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017
    April 2017
    March 2017
    February 2017
    January 2017
    December 2016
    November 2016
    October 2016
    September 2016
    May 2016
    April 2016
    March 2016
    February 2016
    December 2015
    November 2015
    October 2015
    July 2015
    June 2015
    May 2015
    March 2015
    February 2015
    December 2014
    November 2014
    October 2014
    September 2014
    August 2014
    October 2013

    RSS Feed

Copyright © 2010-2027 Jinyu Wang.