Extract and Replicat processes take care the data from the point of setup of the processes. To setup a replication using Goldengate, We need to make sure that existing data are properly copied from Source to Target and this is called Initial Load.
Category: GoldenGate
GoldenGate Error and Solution
ERROR OGG-25127 Received an error reply requesting a graceful shutdown:
Enable DDL Replication in GoldenGate
In this article, I will show how to enable DDL replication for a table or schema which is the part of goldengate replication.
Create a User ALIAS for GoldenGate Credential using CREDENTIALSTORE
CREDENTIALSTORE: Creates a credentials store (wallet) that stores encrypted database user credentials. The CREDENTIALSTORE is a new feature in Oracle GoldenGate 12c and the default location of the credential store is “$GG_HOME/dircrd”.
Configure GolgeGate Replication with19c
To configure Oracle GoldenGate replication, we need to create below processes. In this article, I will use Oracle Database as source and target.
Install Oracle GoldenGate 19c on Linux
In this article, I will demonstrate how to install Oracle GoldenGate 19c on Linux Server. We will follow these Steps:
GoldenGate Commands
Mostly, DBA configures and manages GoldenGate components by using GGSCI command-line Interface. GGSCI stands for GoldenGate Software Command Interface. It allows you to perform various tasks related to the administration and monitoring of Oracle GoldenGate components. Help command use to get all available commands with details. Manager Commands:
Oracle GolgeGate
Oracle GoldenGate is a comprehensive software solution provided by Oracle for real-time data integration and replication in heterogeneous IT environments. It enables the exchange and manipulation of data at the transaction level among multiple, diverse platforms across the enterprise