Repairing Data Corruptions with the Data Recovery Advisor

You use the Data Recovery Advisor to repair data block corruptions, undo corruptions, data dictionary corruptions, and more. The Data Recovery Advisor integrates with the Enterprise Manager Support Workbench (Support Workbench), with the Health Monitor, and with the RMAN utility to display data corruption problems, assess the extent of each problem (critical, high priority, low priority), describe the impact of a problem, recommend repair options, conduct a feasibility check of the customer-chosen option, and automate the repair process.

Oracle Database 2 Day DBA provides details on how to use the Data Recovery Advisor. This section describes the various ways to access the advisor from the Support Workbench.

The Data Recovery Advisor is automatically recommended by and accessible from the Support Workbench when you are viewing:

• Problem details for a problem that is related to a data corruption or other data failure.

• Health checker findings that are related to a data corruption or other data failure.

The Data Recovery Advisor is also available from the Advisor Central page. A link to this page can be found in the Related Links section of the Database Home page and of the Performance page.

You access the Data Recovery Advisor from the Support Workbench in the following ways:

• From the Problem Details page

  
  Description of the illustration dra_access_1.gif
  
  

  Click the Data Recovery Advisor link in the Investigate and Resolve section.

  See "Viewing Problems with the Enterprise Manager Support Workbench" for instructions on how to access this page.

• From the Checker Findings subpage of the Support Workbench home page

  
  Description of the illustration dra_access_2.gif
  
  

  Select one or more data corruption findings and then click Launch Recovery Advisor.

  See "Viewing Problems with the Enterprise Manager Support Workbench" for instructions on how to access the Support Workbench home page.