9.7 Performing Oracle Advised Recovery

The Oracle advised recovery feature uses Data Recovery Advisor, which is an Oracle Database feature that automatically diagnoses data failures, determines and presents appropriate repair options, and performs repairs if requested by the user. By providing a centralized tool for automated data repair, Data Recovery Advisor improves the manageability and reliability of an Oracle database.


Data Recovery Advisor can only be used to diagnose and repair failures in multitenant container databases (CDBs). It is not supported for pluggable databases (PDBs).

RMAN provides a command-line interface to the Data Recovery Advisor. You can use following RMAN commands to diagnose and repair data failures for the Oracle Database, including for Oracle RAC databases:


    Use this command to view problem statements for failures and the effect of these failures on database operations. Each failure is identified by a failure number.


    Use this command to view repair options, including both automated and manual repair options.


    Use this command to automatically repair failures listed by the most recent ADVISE FAILURE command.

See Also:

Oracle Database Backup and Recovery User's Guide for information about altering the status or priority of a failure by using the CHANGE FAILURE command

This section contains the following topics: