Which two statements are true about instance recovery in a RAC environment?

The correct answer is B. Increasing the size of the default buffer cache can speed up instance recovery because instance D. The fast__start_mttr_target initialization parameter specifies only the instance recovery time. Many sites run with too few redo logs that are too small. Small redo logs cause system checkpoints to continuously put a high load on the buffer cache and I/O system. If there are too few redo logs, then the archive cannot keep up, and the database will wait for the archive…

Manage RAC Backups and Recovery

Question

Options

AParallel instance recovery will work even if the recovery_parallelism initialization parameter set to
BIncreasing the size of the default buffer cache can speed up instance recovery because instance
CThe fast_start_mttr_target initialization parameter includes both instance startup and recovery
DThe fast__start_mttr_target initialization parameter specifies only the instance recovery time.

How the community answered

(20 responses)

A
10% (2)
B
80% (16)
C
10% (2)

Explanation

Many sites run with too few redo logs that are too small. Small redo logs cause system checkpoints to continuously put a high load on the buffer cache and I/O system. If there are too few redo logs, then the archive cannot keep up, and the database will wait for the archive process to catch up. With the Fast-Start Fault Recovery feature, the FAST_START_MTTR_TARGET initialization parameter simplifies the configuration of recovery time from instance or system failure. FAST_START_MTTR_TARGET specifies a target for the expected mean time to recover (MTTR), that is, the time (in seconds) that it should take to start up the instance and perform Oracle Database Performance Tuning Guide

Topics

#instance recovery#fast_start_mttr_target#parallel recovery#buffer cache

Community Discussion

No community discussion yet for this question.

Full 1Z0-058 Practice