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.



Leave a Reply 6

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


rohit kumar

rohit kumar

Coore answer is B & C.

http://newappsdba.blogspot.in/2007/10/rac-crash-recovery.html

FAST_START_MTTR_TARGET includes the time for startup, mount, crash recovery, and open.

FAST_START_INSTANCE_RECOVERY_TARGET includes the time for instance recovery only.

http://docs.oracle.com/cd/B10500_01/server.920/a96533/instreco.htm

To use parallel processing, the value of RECOVERY_PARALLELISM must be greater than 1 and cannot exceed the value of the PARALLEL_MAX_SERVERS initialization parameter.

Ivo

Ivo

Yep, I go for B & C

Dmitry

Dmitry

fast_start_instance_recovery_target DOES NOT EXIST in 11.2 !!!

B,D is correct

Dmitry

Dmitry

FAST_START_MTTR_TARGET enables you to specify the number of seconds the database takes to perform crash recovery of a single instance.