Databases Reference
In-Depth Information
Depending on your situation, the
advise failure
output will contain one or both of the following sections:
•
Manual Checklist
•
Automated Repair Options
The Manual Checklist section gives you advice for manually resolving the issue. For example, you may not have
the required backups to restore a file, so the advice might be to find a copy of the file and restore it manually.
The Automated Repair Options section provides you with RMAN commands that you can use to resolve the
problem. Table
20-2
describes the columns contained in the Automated Repair Options output.
Table 20-2.
Descriptions of Automated Repair Options
Column
Description
Option
An identifying number for a repair operation
Strategy
A complete recovery strategy (no data loss) or an incomplete recovery
(data loss) strategy
Repair Description
A brief description of the proposed repair operation
Repair Script
A script that contains the proposed commands to resolve the problem
The Automated Repair Options section will list the location and name of a repair script that contains RMAN
commands to resolve the problem. At this point, you may want to open another terminal session and inspect the
contents of the repair script (with a text editor such as
vi
or
Notepad
). Here is some sample content for this example:
# restore and recover datafile
restore ( datafile 4 );
recover datafile 4;
sql 'alter database datafile 4 online';
By analyzing the script you can gain a greater understanding of the failure and how RMAN intends to resolve the
problem. If you want RMAN to automatically repair the failure, then run the
repair failure
command as described
in Recipe 20-3.
Repairing Failures
Problem
You've experienced a media failure. You want to use the Data Recovery Advisor to perform a restore and recovery.
Solution
We recommend that you always run the following RMAN commands in this order (without exiting RMAN between
each command):
1.
list failure
2.
advise failure
3.
repair failure