Fast Recovery

During a server restart after a planned or unplanned shutdown, or during high availability failover, a significant portion of time is spent on database recovery. Faster recovery minimizes database downtime.

• SAP ASE Start-up Sequence
  SAP ASE performes a specific sequence of steps at start-up.
• Bringing Engines Back Online
  Engines are brought online after system databases are recovered, and before user databases, allowing user databases to be recovered in parallel, and makes the engines available for online activities.
• Parallel Recovery
  Databases are recovered in parallel by multiple recovery tasks during start-up and failover.
• Database Recovery
  SAP ASE database recovery includes checking buffer pool sizes and setting async prefetch.
• Specifying the Recovery Order
  Users can specify the order in which databases are recovered, for all or a subset of user databases.
• Parallel Checkpoints
  A pool of checkpoint tasks works on the list of active databases in parallel.
• Recovery State
  The global variable @@ recovery_state determines if SAP ASE is in recovery.
• Tuning for Fast Recovery
  Review the database layout, runtime configuration, and the data space accounting setting to reduce recovery time.