Which three activities are supported by the Data Recovery Advisor?
A.
Advising on block checksum failures
B.
Advising on inaccessible control files
C.
Advising on inaccessible block change tracking files
D.
Advising on empty password files
E.
Advising on invalid block header field values
Explanation:
* 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).