DEFERAPPLYINTERVAL
Valid For
Replicat
Description
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
.
If you want to stop a process (like the Replicat) at a specific time, use the
END
parameter.
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
-
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 HOURS
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.
Parent topic: Oracle GoldenGate Parameters