Sunday, March 10, 2013

3 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

3 comments:

  1. UncutData Recovery specializes in retrieving or restoring files that are either lost, hidden, or deleted. In the event your files are lost, there’s no need to panic. In most cases, they are recoverable.  www.uncutdata.com

    ReplyDelete

 

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