2 Data Recovery Advisor

Data recovery advisor is the new features in 11g.

 

Data recovery Advisor related tables

• V$IR_FAILURE: List all the failures.  Similar to the V$HM_FINDING
• V$IR_FAILURE_SET
• V$IR_REPAIR List the automatic repair steps
• V$IR_MANUAL_CHECKLIST: List the manually repair steps

 

Data recovery Advisor  from OEM

 

The advise home list all the failures from V$IR_FAILURE .  Click advise button,

I don’t have too much failure in my test environment. The only failure and its recommendation is to open case with Oracle

Data recovery Advisor  from RMAN

$ORACLE_HOME/bin/rman target /

LIST FAILURE;

ADVISE FAILURE;

REPAIR FAILURE PREVIEW;

REPAIR FAILURE;

List failure

Advise failure

 

Data recovery Advisor  from SQL

select * from V$IR_FAILURE;

select * from V$IR_MANUAL_CHECKLIST;