RMAN REPAIR FAILURE

Repair database failures identified by the Data Recovery Advisor.

Syntax
      REPAIR FAILURE [USING ADVISE OPTION integer]
         [NOPROMPT] [PREVIEW]

Key
   USING ADVISE OPTION  Specify a repair option by its option number
                        (not its failure number).
                        obtain the numbers via ADVISE FAILURE

   NOPROMPT 	         Suppress the confirmation prompt.

   PREVIEW 	         Do not make any repairs and generate a script
                        with all repair actions and comments.

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.

By default the script is displayed to standard output. You can use the SPOOL command to write the script to an editable file.

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.

Example

RMAN> LIST FAILURE;
RMAN> ADVISE FAILURE;
RMAN> REPAIR FAILURE PREVIEW;
RMAN> REPAIR FAILURE;

“What breaks in a moment may take years to mend” - Swedish Proverb

Related Commands:

RMAN
ADVISE FAILURE - Display repair options (11g Data Recovery Advisor)


© Copyright SS64.com 1999-2014
Some rights reserved