Configuration from Active Source to Standby

These steps configure Oracle GoldenGate to capture data from the primary database and replicate it to the standby database.

To Configure the Primary Extract Group

Perform these steps on the active 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 Reference for Oracle GoldenGate for detailed information about these and other ADD EXTRACT options that may be required for your installation.
Use the ADD EXTTRAIL command to add a local trail. For documentation purposes, this trail is called local_trail_1.
```
ADD EXTTRAIL local_trail_1, EXTRACT ext_1
```
For EXTRACT, specify the ext_1 group to write to this trail.

Use the EDIT PARAMS command to create a parameter file for the ext_1 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 the encryption algorithm:
ENCRYPTTRAIL algorithm
EXTTRAIL local_trail_1
-- Specify sequences to be captured:
SEQUENCE [container.]owner.sequence;
-- Specify tables to be captured:
TABLE [container.]owner.*;

To Configure the Data Pump

Perform these steps on the active 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
```
For EXTTRAILSOURCE, specify local_trail_1 as the data source.
Use the ADD RMTTRAIL command to specify a remote trail that will be created on the standby system.
```
ADD RMTTRAIL remote_trail_1, EXTRACT pump_1
```
For EXTRACT, specify the pump_1 data pump to write to this trail.

See Reference for Oracle GoldenGate for additional ADD RMTTRAIL options.

Use the EDIT PARAMS command to create a parameter file for the pump_1 group. 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 as needed for the database:
[SOURCEDB dsn_1][, USERIDALIAS alias]
-- Decrypt the data only if the data pump must process it.
-- DECRYPTTRAIL
-- Specify the name or IP address of the standby system
-- and optional encryption of data over TCP/IP:
RMTHOSTOPTIONS system_2, MGRPORT port_number, ENCRYPT encryption_options
-- Specify the remote trail and encryption algorithm on the standby system:
ENCRYPTTRAIL algorithm
RMTTRAIL remote_trail_1
-- Specify sequences to be captured:
SEQUENCE [container.]owner.sequence;
-- Specify tables to be captured:
TABLE [container.]owner.*;

To Configure the Replicat Group

Perform these steps on the live standby system.

Create a Replicat checkpoint table (unless using Oracle integrated Replicat). See Creating a Checkpoint Table for instructions.
Use the ADD REPLICAT command to create a Replicat group. For documentation purposes, this group is called rep_1.
```
ADD REPLICAT rep_1
[, INTEGRATED | COORDINATED [MAXTHREADS number]]
, EXTTRAIL remote_trail_1, BEGIN time
```
For EXTTRAIL, specify remote_trail_1 as the trail that this Replicat reads.

See Reference for Oracle GoldenGate for detailed information about these and other options that may be required for your installation.

Use the EDIT PARAMS command to create a parameter file for the rep_1 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 Replicat group:
REPLICAT rep_1
-- State that source and target definitions are identical:
ASSUMETARGETDEFS
-- Specify database login information as needed for the database:
[TARGETDB dsn_2][, USERIDALIAS alias]
-- Specify error handling rules:
REPERROR (error, response)
-- Specify tables for delivery and threads if using coordinated Replicat:
MAP [container.|catalog.]owner.table, TARGET owner.table[, DEF template]
[, THREAD (thread_ID)][, THREADRANGE (thread_range[, column_list])]
;