O'Reilly logo

OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide by Steve Ries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required