Source System

Refer to **INTERNAL XREF ERROR** for a visual representation of the objects you will be creating.

To Configure the Manager Process on the Source

On the source, configure the Manager process.
In the Manager parameter file, use the PURGEOLDEXTRACTS parameter to control the purging of files from the trail.

To Configure the Primary Extract Group on the Source

On the source, use the ADD EXTRACT command to create an Extract group. For documentation purposes, this group is called ext_1.
```
ADD EXTRACT ext_1, {TRANLOG | INTEGRATED TRANLOG}, BEGIN time [option[, ...]]
```
See Parameters and Functions 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_1, EXTRACT ext_1
```
Use the EXTRACT argument to link this trail to the ext_1 Extract group.

On the source, use the EDIT PARAMS command to create a parameter file for the ext_1 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_1
-- 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;

To Configure the Data Pump on the Source

On the source, use the ADD EXTRACT command to create a data pump group. For documentation purposes, this group is called pump_1.
```
ADD EXTRACT pump_1, EXTTRAILSOURCE local_trail_1, BEGIN time
```
Use EXTTRAILSOURCE as the data source option, and specify the name of the local trail.
On the source, use the ADD RMTTRAIL command to specify a remote trail that will be created on the second system in the cascade.
```
ADD RMTTRAIL remote_trail_1, EXTRACT pump_1
```
Use the EXTRACT argument to link the remote trail to the pump_1 data pump group. The linked data pump writes to this trail.

See Parameters and Functions Reference for Oracle GoldenGate for additional ADD RMTTRAIL options.

On the source, use the EDIT PARAMS command to create a parameter file for the pump_1 data pump. Include the following parameters plus any others that apply to your database environment.

-- Identify the data pump group:
EXTRACT pump_1
-- Specify database login information if using NOPASSTHROUGH:
[SOURCEDB dsn_1][, USERIDALIAS alias]
-- Decrypt the data only if the data pump must process it.
-- DECRYPTTRAIL
-- Specify the name or IP address of second system in cascade
-- and optional encryption of data over TCP/IP:
RMTHOSTOPTIONS target_1, MGRPORT port_number, ENCRYPT encryption_options
-- Specify the remote trail and encryption algorithm on the second system:
ENCRYPTTRAIL algorithm
RMTTRAIL remote_trail_1
-- Specify tables and sequences to be captured:
SEQUENCE [container.|catalog.]owner.sequence;
TABLE [container.|catalog.]owner.table;