My Oracle Support Banner

Best Practices for failover during server failures (Doc ID 1323472.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle GoldenGate - Version to [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:

Simplified scenario:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.