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

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

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

A.
Parallel instance recovery will work even if the recovery_parallelism initialization parameter set
to 0 or 1.

B.
Increasing the size of the default buffer cache can speed up instance recovery because
instance recovery may use as much as 50 percent of the default buffer cache for recovery buffers.

C.
The fast_start_mttr_target initialization parameter includes both instance startup and recovery
time.

D.
The fast__start_mttr_target initialization parameter specifies only the instance recovery time.

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 cache
recovery.
Oracle Database Performance Tuning Guide



Leave a Reply 3

Your email address will not be published. Required fields are marked *


Alex

Alex

The explanation itself states the correct answer is B & C, and not B &D.

L. Zhu

L. Zhu

A is wrong. recovery_parallelism set to 0 or 1 disables parallel instance recovery
B is right.
C is right. fast_start_mttr_target includes both instance startup and recovery
D is wrong.

So B.C. are correct.

JORTEGAH

JORTEGAH

It is difficult to decide because:

http://newappsdba.blogspot.com.es/2007/10/rac-crash-recovery.html
“FAST_START_MTTR_TARGET includes both instance startup and crash recovery. If you have a RAC environment and there is a failure the surviving instances will perform the recovery. Therefore including the instance startup time in the mean time to recover calculation isn’t accurate”

But I think that in any case the right one is C