Backup Oracle GoldenGate Deployments

Author: Bobby Curtis, MBA

Date: January 23, 2025

Updated: October 13, 2023

Organization: RheoData

Table of Contents

INTRODUCTION:

Assumption:

STEP 1: ACCESS THE ORACLE GOLDENGATE SERVER

STEP 2: IDENTIFY THE DEPLOYMENT BASE

STEP 3: BACKUP ALL DEPLOYMENTS

CONCLUSION:

Introduction:

Oracle GoldenGate is a real-time data integration and replication software that enables data movement and synchronization across heterogeneous databases and platforms. This installation documentation provides step-by-step instructions for backing up the deployments.

Assumption:

This guide will only be written around backing up the deployments, to include the ServiceManager and Deployments that are configured.  This will not backup the Oracle GoldenGate binaries.

Note: With this approach, socket files (s) will not be backed up.  The only known socket (s) file will be for the Performance Metric Service.

Step 1: Access the Oracle GoldenGate Server

1.     SSH into the RedHat Instance

$ ssh <user>@<ip_address>

2.     Login as Oracle

$ sudo su – oracle

Step 2: Identify the Deployment Base

1.     Use the process status command to find the deployments.

$ ps -ef | grep -i [servicemanager | deployment_name]

Note: The deployment base for ICON is /gg_data

Step 3: Backup all deployments

1.     Using Zip, backup all the deployments in the deployment base to /tmp

$ zip -r /tmp/ggbackup10132023.zip $DEPLOYMENT_BASE

2.     Check zip file for complete backup using less

$ less /tmp/ggbackup10132023.zip

Note: Output of less command will be the contents of the zip file.

Conclusion:

Congratulations! You have successfully backed up Oracle GoldenGate deployments.