OCP CBT Question 571

Please solve the following question.

After an unexpected database shutdown due to a power outage, your Oracle database instance fails to start. You find several errors related to corrupt data blocks in the alert log. You want to use the Data Recovery Advisor (DRA) to diagnose the problem and propose a repair strategy. Which sequence of RMAN commands would you use?

sql-- Database instance is currently down.-- Alert log shows block corruption errors.-- Database is in ARCHIVELOG mode.

sqlRMAN> STARTUP MOUNT;RMAN> ADVISE FAILURE;RMAN> REPAIR FAILURE;

sqlRMAN> ADVISE FAILURE;RMAN> REPAIR FAILURE;

sqlRMAN> LIST FAILURE;RMAN> REPAIR FAILURE PREVIEW;RMAN> REPAIR FAILURE;

sqlRMAN> STARTUP FORCE;RMAN> ADVISE FAILURE;RMAN> REPAIR FAILURE;