本文主要是介绍oracle goldengate 参数详解(转MOS:Oracle GoldenGates ample parameter files),希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
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 MINKEEPFILES
-- 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 ". "
DDLOPTIONS ADDTRANDATA
--Discard file location.
DISCARDFILE , APPEND Megabytes
-- Use the DISCARDROLLOVER parameter to set a schedule for aging discard --files.
DISCARDROLLOVER AT on
-- Use the REPORTROLLOVER parameter to force report files to age on a
-- regular schedule, instead of when a process starts
REPORTROLLOVER AT on
-- Use the REPORTCOUNT parameter to report a count of transaction
-- records that Extract or Replicat processed since startup
REPORTCOUNT EVERY HOURS, RATE
-- Use the FETCHOPTIONS parameter to control certain aspects of the way -- that GoldenGate fetches data
FETCHOPTIONS, USESNAPSHOT, NOUSELATESTVERSION, MISSINGROW REPORT
STATOPTIONS REPORTFETCH
-- Warn for long running txns
WARNLONGTRANS H, CHECKINTERVAL m
-- List of tables
Table .
..
Pump (Extract) Parameter file (Sample)
-- Runcmd: ADD EXTRACT , EXTTRAILSOURCE
-- Path/two character trail id>
-- Runcmd: ADD RMTTRAIL ,
-- EXTRACT , Megabytes
-- Name of the Pump process. Limited to 8 charecters.
EXTRACT
-- Oracle environment settings
SETENV (ORACLE_HOME = "" )
SETENV (ORACLE_SID="")
-- In passthru mode GoldenGate pump process cascades captured data from -- source to target without logging in to the source database
Passthru
-- Remote host and remort manager port to write trail
RMTHOST , MGRPORT
-- Remote trail info
RMTTRAIL
--Discard file location.
DISCARDFILE , APPEND Megabytes
-- Use the DISCARDROLLOVER parameter to set a schedule for aging discard --files.
DISCARDROLLOVER AT on
-- Use the REPORTROLLOVER parameter to force report files to age on a
-- Regular schedule, instead of when a process starts
REPORTROLLOVER AT on
-- Use the REPORTCOUNT parameter to report a count of transaction
-- Records that Extract or Replicat processed since startup
REPORTCOUNT EVERY HOURS, RATE
-- List of tables
Table .
Process name: Replicat
Description: The Replicat process reads data extracted by the Extract process and applies it to target tables or prepares it for use by another application, such as a load application.
Replicat parameter file
###################################################################
-- Runcmd: ADD REPLICAT , EXTTRAIL
-- Name of the replicat process. Limited to 8 charecters.
REPLICAT
-- Oracle environment settings
SETENV (ORACLE_HOME = "" )
SETENV (ORACLE_SID= "")
SETENV (NLS_LANG = ="")
-- OGG database user login
USERID password , encryptkey default
--Discard file location.
DISCARDFILE , APPEND Megabytes
--DDL replication parameters
DDL INCLUDE ALL, EXCLUDE OBJNAME "."
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 on
-- Use the REPORTROLLOVER parameter to force report files to age on a
-- regular schedule, instead of when a process starts
REPORTROLLOVER AT on
-- Use the REPORTCOUNT parameter to report a count of transaction
-- records that Extract or Replicat processed since startup
REPORTCOUNT EVERY HOURS, RATE
-- List of tables (MAP statements)
MAP .
..
..
GLOBALS file
The GLOBALS file stores parameters that relate to the GoldenGate instance as a whole, as opposed to runtime parameters for a specific process.
Globals parameter file
-- Specifies the name of the Manager process when it is installed as a Windows service.
MGRSERVNAME
-- Specifies a default checkpoint table
CHECKPOINTTABLE
-- Specifies the name of the schema that contains the database objects that support DDL
-- synchronization for Oracle
GGSCHEMA
-- Specifies a non-default name for the DDL history table that supports DDL
-- synchronization for Oracle.
DDLTABLE
-- Specifies a non-default name for the DDL marker table that supports DDL
-- synchronization for Oracle
MARKERTABLE
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26442936/viewspace-764374/,如需转载,请注明出处,否则将追究法律责任。
<%=items[i].content%>
<%if(items[i].items.items.length) { %><%=items[i].items.items[j].username%> 回复 <%=items[i].items.items[j].tousername%>: <%=items[i].items.items[j].content%>
最新文章
- Oracle 12.2 RAC on Linux Best Practice Documentation
- [转载 mos] Oracle RAC 不同版本不同平台官档收集记录
- Linux下共享VG改变活动状态
- powermt 命令简介(转载)
- Linux/Unix系统中主机HBA无法发现LUN,路径显示错误,LUN相关错误
- gc current request 引起长期锁表的故障
- 如何在RAC环境中配置SNAPSHOT CONTROLFILE?
- AWR不能自动生成快照解决方法?
- expdp sample 应用一例
- mysql主从复制(冷备)
转载于:http://blog.itpub.net/26442936/viewspace-764374/
这篇关于oracle goldengate 参数详解(转MOS:Oracle GoldenGates ample parameter files)的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!