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的员工记录

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8520577/viewspace-765973/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8520577/viewspace-765973/