Using the Data Recovery Advisor

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 ...

Get OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.