Which three types of failures are detected by the Data …

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

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

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



Leave a Reply 4

Your email address will not be published. Required fields are marked *


tk

tk

What is the correct answer?

MS

MS

A,B,C or D

Not sure

Mia

Mia

Ans A, B, C
https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmrepai.htm#BRADV89716

Data Recovery Advisor can diagnose failures such as the following:

– 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

– 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)