RECOVERY_TIME Option

Sets the maximum length of time, in minutes, that the database server takes to recover from system failure.

Allowed Values

Integer, in minutes

Default

2

Scope

Can be set only for the PUBLIC group. Takes effect when the server is restarted.

Description

Use this option with the CHECKPOINT_TIME option to decide when checkpoints should be done.

A heuristic measures the recovery time based on the operations since the last checkpoint. Thus, the recovery time is not exact.

Related reference
CHECKPOINT_TIME Option