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
-- 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
--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
-- Runcmd: ADD EXTTRAIL
-- EXTRACT
-- Name of the extract process. Limited to 8 charecters.
EXTRACT
-- DB environment settings
SETENV (ORACLE_HOME = "
SETENV (ORACLE_SID="
-- OGG database user login
USERID
-- 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@
--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
-- Use the DISCARDROLLOVER parameter to set a schedule for aging discard --files.
DISCARDROLLOVER AT
-- Use the REPORTROLLOVER parameter to force report files to age on a
-- regular schedule, instead of when a process starts
REPORTROLLOVER AT
-- Use the REPORTCOUNT parameter to report a count of transaction
-- records that Extract or Replicat processed since startup
REPORTCOUNT EVERY
-- 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
-- List of tables
Table
相關文章
- Oracle GoldenGate常用引數詳解OracleGo
- Oracle Server Parameter FilesOracleServer
- Oracle GoldenGate Best Practice - sample parameter files (文件 ID 1321696.1)OracleGo
- 轉載-詳解功率MOS管引數
- 轉:oracle EXP /IMP引數詳解Oracle
- Oracle UNDO引數詳解Oracle
- oracle goldengate引數學習OracleGo
- 【PARAMETER】Oracle引數:MAX_IDLE_BLOCKER_TIME 解釋OracleBloC
- oracle rac 核心引數詳解Oracle
- oracle RMAN引數配置詳解Oracle
- ORACLE DG之引數詳解Oracle
- ORACLE推導引數Derived Parameter介紹Oracle
- [轉載]ORACLE GOLDENGATE的主要元件詳解OracleGo元件
- Initialization Parameter Files and Server Parameter Files (287)Server
- 【MOS】Parameter FILESIZE - Multiple Export Files (文件 ID 290810.1)Export
- 詳解Oracle建立表的引數Oracle
- 【parameter】oracle的隱含引數的檢視Oracle
- 水煮Oracle——《Oracle pfile/spfile引數檔案詳解Oracle
- Oracle utl_file_dir引數詳解Oracle
- Oracle CLUSTER_INTERCONNECTS引數詳解Oracle
- oracle parallel並行_引數parameter_parallel_max_serverOracleParallel並行Server
- 獲取_字首的oracle hidden parameter隱含引數Oracle
- ORACLE中Cursor_sharing引數詳解Oracle
- oracle中的processes,session,transaction引數詳解OracleSession
- Oracle goldengate 初始化資料的方法(轉MOS:ID 1276058.1)OracleGo
- Oracle修改初始化引數(initialization parameter)scope的選項Oracle
- oracle 11g show parameter顯示隱含引數hidden parameter_x$ksppiOracle
- 【轉】Cmd引數詳解
- GCC引數詳解(轉)GC
- fstab引數詳解(轉)
- Oracle 引數檔案(轉)Oracle
- Oracle ParameterOracle
- 關於Oracle GoldenGate 引數TRANLOGOPTIONS altarchivelogdestOracleGoHive
- oracle goldengate 複製端延時應用引數OracleGo
- Oracle GoldenGate系統之----相關引數說明OracleGo
- Oracle引數檔案 各引數解釋Oracle
- Oracle FilesOracle
- Oracle記憶體引數調優技術詳解Oracle記憶體