Best Practices for failover during server failures
(Doc ID 1323472.1)
Last updated on JANUARY 30, 2022
Applies to:Oracle GoldenGate - Version 10.0.0.0 to 188.8.131.52.0 [Release 10.0.0 to 11.1.1]
Information in this document applies to any platform.
This document attempts to explain the following high availability scenario and provides best practice suggestions:
Machine A is primary, B is standby and C is replicated via GoldenGate to A.
-Extract process run on C
-Datapump process run on C
-Replicat process run on A
The datapump process on C always has a trail file on A.
Therefor, when a fail-over from A to B happens, the trail file that C uses is no longer there, hence the Datapump hangs.
Even if Golden Gate is restarted on B, the original trail from A is not there anymore.
How to address this situation?
Can we simply recopy the trail file from A to B and then start GoldenGate?
What if the machine is no longer accessible? A anymore so the trail file is lost?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document