Oracle GoldenGate sample parameter files

  总结：

一直以来对oracle goldengate 许多参数比较疑惑，正好在MOS 看到这个文章，转载到BLOG ，以备参考

 

Objective: This paper provides sample example of Oracle GoldenGate parameter files that can be used to configure Oracle GoldenGate replication setup inline with recommended best practices. The example is generic and can serve as a starting point for a more customized Oracle GoldenGate implementation

Process name: Manager

Description: Manager is GoldenGate's parent process and is responsible for the management of GoldenGate processes, resources, user interface, and the reporting of thresholds and errors.

Manager parameter file (Sample)

 

-- Manager port number

PORT

 

-- As a Manager parameter, PURGEOLDEXTRACTS allows to manage trail

-- files in a centralized fashion and take into account multiple

-- processes.

PURGEOLDEXTRACTS , USECHECKPOINTS, MINKEEPHOURS <"x" hours> MINKEEPFILES <"y" number of files>

 

-- Start one or more Extract and Replicat processes automatically after -- they fail. AUTORESTART provides fault tolerance when something

-- temporary interferes with a process, such as intermittent network

-- outages or programs that interrupt access to transaction logs.

AUTORESTART EXTRACT *, RETRIES , WAITMINUTES , RESETMINUTES

 

--This is to specify a lag threshold that is considered critical,

--and to force a warning message to the error log. Lagreport parameter

--specifies the interval at which manager checks for extract / replicat --lag.

LAGREPORTMINUTES

LAGCRITICALMINUTES

Process name: Extract

Description: The Extract process captures either full data records or transactional data changes, depending on configuration parameters, and then sends the data to a target system to be applied to target tables or processed further by another process, such as a load utility.

 

Extract parameter file (Sample)

 

-- ###################################################################

-- Runcmd: ADD EXTRACT , TRANLOG, BEGIN NOW

-- Runcmd: ADD EXTTRAIL ,

-- EXTRACT , Megabytes

-- Name of the extract process. Limited to 8 charecters.

EXTRACT

 

-- DB environment settings

SETENV (ORACLE_HOME = "" )

SETENV (ORACLE_SID="")

 

-- OGG database user login

USERID password , encryptkey default

 

-- Local trail info

EXTTRAIL

 

-- Prevent data looping. This is generally used in bi-directional

-- configuration

TRANLOGOPTIONS EXCLUDEUSER

 

-- ASM login info  (Oracle only. If db is using ASM)

TRANLOGOPTIONS ASMUSER sys@, ASMPASSWORD , encryptkey default

 

--DBLOGREADER   enables Extract to use a read buffer size of up to 4 MB --- in size. A larger buffer may improve the performance of Extract when -- redo rate is high.   The db has to be 10.2.0.5 or higher to use

-- this feature. If DBLOGREADER parameter is in place then the above

-- ASMUSER parameter should not be used.

TRANLOGOPTIONS DBLOGREADER, DBLOGREADER BUFSIZE [x], BUFSIZE [y]

 

--DDL replication parameters

DDL INCLUDE ALL, EXCLUDE OBJNAME ".