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部落格 ” ,連結:http://blog.itpub.net/7199859/viewspace-711735/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle goldengate 雙活複製避免迴圈複製引數OracleGo
- 用shell實現Mysql延時複製MySql
- 實現Mysql延時複製MySql
- 用python生成oracle goldengate複製配置檔案PythonOracleGo
- oracle goldengate 雙向複製配置OracleGo
- EOFDELAYCSECS GOLDENGATE提升複製實時性Go
- oracle goldengate引數學習OracleGo
- Oracle GoldenGate常用引數詳解OracleGo
- MySQL並行複製延時時間不準確MySql並行
- MySQL 8 複製(三)——延遲複製與部分複製MySql
- 應用響應時延背後 深藏的網路時延
- goldengate配置DDL複製Go
- GoldenGate的複製原理Go
- 資料複製_GoldenGateGo
- GoldenGate單向複製配置(支援DDL複製)Go
- goldengate 目的端程式引數APPLYNOOPUPDATES 和ALLOWNOOPUPDATESGoAPPOOP
- 搭建oracle 11.2.0.4環境下的goldengate複製OracleGo
- Oracle 11g GoldenGate單向複製配置(DML)OracleGo
- GOLDENGATE常用引數Go
- goldengate基於表複製Go
- GoldenGate多對一複製Go
- goldengate 單向複製配置Go
- MySQL 5.7 複製的過濾引數MySql
- goldengate抽取程式延遲90小時Go
- Oracle goldengate 11g (二)【DML and DDL單向複製】OracleGo
- 通過goldengate從ORACLE向mysql的單向複製GoOracleMySql
- mysql主從延遲複製MySql
- PostgreSQL中的複製延遲SQL
- MySQL 5.7 延遲複製配置MySql
- MySQL8.0的一個bug導致複製延時MySql
- goldengate單向複製的配置Go
- goldengate的HANDLECOLLISIONS引數Go
- goldengate的ASSUMETARGETDEFS引數Go
- 【GoldenGate】Oracle GoldenGate Veridata 安裝配置與應用GoOracle
- goldengate不使用資料泵完成Oracle-Oracle的雙向複製GoOracle
- 每天一個 PHP 語法五引用計數與寫時複製的實現PHP
- oracle goldengate ddl 操作導致複製程式abended處理案例OracleGo
- 關於Oracle GoldenGate 引數TRANLOGOPTIONS altarchivelogdestOracleGoHive