Configuration from Standby to Active Source

These steps configure Oracle GoldenGate in passive mode. In this mode, the Oracle GoldenGate processes are ready, but not started, to capture data from the secondary database and replicate it to the primary database after a switchover of transaction activity to the secondary system.

Note:

This is a reverse image of the configuration that you just created.

To Configure the Primary Extract Group

Perform these steps on the live standby system.

On the source, use the ADD EXTRACT command to create an Extract group. For documentation purposes, this group is called ext_2.
```
ADD EXTRACT ext_2, {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.
Start the TRANLOG Extract ext_2. Also see Preventing Data Looping.
Use the ADD EXTTRAIL command to add a local trail. For documentation purposes, this trail is called local_trail_2.
```
ADD EXTTRAIL local_trail_2, EXTRACT ext_2
```
For EXTRACT, specify the ext_2 group to write to this trail.

Use the EDIT PARAMS command to create a parameter file for the ext_2 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_2
-- Specify database login information as needed for the database:
[SOURCEDB dsn_2][, USERIDALIAS alias]
-- Log all scheduling columns if using integrated Replicat
LOGALLSUPCOLS
-- Specify the local trail this Extract writes to and the encryption algorithm:
ENCRYPTTRAIL algorithm
EXTTRAIL local_trail_2
-- 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 live standby 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_2, BEGIN time
```
For EXTTRAILSOURCE, specify local_trail_2 as the data source.
Use the ADD RMTTRAIL command to add a remote trail remote_trail_2 that will be created on the active source system.
```
ADD RMTTRAIL remote_trail_2, EXTRACT pump_2
```
For EXTRACT, specify the pump_2 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_2 group. Include the following parameters plus any others that apply to your database environment.

-- Identify the data pump group:
EXTRACT pump_2
-- Specify database login information as needed for the database:
[SOURCEDB dsn_2][, USERIDALIAS alias]
-- Decrypt the data only if the data pump must process it.
-- DECRYPTTRAIL
-- Specify the name or IP address of the active source system
-- and optional encryption of data over TCP/IP:
RMTHOSTOPTIONS system_1, MGRPORT port_number, ENCRYPT encryption_options
-- Specify remote trail and encryption algorithm on active source system:
ENCRYPTTRAIL algorithm
RMTTRAIL remote_trail_2
-- 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 active source.

Use the ADD REPLICAT command to create a Replicat group. For documentation purposes, this group is called rep_2.
```
ADD REPLICAT rep_2
[, INTEGRATED | COORDINATED [MAXTHREADS number]]
, EXTTRAIL remote_trail_1, BEGIN time
```
For EXTTRAIL, specify remote_trail_2 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_2 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_2
-- State that source and target definitions are identical:
ASSUMETARGETDEFS
-- Specify database login information as needed for the database:
[TARGETDB dsn_1][, USERIDALIAS alias]
-- Handle collisions between failback data copy and replication:
HANDLECOLLISIONS
-- 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])]
;