Chapter 10. Troubleshooting GoldenGate
Troubleshooting is quite often the final chapter in most technical books, and for good reason, we need to understand how a product works before we can fix it. Having said that, readers with a sound knowledge of GoldenGate can dive straight in to find the key point or action that they seek.
In this chapter, we will discuss the following topics in detail:
Investigating Oracle errors
Investigating and resolving network issues
Handling exceptions to avoid a process failure
Recovering from a process failure
Conflict detection and resolution
Analyzing the GoldenGate health check report
Handling Oracle sequences
Using the
LOGDUMPutility to diagnose data-related issuesUpgrading Oracle GoldenGate
Performing Dynamic Rollback
Starting with Troubleshooting tips, you will learn how to investigate and resolve some of the common issues faced by the GoldenGate administrator.