Using Data Recovery Advisor

The recovery process begins when you either suspect or discover a failure. You can discover failures in many ways, including error messages, alerts, trace files, and health checks. You can then use Data Recovery Advisor to gain information and advice about failures and repair them automatically.

This section describes a scenario in which you use Data Recovery Advisor to repair a corrupted block. Assume that the Health Meter on the Database Home page indicates that an incident has occurred. The Alerts section of the page indicates that a block corruption has occurred.

To use the Oracle advised recovery strategy:

1. On the Database Home page, click Availability to display the Availability subpage.

2. Click Perform Recovery in the Manage section.

   The Perform Recovery page appears. The Perform Recovery page is divided into two sections: Oracle Advised Recovery and User-Directed Recovery. The Oracle Advised Recovery section uses Data Recovery Advisor to automate recovery.

3. Look for failures in the Oracle Advised Recovery section.

   In the screenshot shown in Step 2, the section indicates that one failure with high priority exists. The failure indicates that 1 or more data files are offline.

4. Do one of the following:

   • Click Advise and Recover.

   • Click the number next to the failure status.

   The View and Manage Failures page appears.

5. In the Priority drop-down list, select All and then click Go.

   This action enables you to view all failures known to Data Recovery Advisor. The data failures are represented as a navigation tree at the bottom of the page.

6. Perform the following actions:

   1. Select Data Failures from the navigation tree to expand it (if it is not expanded).

   2. Select the failure to expand it.

   3. Click Advise.

   The Recovery Advice page appears.

   This page shows the RMAN script that is used to repair the failure. For example, for a corrupted block, the script might look similar to the following:

   # block media recovery
   recover data file 1 block 63467;
   

7. Click Continue.

   The Review page appears. This page summarizes the recovery job.

8. Click Submit Recovery Job.

   The Job Activity page appears.

   A table describes details of the repair such as the job name, the job status, the time that the repair is scheduled to be performed, the owner of the job, and so on.

9. Click the name of the repair job and click View Results.

   The Job Run page appears.

   You can click the job step in the navigation tree to view the results of the job.