Upgrade Oracle DBA 11g to Oracle Database 12c — Question 13

Which three types of failures are detected by the Data Recovery Advisor (DRA)?

Answer options

• A. loss of a non-critical data file
• B. loss of a control file
• C. physical data block corruption
• D. logical data block corruption
• E. loss of an archived redo log file

Correct answer: B, D, E

Explanation

The correct answers are B, D, and E because the Data Recovery Advisor specifically detects the loss of control files, logical data block corruption, and loss of archived redo log files as critical failures. Option A refers to a non-critical data file which is not monitored by the DRA, and option C addresses physical data block corruption, which is not a focus of DRA detection.