Which two activities are NOT supported by the Data Recovery Advisor (DRA)? (Choose two.)
A.
Recover from failures in the RAC environment.
B.
Diagnose and repair a data file corruption online.
C.
Diagnose and repair a data file corruption offline.
D.
Diagnose and repair failures on a standby database.
Explanation:
Data Recovery Advisor
The Data Recovery Advisor automatically gathers data failure information when an error is
encountered. In addition, it can proactively check for failures. In this mode, it can potentially detect
and analyze data failures before a database process discovers the corruption and signals an error.
(Note that repairs are always under human control.)
Data failures can be very serious. For example, if your current los files are missing, you cannot
open your database. Some data failures (like block corruptions in data files) are not catastrophic
because they do not take the database down or prevent you from opening the Oracle instance.
The Data Recovery Advisor handles both cases: the one when you cannot start up the database
(because required database files are missing, inconsistent, or corrupted) and the one when file
corruptions are discovered during run time.
Supported Database Configurations
In the current release, the Data Recovery Advisor supports single-instance databases. Oracle
Real Application Clusters databases are not supported.The Data Recovery Advisor cannot use blocks or files transferred from a standby database to
repair failures on a primary database. Furthermore, you cannot use the Data Recovery Advisor to
diagnose and repair failure on a standby database. However, the Data Recovery Advisor does
support failover to a standby database as a repair option (as mentioned above).