GoldenGate學習筆記(11)_常用引數

常用的引數

1 SOURCE 端

 

2 Pump 端(data pump)

 

2.1 PASSTHRU

Use the PASSTHRU and NOPASSTHRU parameters to control whether a data-pump Extract processes tables in pass-through mode or normal mode. In pass-through mode, the Extract process does not look up table definitions, either from the database or from a data definitions file. Normally, the Extract process logs into the database to retrieve data definitions and, if the target is NonStop, reads a data-definitions file. The definitions are used to perform. mapping and conversion functions. (指定是否進行資料轉換)

 

3 TARGET端

 

3.1 CHECKSEQUENCEVALUE

Use the CHECKSEQUENCEVALUE and NOCHECKSEQUENCEVALUE parameters to control whether or not Replicat verifies that a target sequence value is higher than the one on the source. If the target value is either too low or too high, Replicat brings the source and target values back into an appropriate state of disparity. (確保SEQUENCE值大於Source端)

 

3.2 ASSUMETARGETDEFS

Use the ASSUMETARGETDEFS parameter when the source and target tables specified with a

MAP statement have identical column structure, such as when synchronizing a hot site. It directs GoldenGate not to look up source structures from a source-definitions file. For structures to be identical, they must contain identical column names (including case, if applicable) and data types, and they must appear in the same order in each table. If source and target tables do not have the same structure, use the SOURCEDEFS parameter instead of ASSUMETARGETDEFS.(指定源端與目標端的表結構一致)

 

 

通用引數

REPORTROLLOVER  

Use the REPORTROLLOVER parameter to force report files to age on a regular schedule, instead of when a process starts. For long or continuous runs, setting an aging schedule controls the size of the active report file and provides a more predictable set of archives that can be included in your archiving routine.(按計劃生成報告檔案)