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:
In Odysseus, the checkpoints are defined by system time (e.g., every minute). They have be set as a parameter for the rollback recovery and the precise recovery:
#RECOVERYCONFIGURATION RollbackRecovery protectionpointunit=MINUTES protectionpointperiod=1 [Definition of queries to apply rollback recovery] #RECOVERYCONFIGURATION PreciseRecovery protectionpointunit=HOURS protectionpointperiod=2 [Definition of queries to apply precise recovery] |
Possible protectionpointunits
are: MILLISECONDS
, SECONDS
, MINUTES
and HOURS
.