Managing heartbeat in goldengate is important specially when it comes to monitor the lag and the heartbeat, this post covers how to add a heartbeat table at target, clean it up and reconfigure the heartbeat table
GGSCI (rhel7.example.com as ggadmin@euro) 3> add heartbeattable
2020-07-13 00:22:30 INFO OGG-14001 Successfully created heartbeat seed table ""GGADMIN"."GG_HEARTBEAT_SEED"".
2020-07-13 00:22:30 INFO OGG-14089 Successfully tracking extract restart position with heartbeat table ""GGADMIN"."GG_HEARTBEAT_SEED"".
2020-07-13 00:22:30 INFO OGG-14032 Successfully added supplemental logging for heartbeat seed table ""GGADMIN"."GG_HEARTBEAT_SEED"".
2020-07-13 00:22:30 INFO OGG-14000 Successfully created heartbeat table ""GGADMIN"."GG_HEARTBEAT"".
2020-07-13 00:22:30 INFO OGG-14089 Successfully tracking extract restart position with heartbeat table ""GGADMIN"."GG_HEARTBEAT"".
2020-07-13 00:22:30 INFO OGG-14033 Successfully added supplemental logging for heartbeat table ""GGADMIN"."GG_HEARTBEAT"".
2020-07-13 00:22:30 INFO OGG-14016 Successfully created heartbeat history table ""GGADMIN"."GG_HEARTBEAT_HISTORY"".
2020-07-13 00:22:30 INFO OGG-14089 Successfully tracking extract restart position with heartbeat table ""GGADMIN"."GG_HEARTBEAT_HISTORY"".
2020-07-13 00:22:30 INFO OGG-14086 Successfully disabled partitioning for heartbeat history table ""GGADMIN"."GG_HEARTBEAT_HISTORY"".
2020-07-13 00:22:30 INFO OGG-14023 Successfully created heartbeat lag view ""GGADMIN"."GG_LAG"".
2020-07-13 00:22:30 INFO OGG-14024 Successfully created heartbeat lag history view ""GGADMIN"."GG_LAG_HISTORY"".
2020-07-13 00:22:30 INFO OGG-14003 Successfully populated heartbeat seed table with "EURO".
2020-07-13 00:22:31 INFO OGG-14004 Successfully created procedure ""GGADMIN"."GG_UPDATE_HB_TAB"" to update the heartbeat tables.
2020-07-13 00:22:31 INFO OGG-14017 Successfully created procedure ""GGADMIN"."GG_PURGE_HB_TAB"" to purge the heartbeat history table.
2020-07-13 00:22:31 INFO OGG-14005 Successfully created scheduler job ""GGADMIN"."GG_UPDATE_HEARTBEATS"" to update the heartbeat tables.
2020-07-13 00:22:31 INFO OGG-14018 Successfully created scheduler job ""GGADMIN"."GG_PURGE_HEARTBEATS"" to purge the heartbeat history table.
GGSCI (rhel7.example.com as ggadmin@euro) 2> delete heartbeattable
2020-07-13 00:22:25 INFO OGG-14007 Heartbeat seed table ""GGADMIN"."GG_HEARTBEAT_SEED"" dropped.
2020-07-13 00:22:25 INFO OGG-14009 Heartbeat table ""GGADMIN"."GG_HEARTBEAT"" dropped.
2020-07-13 00:22:25 INFO OGG-14011 Heartbeat history table ""GGADMIN"."GG_HEARTBEAT_HISTORY"" dropped.
2020-07-13 00:22:25 INFO OGG-14026 Heartbeat lag view ""GGADMIN"."GG_LAG"" dropped.
2020-07-13 00:22:25 INFO OGG-14028 Heartbeat lag history view ""GGADMIN"."GG_LAG_HISTORY"" dropped.
2020-07-13 00:22:25 INFO OGG-14013 Procedure ""GGADMIN"."GG_UPDATE_HB_TAB"" dropped.
2020-07-13 00:22:25 INFO OGG-14020 Procedure ""GGADMIN"."GG_PURGE_HB_TAB"" dropped.
2020-07-13 00:22:25 INFO OGG-14015 Scheduler job ""GGADMIN"."GG_UPDATE_HEARTBEATS"" dropped.
2020-07-13 00:22:25 INFO OGG-14022 Scheduler job ""GGADMIN"."GG_PURGE_HEARTBEATS"" dropped.
GGSCI (rhel7.example.com as ggadmin@euro) 3> add heartbeattable
2020-07-13 00:22:30 INFO OGG-14001 Successfully created heartbeat seed table ""GGADMIN"."GG_HEARTBEAT_SEED"".
2020-07-13 00:22:30 INFO OGG-14089 Successfully tracking extract restart position with heartbeat table ""GGADMIN"."GG_HEARTBEAT_SEED"".
2020-07-13 00:22:30 INFO OGG-14032 Successfully added supplemental logging for heartbeat seed table ""GGADMIN"."GG_HEARTBEAT_SEED"".
2020-07-13 00:22:30 INFO OGG-14000 Successfully created heartbeat table ""GGADMIN"."GG_HEARTBEAT"".
2020-07-13 00:22:30 INFO OGG-14089 Successfully tracking extract restart position with heartbeat table ""GGADMIN"."GG_HEARTBEAT"".
2020-07-13 00:22:30 INFO OGG-14033 Successfully added supplemental logging for heartbeat table ""GGADMIN"."GG_HEARTBEAT"".
2020-07-13 00:22:30 INFO OGG-14016 Successfully created heartbeat history table ""GGADMIN"."GG_HEARTBEAT_HISTORY"".
2020-07-13 00:22:30 INFO OGG-14089 Successfully tracking extract restart position with heartbeat table ""GGADMIN"."GG_HEARTBEAT_HISTORY"".
2020-07-13 00:22:30 INFO OGG-14086 Successfully disabled partitioning for heartbeat history table ""GGADMIN"."GG_HEARTBEAT_HISTORY"".
2020-07-13 00:22:30 INFO OGG-14023 Successfully created heartbeat lag view ""GGADMIN"."GG_LAG"".
2020-07-13 00:22:30 INFO OGG-14024 Successfully created heartbeat lag history view ""GGADMIN"."GG_LAG_HISTORY"".
2020-07-13 00:22:30 INFO OGG-14003 Successfully populated heartbeat seed table with "EURO".
2020-07-13 00:22:31 INFO OGG-14004 Successfully created procedure ""GGADMIN"."GG_UPDATE_HB_TAB"" to update the heartbeat tables.
2020-07-13 00:22:31 INFO OGG-14017 Successfully created procedure ""GGADMIN"."GG_PURGE_HB_TAB"" to purge the heartbeat history table.
2020-07-13 00:22:31 INFO OGG-14005 Successfully created scheduler job ""GGADMIN"."GG_UPDATE_HEARTBEATS"" to update the heartbeat tables.
2020-07-13 00:22:31 INFO OGG-14018 Successfully created scheduler job ""GGADMIN"."GG_PURGE_HEARTBEATS"" to purge the heartbeat history table.
GGSCI (rhel7.example.com as ggadmin@euro) 2> delete heartbeattable
2020-07-13 00:22:25 INFO OGG-14007 Heartbeat seed table ""GGADMIN"."GG_HEARTBEAT_SEED"" dropped.
2020-07-13 00:22:25 INFO OGG-14009 Heartbeat table ""GGADMIN"."GG_HEARTBEAT"" dropped.
2020-07-13 00:22:25 INFO OGG-14011 Heartbeat history table ""GGADMIN"."GG_HEARTBEAT_HISTORY"" dropped.
2020-07-13 00:22:25 INFO OGG-14026 Heartbeat lag view ""GGADMIN"."GG_LAG"" dropped.
2020-07-13 00:22:25 INFO OGG-14028 Heartbeat lag history view ""GGADMIN"."GG_LAG_HISTORY"" dropped.
2020-07-13 00:22:25 INFO OGG-14013 Procedure ""GGADMIN"."GG_UPDATE_HB_TAB"" dropped.
2020-07-13 00:22:25 INFO OGG-14020 Procedure ""GGADMIN"."GG_PURGE_HB_TAB"" dropped.
2020-07-13 00:22:25 INFO OGG-14015 Scheduler job ""GGADMIN"."GG_UPDATE_HEARTBEATS"" dropped.
2020-07-13 00:22:25 INFO OGG-14022 Scheduler job ""GGADMIN"."GG_PURGE_HEARTBEATS"" dropped.
GGSCI (rhel7.example.com as ggadmin@euro) 3> add heartbeattable
2020-07-13 00:22:30 INFO OGG-14001 Successfully created heartbeat seed table ""GGADMIN"."GG_HEARTBEAT_SEED"".
2020-07-13 00:22:30 INFO OGG-14089 Successfully tracking extract restart position with heartbeat table ""GGADMIN"."GG_HEARTBEAT_SEED"".
2020-07-13 00:22:30 INFO OGG-14032 Successfully added supplemental logging for heartbeat seed table ""GGADMIN"."GG_HEARTBEAT_SEED"".
2020-07-13 00:22:30 INFO OGG-14000 Successfully created heartbeat table ""GGADMIN"."GG_HEARTBEAT"".
2020-07-13 00:22:30 INFO OGG-14089 Successfully tracking extract restart position with heartbeat table ""GGADMIN"."GG_HEARTBEAT"".
2020-07-13 00:22:30 INFO OGG-14033 Successfully added supplemental logging for heartbeat table ""GGADMIN"."GG_HEARTBEAT"".
2020-07-13 00:22:30 INFO OGG-14016 Successfully created heartbeat history table ""GGADMIN"."GG_HEARTBEAT_HISTORY"".
2020-07-13 00:22:30 INFO OGG-14089 Successfully tracking extract restart position with heartbeat table ""GGADMIN"."GG_HEARTBEAT_HISTORY"".
2020-07-13 00:22:30 INFO OGG-14086 Successfully disabled partitioning for heartbeat history table ""GGADMIN"."GG_HEARTBEAT_HISTORY"".
2020-07-13 00:22:30 INFO OGG-14023 Successfully created heartbeat lag view ""GGADMIN"."GG_LAG"".
2020-07-13 00:22:30 INFO OGG-14024 Successfully created heartbeat lag history view ""GGADMIN"."GG_LAG_HISTORY"".
2020-07-13 00:22:30 INFO OGG-14003 Successfully populated heartbeat seed table with "EURO".
2020-07-13 00:22:31 INFO OGG-14004 Successfully created procedure ""GGADMIN"."GG_UPDATE_HB_TAB"" to update the heartbeat tables.
2020-07-13 00:22:31 INFO OGG-14017 Successfully created procedure ""GGADMIN"."GG_PURGE_HB_TAB"" to purge the heartbeat history table.
2020-07-13 00:22:31 INFO OGG-14005 Successfully created scheduler job ""GGADMIN"."GG_UPDATE_HEARTBEATS"" to update the heartbeat tables.
2020-07-13 00:22:31 INFO OGG-14018 Successfully created scheduler job ""GGADMIN"."GG_PURGE_HEARTBEATS"" to purge the heartbeat history table.
No comments:
Post a Comment