Oracle Data Recovery Advisor

Hopefully, if you have any dealings with Oracle you will never need to deal with the Data Recovery Advisor - 'DRA'  in an actual disaster. It has been around ages but I always forget about it so thought I would post a reminder on here.

From the docs :

"Purpose of Data Recovery Advisor

Data Recovery Advisor is an Oracle Database tool that automatically diagnoses data failures, determines and presents appropriate repair options, and executes repairs at the user's request. In this context, a data failure is a corruption or loss of persistent data on disk. By providing a centralized tool for automated data repair, Data Recovery Advisor improves the manageability and reliability of an Oracle database and thus helps reduce the MTTR."

Easy to access through the Enterprise Manager Cloud Control 12c and via RMAN.

Great tutorial here :

http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r2/prod/ha/dra/dra.htm

Worth spending a bit of time on even though like I say you hopefully will never need it.