RMAN ADVISE FAILURE

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 Commands:

RMAN
REPAIR FAILURE - Repair database failures (11g Data Recovery Advisor)


© Copyright SS64.com 1999-2013
Some rights reserved