9.9 Repairing Data Corruptions with the Data Recovery Advisor

«« Previous
Next »»

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.

The Cloud Control online help provides details on how to use the Data Recovery Advisor. This section describes how 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 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.

To access the Data Recovery Advisor in Cloud Control:

1. Access the Database Home page in Cloud Control.

The Data Recovery Advisor is available only when you are connected as SYSDBA.

2. From the Oracle Database menu, select Diagnostics, then Support Workbench.

3. Click Checker Findings.

The Checker Findings subpage appears.

Data Recovery, Oracle Database Tutorials and Materials
This image shows the Checker Findings subpage of the Support Workbench home page. The page contains a Search section, which contains four horizontally arranged search fields and a Go button, and a Data Corruption section, which contains a table of the data corruptions detected by health checkers. The table columns are as follows: Select, Description, Priority, Damage Translation, Incident ID, Status, and Time Detected. Above the table is a Launch Recovery Advisor button. The table shows one finding (one row), and the Description column for the finding explains that one or more system data files are missing

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

«« Previous
Next »»