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.
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
ADVISE FAILURE - Display repair options (11g Data Recovery Advisor)