To reduce recovery time, checkpoints are used for the Rollback Recovery and the Precise Recovery. More specifically, there are two actions done when a checkpoint is reached:
Currently, checkpoints can only be defined by system time (e.g., every minute) but independently for each script. They have to be set as a parameter for the rollback recovery and the precise recovery:
#RECOVERYCONFIGURATION RollbackRecovery checkpoints=SystemTimeCheckpointManager checkpointunit=MINUTES checkpointperiod=1 [Definition of queries to apply rollback recovery] #RECOVERYCONFIGURATION PreciseRecovery checkpoints=SystemTimeCheckpointManager checkpointunit=HOURS checkpointperiod=2 [Definition of queries to apply precise recovery] |
Possible checkpointunits
are: MILLISECONDS
, SECONDS
, MINUTES
and HOURS
.