Collection Contents Previous Next PDF

ASA Database Administration Guide

Database Options

Alphabetical list of options

RECOVERY_TIME option [database]


Function 

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

Allowed values 

Integer, in minutes

Scope 

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

Default 

2

Description 

This option is used with the CHECKPOINT_TIME option to decide when checkpoints should be done.

Adaptive Server Anywhere uses a heuristic to estimate the recovery time based on the operations that have been performed since the last checkpoint. Thus, the recovery time is not exact.

For more information, see The automatic recovery process.


Collection Contents Previous Next PDF