Recovering Oracle

When you configure Oracle, it is wise to take into account recovery time as well as performance. In this section we focus on crash recovery, rather than database restore and roll-forward recovery after media failure.

Crash recovery should not happen often, but when it does you’ll probably be grateful for any steps you took with a view to reducing the recovery time. In this section we explore Oracle tunables that relate to checkpoints and recovery and consider the trade-off between performance and recovery time.

Checkpoints are described briefly in “Pagecleaners” on page 55, and crash recovery is described in “Database Recovery Process” on page 55. Checkpoints and recovery time are an issue in environments where insert, update, ...

Get Configuring and Tuning Databases on the Solaris™ Platform now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.