Oracle GoldenGate supports two architectures, the Classic Architecture and the Microservices Architecture (MA).
A static extraction of data records from one database and the loading of those records to another database.
Continuous extraction and replication of transactional Data Manipulation Language (DML) operations and data definition language (DDL) changes (for supported databases) to keep source and target data consistent.
Extraction from a database and replication to a file outside the database.
Oracle GoldenGate Architectures Overview
The following table describes the two Oracle GoldenGate architectures and when you should use each of the architectures.
|X||Classic Architecture||Microservices Architecture|
What is it?
Oracle GoldenGate classic architecture provides the processes and files required to effectively move data across a variety of topologies. These processes and files form the main components of the classic architecture and was the product design until this release.
Oracle GoldenGate Microservices Architecture is a new microservices architecture that provides REST-enabled services as part of the Oracle GoldenGate environment. The REST-enabled services provide remote configuration, administration, and monitoring through HTML5 web pages, command line, and APIs.
When should I use it?
Oracle GoldenGate can be installed and configured to use the Oracle GoldenGate classic architecture for the following purposes:
Oracle GoldenGate can be installed and configured to use the Oracle GoldenGate Microservices Architecture for the following purposes:
Which databases are supported?
Classic Architecture supports all supported databases as per the certification matrix.
MA only supports the Oracle database.
Preparing the Database
Configure the Oracle Database for Oracle GoldenGatereplication.
- On the Linux platform, enter:
sqlplus / as sysdba SQL*Plus: Release 18.104.22.168.0 Production on Thu Jan 5 16:38:53 2018 Copyright (c) 1982, 2018, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 1560281088 bytes Fixed Size 2924784 bytes Variable Size 503320336 bytes Database Buffers 1040187392 bytes Redo Buffers 13848576 bytes Database mounted. Database opened. SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA; Database altered. SQL> ALTER DATABASE FORCE LOGGING; Database altered. SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount ORACLE instance started. Total System Global Area 1560281088 bytes Fixed Size 2924784 bytes Variable Size 503320336 bytes Database Buffers 1040187392 bytes Redo Buffers 13848576 bytes Database mounted. SQL> alter database archivelog; Database altered. SQL> alter database open; Database altered. SQL> alter system set enable_goldengate_replication=true; System altered.
Note:If you use the Integrated Extract and/or Integrated Replicat features, it is advised to set the
- Exit the SQL prompt once you create the users.
Prerequisites for Database Sharding
STREAMS_POOL_SIZEto at least 1200 MB.
Load Oracle GoldenGate sharding PL/SQL packages prior to deploying, which in turn adds the
Install a client wallet for database to communicate through the PL/SQL
utl_httproutines with Oracle GoldenGate service endponits.
Setting Environment Variables
You can set the MA-specific environment variables while performing the deployment tasks:
Oracle GoldenGate Configuration Assistant (OGGCA)
SSL/TLS Security (Optional)
The following environment variables are set for the Oracle GoldenGate Configuration Assistant,
- Oracle Database SID
An additional environment variable is required to set up a secure deployment:
Note:For using any command line utility, you must set up the
OGG_ETC_HOMEvariables correctly in the environment.
Data Replication Task Roadmap
There are a number of tasks you must perform to set up data replication.
|Run the Oracle GoldenGate Configuration Assistant (oggca) to create and configure secure and non-secure deployments||See Setting Up Secure and Non-Secure Deployment|
|Login to Service Manager||When you log in to Service Manager, you can see the status of other servers (Administration Server, Distribution Server, Performance Metrics Server, and Receiver Server). See How to Connect to Service Manager|
|Add Credential Store||Set up the user id and password to connect to the database before you create an Extract. See How to Add Database Credentials. You can also set up your domain alias while setting up the Credentials configuration.|
|Add Extracts||How to Add Extracts|
|Register the Extract||You need to register an Extract when creating an Integrated Extract. See How to Add Extracts.|
|Add Distribution Path||See How to Add a Distribution Path|
|Add Replicats||See How to Add Replicats|
|Register the Replicat||See How to Add Replicats|
|Start the Extract||See How to Add an Extract|
|Start the Distribution Path||See How to Add a Distribution Path|
|Start the Replicat||See How to Add a Replicat|
|Check the Receiver Server for path details||See Monitoring Paths|
|Monitor Extracts and Replicats||See Monitoring Paths and Tuning Network Parameters and Monitoring Server Performance|
|Monitor the Performance Metrics||See Monitoring Performance|