Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIVELOG mode?

Which options would you consider while configuring a flash recovery area (fast recovery
area in 11g Release 2) for your production database that is running in ARCHIVELOG mode?
(Choose all that apply.)

Which options would you consider while configuring a flash recovery area (fast recovery
area in 11g Release 2) for your production database that is running in ARCHIVELOG mode?
(Choose all that apply.)

A.
Setting the FAST_START_MTTR_TARGET to set the mean time to recover

B.
Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs

C.
Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery
area

D.
Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit
for the recovery files created in the flash recovery area

Show Hint

Leave a Reply 1

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

Eamon

Eamon

Answers C and D certainly.
Answer B is worng because FAST_START_MTTR_TARGET defaults to 0 which disables recovery tuning which in turns maximizes normal performance. This is normally desired and therefore this parameter is not normally set.

Reply