oracle goldengate 复制端延时应用参数
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.
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
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
Syntax DEFERAPPLYINTERVAL
Argument Description
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.
The unit of time for the delay. Can be:
S | SEC | SECS | SECOND | SECONDS | MIN | MINS | MINUTE | MINUTES | HOUR | HOURS |
DAY | DAYS
time is the value that is set for the EOFDELAY parameter. The maximum
delay time is seven days.
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.
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参数
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7199859/viewspace-711735/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
老婆童装店今天升5钻
下一篇：
goldengate项目加班中
请登录后发表评论
登录
全部评论
最新文章
- 《手把手教你用AI安装Oracle 19c（附详细步骤）》
- 《3小时手工安装Oracle，用AI只需15分钟》
- oracle 20c 不支持non-cdb架构
- 当删除oracle数据库user时发生row cache lock 等待事件
- 通过 Oracle_Cloud_Infrastructure oci 云认证考试
- ORA-32021: parameter value longer than 255 characters 解决方法
- online清理oracle 监听日志推荐的做法
- 分享查看统计信息非常好的脚本
- impdp 导入 schema的数据时会自动创建对应的用户
- 如何移动asm磁盘组内的数据文件到另外一个磁盘组
