GoldenGate的一些引數的意義

1. ASSUMETARGETDEFS - You use this target to tell that your source and and target tables are identical.

2. ReportCount Every 30 Minutes, Rate

GoldenGate會統計並報告自啟動以來處理的資料複製的條數

1000 records processed as of 2010-01-28 11:30:40 (rate 154,delta 215)

Since the Extract process started, it has processed 1,000 records as of the time displayed (11:30:40).

You also asked for RATE information to be printed in the report. The rate calculations are as follows:

Rate = # of records processed since startup / total time since startup

Delta = # of records since last report / time since last report

In the example, the processing rate is 154 and the delta is 215. The delta is higher, which indicates

that you’re processing more records in the latest reporting period. You can compare the rate over time to

see if it changes. Changes in rate could be due to more or less processing volume or perhaps

performance issues with your Extract or Replicat or even the database itself.

3. REPORTROLLOVER

迴圈使用report檔案，防止檔案過大影響效能

4. PurgeOldExtracts

清除舊的extract檔案。

例： PurgeOldExtracts dirdat/*, UseCheckpoints, MinKeepDays 2

這個配置會清除目錄dirdat下的extract檔案，USECHECKPOINTS這個選項表示除非extract files已經被處理，否則extract檔案不會被清除

5. ENCRYPTTRAIL

加密extract檔案

6. DECRYPTTRAIL

解密extract檔案

7. Table HR.EMPLOYEES

COLS (employee_Id, first_name, last_name);

這個配置表示對於表HR.EMPLOEES, 只匹配三個包含在COLS選項中的列

8. Table HR.EMPLOYEES

COLSEXCEPT (email);

抽取employees表的所有列，除了email

9. Map HR.EMPLOYEES, Target HR.EMPLOYEES,

WHERE (JOB_ID = "IT_PROG");

只replicateJOB_ID = "IT_PROG"的記錄

10. FILTER (ON DELETE, SALARY / 12 < 1000);

在刪除操作時，只刪除月薪少於1000的員工記錄

相關文章