Topics:
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).
These sections describe considerations for a data-distribution configuration.
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.
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.
The data distribution configuration supports read-only targets. See Configuring Oracle GoldenGate for Active-Active High Availability if any target in this configuration will also be used for transactional activity in support of high availability.
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.
Refer to Figure 6-1 for a visual representation of the objects you will be creating.
Figure 6-1 Oracle GoldenGate Configuration Elements for Data Distribution
Configure the Manager process and primary Extract on the source system.
To Configure the Manager Process
On the source, configure the Manager process. See Configuring Manager and Network Communications for instructions.
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}, BEGIN time [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, EXTRACT ext
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][, USERIDALIAS alias] -- Log all scheduling columns if using integrated Replicat LOGALLSUPCOLS -- Specify the local trail that this Extract writes to -- and encryption algorithm: ENCRYPTTRAIL algorithm EXTTRAIL local_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
Configure the Manager process and Replicat groups on the target systems.
To Configure the Manager Process
On each target, configure the Manager process. See Configuring Manager and Network Communications for instructions.
In each Manager parameter file, use the PURGEOLDEXTRACTS
parameter to control the purging of files from the trail.
To Configure the Replicat Groups