Question

You notice that the database instance takes a long time to start up after the instance crash. How will you resolve the problem?

(a) Increase the size of the redo log files

(b) Decrease the number of redo log members

(c) Set LOG_CHECKPOINT_TO_ALERT to TRUE

(d) Decrease the value for the FAST_START_MTTR_TARGET initialization parameter

The question was asked by my school teacher while I was bunking the class.

This key question is from Installing Oracle Database 11g and Creating a Database in section Oracle Database 11g Architecture Options of Oracle

Answer 1

Right option is (d) Decrease the value for the FAST_START_MTTR_TARGET initialization parameter

The best I can explain: FAST_START_MTTR_TARGET enables you to specify the number of seconds the database takes to perform crash recovery of a single instance.

FAST_START_MTTR_TARGET contains below information.