Oracle GoldenGate: Replicat Sample Parameter File

-- ###################################################################
-- Runcmd: ADD REPLICAT [REPLICAT name], EXTTRAIL [trail file path/two -- character trail id]
-- Name of the replicat process. Limited to 8 charecters. 

REPLICAT [Replicat name]

-- Oracle environment settings
SETENV (ORACLE_HOME = "[Oracle home path]" )
SETENV (ORACLE_SID= "[Oracle sid]")
SETENV (NLS_LANG = ="[Target db charecterset]")

-- OGG database user login
USERID [username] password [encrypted password], encryptkey default 

--Discard file location.
DISCARDFILE [diacard file path/[discard file name.dsc], APPEND Megabytes [n]

--DDL replication parameters
DDL INCLUDE ALL, EXCLUDE OBJNAME "[schema name].[object name]"
DDLOPTIONS REPORT

-- The following parameter speeds up replicat processing rate. The
-- parameter alters the replicat oracle session to not wait for commits -- to be persisted to the redo.
SQLEXEC "ALTER SESSION SET COMMIT_WRITE = NOWAIT"

-- Use the BATCHSQL parameter to increase the performance of Replicat. 
-- BATCHSQL causes Replicat to organize similar SQL statements into arrays and apply 
-- them at an accelerated rate.
BATCHSQL

-- Use the DISCARDROLLOVER parameter to set a schedule for aging discard --files.
DISCARDROLLOVER AT [hh:mi] on [day of the week]

-- Use the REPORTROLLOVER parameter to force report files to age on a
-- regular schedule, instead of when a process starts
REPORTROLLOVER AT [hh:mi] on [day of the week]

-- Use the REPORTCOUNT parameter to report a count of transaction
-- records that Extract or Replicat processed since startup
REPORTCOUNT EVERY [n] HOURS, RATE

-- List of tables (MAP statements)
MAP [source schema name].[table name], TARGET [target schema name].[tablename];
...