1Z0-052 Free Dumps Study Materials
Question 4: 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.
Correct Answer: A,D
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).