Sunday, March 10, 2013

0 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,

image

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

image

Data recovery Advisor  from RMAN

$ORACLE_HOME/bin/rman target /
LIST FAILURE;
ADVISE FAILURE;
REPAIR FAILURE PREVIEW;
REPAIR FAILURE;

List failure

image

Advise failure

image

 

Data recovery Advisor  from SQL

select * from V$IR_FAILURE;
select * from V$IR_MANUAL_CHECKLIST;

image

image

0 comments:

Post a Comment

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates