In an attempt to further simplify recoveries, Oracle introduced the Data Recovery Advisor (DRA ) in Version 11g. The DRE is a framework that is integrated into the Automatic Diagnostic Repository (ADR ) that we learned about in Chapter 6, Managing the Oracle Instance. The DRA can provide a streamlined interface for database recovery using either a command-line interface or Enterprise Manager. However, there are a few requirements of which we must be aware. They are as follows:
The DRA can only operate when the database is in the NOMOUNT state or higher. It cannot be used when the database is completely closed. This is not too much of a concern, because it follows that the only aspect of recovery that the DRA cannot perform is the recovery of an initialization parameter file.
The DRA does not support the use of Real Application Clusters, although it can perform recovery in a single-instance mode.
The DRA does not support the recovery of Data Guard databases...