3 Using Oracle GoldenGate for Real-time Data Distribution
Topics:
3.1 Overview of the Data-distribution Configuration
A data distribution configuration is a one-to-many configuration. Oracle GoldenGate supports synchronization of a source database to any number of target systems. Oracle GoldenGate supports like-to-like or heterogeneous transfer of data, with capabilities for filtering and conversion on any system in the configuration (support varies by database platform).
Parent topic: Using Oracle GoldenGate for Real-time Data Distribution
3.2 Considerations for a Data-distribution Configuration
These sections describe considerations for a data-distribution configuration.
Parent topic: Using Oracle GoldenGate for Real-time Data Distribution
3.2.1 Fault Tolerance
For a data distribution configuration, the use of data pumps on the source system ensures that if network connectivity to any of the targets fails, the captured data still can be sent to the other targets. Use a primary Extract group and one data-pump Extract group for each target.
Parent topic: Considerations for a Data-distribution Configuration
3.2.2 Filtering and Conversion
You can use any process to perform filtering and conversion. However, using the data pumps to perform filtering operations removes that processing overhead from the primary Extract group, and it reduces the amount of data that is sent across the network. See Mapping and Manipulating Data for filtering and conversion options.
Parent topic: Considerations for a Data-distribution Configuration
3.2.3 Read-only vs. High Availability
The data distribution configuration supports read-only targets. See Configuring Oracle GoldenGate for Active-Active Configuration if any target in this configuration will also be used for transactional activity in support of high availability.
Parent topic: Considerations for a Data-distribution Configuration
3.2.4 Additional Information
The following documentation provides additional information of relevance to configuring Oracle GoldenGate.
-
For additional system requirements, process configuration, and database setup requirements, see the Oracle GoldenGate installation and configuration document for your database type. These guides are listed in the Preface of this book.
-
For detailed instructions on configuring Oracle GoldenGate change capture and delivery groups, see Configuring Online Change Synchronization.
-
For additional tuning options for Oracle GoldenGate, see Tuning the Performance of Oracle GoldenGate.
-
For complete syntax and descriptions of the Oracle GoldenGate commands and parameters, see Reference for Oracle GoldenGate for Windows and UNIX.
Parent topic: Considerations for a Data-distribution Configuration
3.3 Creating a Data Distribution Configuration
Refer to Figure 3-1 for a visual representation of the objects you will be creating.
Figure 3-1 Oracle GoldenGate Configuration Elements for Data Distribution
![Description of Figure 3-1 follows Description of Figure 3-1 follows](img/data_pump_multi.jpg)
Description of "Figure 3-1 Oracle GoldenGate Configuration Elements for Data Distribution"
3.3.1 Source System
Configure the Manager process and primary Extract on the source system.
To Configure the Manager Process
-
On the source, configure the Manager process.
-
In the Manager parameter file, use the
PURGEOLDEXTRACTS
parameter to control the purging of files from the local trail.
To Configure the Primary Extract
-
On the source, use the
ADD EXTRACT
command to create an Extract group. For documentation purposes, this group is called ext.ADD EXTRACT
ext
, {TRANLOG | INTEGRATED TRANLOG}, BEGINtime
[option
[, ...]]See Reference for Oracle GoldenGate for detailed information about these and other
ADD EXTRACT
options that may be required for your installation. -
On the source, use the
ADD EXTTRAIL
command to create a local trail.ADD EXTTRAIL
local_trail
, EXTRACText
Use the
EXTRACT
argument to link this trail to the primary Extract group. The primary Extract group writes to this trail, and the data pump groups read it -
On the source, use the
EDIT PARAMS
command to create a parameter file for the primary Extract group. Include the following parameters plus any others that apply to your database environment. For possible additional required parameters, see the Oracle GoldenGate installation and setup guide for your database.-- Identify the Extract group: EXTRACT
ext
-- Specify database login information as needed for the database: [SOURCEDB dsn_1][, USERIDALIASalias
] -- Log all scheduling columns if using integrated Replicat LOGALLSUPCOLS -- Specify the local trail that this Extract writes to -- and encryption algorithm: ENCRYPTTRAILalgorithm
EXTTRAILlocal_trail
-- Specify tables and sequences to be captured: SEQUENCE [container
.|catalog
.]owner
.sequence; TABLE [container
.|catalog
.]owner
.table
;
Use EXTTRAIL
to specify the local trail.
To Configure the Data Pump Extract Groups
Parent topic: Creating a Data Distribution Configuration
3.3.2 Target Systems
Configure the Manager process and Replicat groups on the target systems.
To Configure the Manager Process
-
On each target, configure the Manager process.
-
In each Manager parameter file, use the
PURGEOLDEXTRACTS
parameter to control the purging of files from the trail.
To Configure the Replicat Groups
Parent topic: Creating a Data Distribution Configuration