Wednesday, September 26, 2012

Data Recovery Advisor New Feature of Oracle Database 11g


New Feature of Oracle Database 11g is 'Data Recovery Advisor' (DRA). As the name indicates that the option determines the appropriate repair options according to the corruption. The advantage of this feature is that it reduced the complexity of recovery process. You can use Data Recovery Advisor through three options such as Enterprise Manager Database Control, Grid Control console & the RMAN command-line client.

DRA help users to recover oracle database with few new RMAN commands. Here are all RMAN commands which are used to perform Data Recovery Advisor.

1. List Failure
2. Advise Failure
3. Repair Failure
4. Change Failure
5. VALIDATE

1. List Failure:  The LIST FAILURE commands have two options to show any failures that is status & priority.

If any failure occured then it will show status 'OPEN' and a priority 'CRITICAL' or 'HIGH' in order of importance. If no such failures occured then it will list LOW priority failures. 

RMAN> LIST FAILURE;

2. Advise Failure: As the name indicates, ADVISE FAILURE command provides repair advice for failures listed by the LIST FAILURE command, as well as closing all open failures that are already repaired.

RMAN> ADVISE FAILURE;

3. Repair Failure: The REPAIR FAILURE will use the default repair scripts created by the ADVISE FAILURE command. Using the PREVIEW option lists the contents of the repair script without applying it.

RMAN> REPAIR FAILURE PREVIEW;

4. Change Failure: The CHANGE FAILURE command helps to change the priority of a failure or close an open failure. You can easily change the priority of a failure if it does not represent a problem to you by this command just like this

RMAN> CHANGE FAILURE 202 PRIORITY LOW;

5. VALIDATE: The other cool feature of Oracle 11g is 'validate database' which is use to check the entire database for block corruption

I will recommend to all Oracle DBAs that you should run a validate command after each database recovery operation to verify that there is no block corruption exists in your database.

No comments:

Post a Comment