*Data Recovery Advisor can diagnose failures such as the following:
/ (B)Components such as datafiles and control files that are not accessible because they do not exist, do not have the correct access permissions, have been taken offline, and so on
/ (A, E)Physical corruptions such as block checksum failures and invalid block header field values
/Inconsistencies such as a datafile that is older than other database files
/I/O failures such as hardware errors, operating system driver failures, and exceeding operating system resource limits (for example, the number of open files)
*The Data Recovery Advisor automatically diagnoses corruption or loss of persistent data on disk, determines the appropriate repair options, and executes repairs at the user's request.
This reduces the complexity of recovery process, thereby reducing the Mean Time To Recover (MTTR).