My Oracle Support Banner

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

Last updated on MARCH 12, 2021

Applies to:

Oracle GoldenGate - Version 10.0.0.0 to 11.1.1.0.0 [Release 10.0.0 to 11.1.1]
Information in this document applies to any platform.
***Checked for relevance on 18-Nov-2012***

Goal


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?

Solution

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
Goal
Solution


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