Using Data Recovery Advisor in Oracle Database 11g

The Data Recovery Advisor automatically diagnoses corruption or loss of persistent data on disk, determines the appropriate repair options, and executes repairs at the user's request

Now here are the simple steps how you can use DRA,the screenshots are also provided for a better result

NOTE:-You must have a full database backup available with you

Step 1)_shutdown the database using immediate option

step 2)_Before we can start identifying and repairing failures, we need to create one and for creating a simple error we are using the following command

echo > users01.dbf

the above command will intentionally corrupt the users01 datafile

Step 3)_connect with RMAN and list the failures by using list failure command

Step 4)_now type advise failure command and it will advise how to recover from the current situation

Step 5)_ Using the REPAIR FAILURE PREVIEW option will lists the contents of the repair script without applying it

Step 6)_now use the repair failure option for the repairing of the failure and type yes

Congratulations you have just repaired a failure using DRA