My Oracle Support Banner

GoldenGate Configuration for Stability and Recovery (Doc ID 1451514.1)

Last updated on JANUARY 02, 2024

Applies to:

Middleware > Data Integration > GoldenGate
Information in this document applies to any platform.

Purpose

<p >*Purpose
<span >Enter a clear description of what the document is trying to achieve.

 The purpose of this article is to provide an overview of the Golden gate recovery methods and techniques, and some suggestions for stability configurations.

Scope

 The scope of this document will be limited to Oracle to Oracle golden gate replication, however, some of the methods suggested might be also valid in case of Oracle to None-Oracle replication.

Details

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
Purpose
Scope
Details
 1. Extract process  failures:
 - Source database redo logs are lost or corrupted.
 - The source machine is not available.
 - The OGG objects do not have access privileges to the necessary catalogs, logs, and tables.
  2. Datapump :
 - Network problem.
 -Lost trail files.
 - Target machine is not accessible.
 3. Replicat:
 - Lost trail files (or corrupted).
 - Target database is not available.
 
Positioning processes using GGSCI commands
  Shutting down the system
 Resynchronizing an out-of-sync table
 To resynchronize a table
 Trail recovery mode

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