Which two activities are NOT supported by the Data Recovery Advisor?

Which two activities are NOT supported by the Data Recovery Advisor? (Choose two.)

Which two activities are NOT supported by the Data Recovery Advisor? (Choose two.)

A.
Diagnose and repair a data file corruption offline.

B.
Diagnose and repair a data file corruption online.

C.
Diagnose and repair failures on a standby database.

D.
Recover from failures in the Real Application Cluster (RAC) environment.



Leave a Reply 1

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


Jake from SF

Jake from SF

C and D are correct:

https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmrepai.htm

For C:
Data Recovery Advisor cannot use blocks or files transferred from a physical standby database to repair failures on a primary database. Also, you cannot use Data Recovery Advisor to diagnose and repair failures on a standby database. If you are using Enterprise Manager Grid Control in a Data Guard configuration, however, then you can fail over to a standby database and perform repairs on the old primary database.

For D:
If a data failure occurs that brings down all Oracle RAC instances, then you can mount the database in single-instance mode and use Data Recovery Advisor to detect and repair control file, SYSTEM datafile, and data dictionary failures. You can also invoke data recovery checks proactively to test other database components for data failures. This approach will not detect data failures that are local to other cluster instances, for example, an inaccessible datafile.