Sets the maximum length of time (in minutes) for recovery from system failure.
{ dbsrv11 | dbeng11 } -gr minutes ...All operating systems and database servers.
When a database server is running with multiple databases, the recovery time that is specified by the first database started is used unless overridden by this option.
The value specified by the -gr option instructs the database server how often to perform a checkpoint. For example, if you set -gr to 5, then the database server tries to perform checkpoints often enough so that recovery takes no longer than 5 minutes. However, if recovery is necessary, it runs to completion, even if it takes longer than the length of time specified by -gr. The default value is the setting of the recovery_time database option, which defaults to 2 minutes.
The recovery time includes both the estimated recovery time and the estimated checkpoint time for the database.
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |