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).
A,B,E
http://docs.oracle.com/cd/E29597_01/backup.1111/e10642/rcmrepai.htm
A, E – TRUE
Physical corruptions such as block checksum failures and invalid block header field values
B – TRUE
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
http://docs.oracle.com/cd/E29597_01/backup.1111/e10642/rcmrepai.htm
ABE
A B and E
ABE – OK
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
Physical corruptions such as block checksum failures and invalid block header field values
http://docs.oracle.com/database/121/BRADV/rcmrepai.htm#BRADV89716
ABE
ABE
ABE
A,B,E are correct