Database Reference
In-Depth Information
Type
YES
to proceed:
YES
If all goes well, you should see a final message such as this in the output:
repair failure complete
■
Note
you can run the data recovery advisor commands from the rMaN command prompt or from Enterprise
Manager.
In this way, you can use the RMAN commands
LIST FAILURE
,
ADVISE FAILURE
, and
REPAIR FAILURE
to resolve
media failures.
Changing the Status of a Failure
One last note on the Data Recovery Advisor: if you know that you've had a failure and that it isn't critical (e.g., a data
file missing from a tablespace that is no longer used), then use the
CHANGE FAILURE
command to alter the priority of
a failure. In this example, there's a missing data file that belongs to a noncritical tablespace. First, obtain the failure
priority via the
LIST FAILURE
command:
RMAN> list failure;
Here is some sample output:
Failure ID Priority Status Time Detected Summary
---------- -------- --------- ------------- -------
5 HIGH OPEN 12-JAN-14 One or more non-system datafiles
are missing
Next, change the priority from
HIGH
to
LOW
with the
CHANGE FAILURE
command:
RMAN> change failure 5 priority low;
You will be prompted to confirm that you really do want to change the priority:
Do you really want to change the above failures (enter YES or NO)?
If you do want to change the priority, then type
YES
, and press the Enter key. If you run the
LIST FAILURE
command again, you'll see that the priority has now been changed to
LOW
:
RMAN> list failure low;