Monitoring GoldenGate is one of the most commonly overlooked components of real-time data integration. Running GoldenGate is frequently critical to an entities business operations. Identifying and responding to performance issues and outages can impact the bottom line of any organizations operations.
How you handle errors will depend on what you are using GoldenGate for and how you are monitoring GoldenGate. For example, if you are using GoldenGate for a data migration or upgrade it might be okay if a process goes down for a minute, and hour or even a day. You usually have plenty of time to catch up. However, if you are using GoldenGate as a real-time feed for a data warehouse, a reporting server or another critical service, a single minute of downtime could me lots of missed transactions and cause severe damage due to the delays.
Therefore, it is critical to ensure that GoldenGate monitoring is continuous and that the correct person be alerted if there is an issue that needs immediate attention. Any unplanned downtime can be costly. Thus, GoldenGate monitoring is important. Make sure that your system is protected by implementing GoldenGate monitoring tools that provide relevant information on a regular basis and can provide alerts if there is a critical issue needing attention.
An outage of minutes could potential cause many transactions to back up, thus causing delays in catching up. This will in turn cause the potential of more collisions and problems with out of sync data. It is crucial to address failures as soon as possible.
GoldenGate monitoring should be complete and in addition to alerting be able to help you begin the debug process and where possible provide enough information to help restart processes as soon as possible.