My Oracle Support Banner

GoldenGate Recovery When Target Database Is Recovered From Backup (Doc ID 2521049.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle GoldenGate - Version 12.3.0.1.3 and later
Information in this document applies to any platform.

Goal

Is it possible to recover a target database from an RMAN back of target database and resync replication?

Scenario:

Oracle to Oracle replication.
Target database takes nightly RMAN backups.
GoldenGate trail files are stored in target for one week.
Target database gets corrupted.

Is it possible to restore the target DB to last night's RMAN backup, and then resync with the source DB? Or is the only option to instantiate from the source?
 

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.