Intermediary System

Configure the Manager process and data pump on the intermediary system.

To Configure the Manager Process on the Intermediary System

On the intermediary system, 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 Data Pump on the Intermediary System

On the intermediary system, use the ADD EXTRACT command to create a data-pump group. For documentation purposes, this group is called pump_2.
```
ADD EXTRACT pump_2, EXTTRAILSOURCE local_trail_1, BEGIN time
```
Use EXTTRAILSOURCE as the data source option, and specify the name of the trail that you created on this system
On the intermediary system, use the ADD RMTTRAIL command to specify a remote trail on the target system.
```
ADD RMTTRAIL remote_trail_2, EXTRACT pump_2
```
Use the EXTRACT argument to link the remote trail to the pump_2 data pump. The linked data pump writes to this trail.

See Reference for Oracle GoldenGate for additional ADD RMTTRAIL options.

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

-- Identify the data pump group:
EXTRACT pump_2
-- Note that no database login parameters are required in this case.
-- Specify the target definitions file if SOURCEDEFS was used:
TARGETDEFS full_pathname
-- Decrypt the data only if the data pump must process it.
-- DECRYPTTRAIL
-- Specify the name or IP address of the target system
-- and optional encryption of data over TCP/IP:
RMTHOSTOPTIONS target_2, MGRPORT port_number, ENCRYPT encryption_options
-- Specify the remote trail and encryption algorithm on the target system:
ENCRYPTTRAIL algorithm
RMTTRAIL remote_trail_2
-- Specify tables and sequences to be captured:
SEQUENCE [container.|catalog.]owner.sequence;
TABLE [container.|catalog.]owner.table;