Display repair options for the specified failures. This command prints a summary of the failures identified by the Data Recovery Advisor and implicitly closes all open failures that are already fixed.
Syntax ADVISE FAILURE [{ALL | CRITICAL | HIGH | LOW | failure_no [,failure_no]…}] [EXCLUDE FAILURE failure_no [,failure_no]… ] Key ALL List options that repair all open failures together. CRITICAL List options that repair only critical failures. HIGH List options that repair only failures with HIGH priority. LOW List options that repair only failures with LOW priority. failureNumber List options that repair only the specified failures. EXCLUDE FAILURE failureNumber Exclude the specified failures from the list.
The recommended workflow is to run the following commands in an RMAN session:
LIST FAILURE to display failures, then ADVISE FAILURE to display repair options, and REPAIR FAILURE to fix the failures.
You can only use ADVISE FAILURE with no options when a LIST FAILURE command was previously executed in the current session.
RMAN must be connected to a target database. See the CONNECT and RMAN commands to learn how to connect to a database as TARGET.
The target database instance must be started. The target database must be a single-instance database and must not be a physical standby database, although it can be a logical standby database.
In the 11g release, Data Recovery Advisor only supports single-instance databases. Oracle Real Application Clusters (Oracle RAC) databases are not supported.
You should review the official Oracle documentation for your Platform/Version before running any repair operation on a live server.
Examples
RMAN> LIST FAILURE;
RMAN> ADVISE FAILURE;
“Men never plan to be failures; they simply fail to plan to be successful” ~ William Arthur Ward
Related Oracle Commands:
RMAN
REPAIR FAILURE - Repair database failures (11g Data Recovery Advisor)