Database Reference
In-Depth Information
The Data Recovery Advisor is invoked from RMAN. You can think of the Data Recovery Advisor as a set of RMAN
commands that can assist you when dealing with media failure.
Listing Failures
When using the Data Recovery Advisor, the LIST FAILURE command is used to display any issues with the data files,
control files, or online redo logs:
RMAN> list failure;
If you suspect there's a media failure, yet the data recovery advisor is not reporting any issues, run the
VALIDATE DATABASE command to verify that the database is intact.
Tip
If there are no detected failures, you'll see a message indicating that there are no failures. Here is some sample
output indicating that there may be an issue with a data file:
List of Database Failures
=========================
Failure ID Priority Status Time Detected Summary
---------- -------- --------- ------------- -------
6222 CRITICAL OPEN 12-JAN-14 System datafile 1:
'/u01/dbfile/O12C/system01.dbf' is missing
To display more information about the failure, use the DETAIL clause:
RMAN> list failure 6222 detail;
Here is the additional output for this example:
Impact: Database cannot be opened
With this type of failure, the prior output indicates that the database can't be opened.
Suggesting Corrective Action
The ADVISE FAILURE command gives advice about how to recover from potential problems detected by the Data
Recovery Advisor. If you have multiple failures with your database, you can directly specify the failure ID to get advice
on a given failure, like so:
RMAN> advise failure 6222;
 
Search WWH ::




Custom Search