风哥教程

培训 . 交流 . 分享
Make progress together!

oracle goldengate复制端延时应用参数DEFERAPPLYINTERVAL

[复制链接]
内容发布:paulyi| 发布时间:2014-2-26 20:24:52
oracle goldengate 复制端延时应用参数DEFERAPPLYINTERVAL

DEFERAPPLYINTERVAL

Valid for Replicat
Use the DEFERAPPLYINTERVAL parameter to set an amount of time that Replicat waits before
applying captured transactions to the target database. To determine when to apply the
transaction, Replicat adds the delay value to the commit timestamp of the source
transaction, as recorded in the local GMT time of the source system.
You can use DEFERAPPLYINTERVAL for such purposes as to prevent the propagation of
erroneous changes made to the source data, to control data arrival across different time
zones, and to allow time for other planned events to occur before the data is applied to the
target. Note that by using DEFERAPPLYINTERVAL, you are purposely building latency into the
target data, and it should be used with caution if the target applications are time-sensitive.

To find out if Replicat is deferring operations, use the SEND REPLICAT command with the
STATUS option and look for a status of Waiting on deferred apply.

NOTE If the TCPSOURCETIMER parameter is in use, it is possible that the timestamps of the
source and target transactions could vary by a few seconds, causing Replicat to
hold its transaction (and hence row locks) open for a few seconds. This small
variance should not have a noticeable affect on performance


Default 0 (no delay)
Syntax DEFERAPPLYINTERVAL <n><unit>


Argument Description
<n> A numeric value for the amount of time to delay. The minimum delay
time is the value that is set for the EOFDELAY parameter. The maximum
delay time is seven days.
<unit> The unit of time for the delay. Can be:
S | SEC | SECS | SECOND | SECONDS | MIN | MINS | MINUTE | MINUTES | HOUR | HOURS |
DAY | DAYS


Example This example directs Replicat to wait ten hours before posting its transactions.
DEFERAPPLYINTERVAL 10
If a transaction completes at 08:00:00 source GMT time, and the delay time is 10 hours, the
transaction will be applied to the target at 18:00:00 target GMT time the same day.


用以下命令查看是否应用延时

send REPLICAT RFPFP011 status
如果出现Waiting on deferred apply (2011-11-22 09:09:56) 则启用了DEFERAPPLYINTERVAL参数








上一篇:oracle goldengate ddl 操作导致复制进程abended处理案例
下一篇:Oracle Goldengate列转换样例
回复

使用道具 举报

1框架
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

热门文章教程

  • 风哥Oracle数据库巡检工具V1.0(附2.6网页
  • Oracle 12cR2 九大新功能全面曝光_详解云数
  • 实战PHP与MySQL权威指南PDF电子书下载
  • 大数据技术与应用入门培训教程(电子版下载
  • Oracle OCP认证考试IZ0-053题库共712题数据
  • MySQL5权威指南(第3版)PDF电子版下载
快速回复 返回顶部 返回列表