【11g】Repairing Data Corruptions with the Data Recovery Advisor

Repairing Data Corruptions with the Data Recovery Advisor

您可以使用数据恢复顾问来修复数据块损坏、撤消损坏、数据字典损坏等等。数据恢复顾问与企业集成管理器支持工作台(Workbench支持),健康状况监控器,和RMAN工具来显示数据损坏问题,评估每个问题的严重程度(重要,优先级高,低优先级),描述一个问题所带来的影响,建议修复选项,进行可行性检查customer-chosen选项,自动修复过程。

本节描述从支持工作台访问advisor的各种方法。当您查看数据时，支持工作台会自动推荐并访问数据恢复顾问:

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

数据恢复顾问也可以从Advisor中央页面获得。这个页面的链接可以在数据库主页和性能页面的相关链接部分找到。

Note:

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

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.

See Also:

Oracle Database 2 Day DBA and Oracle Database Backup and Recovery User's Guide for more information about the Data Recovery Advisor