To tylko jedna z 2 stron tej notatki. Zaloguj się aby zobaczyć ten dokument.
Zobacz
całą notatkę
Using Data Recovery Advisor
The recovery process begins when you either suspect or discover a failure. You can
discover failures in many ways, including error messages, alerts, trace files, and health
checks. You can then use Data Recovery Advisor to gain information and advice about
failures and repair them automatically.
This section describes a scenario in which you use Data Recovery Advisor to repair a
corrupted block.
To use the Oracle advised recovery strategy to automatically repair failures:
1. Connect RMAN to the target database as described in "Connecting to the Target
Database" on page 9-9.
2. List all the failures know to the Data Recovery Advisor by running the following
command:
LIST FAILURE;
List of Database Failures
=========================
Failure ID Priority Status Time Detected Summary
---------- -------- ------ ------------- --------
142 HIGH OPEN 23-APR-07 One or more non-system datafiles are
missing
101 HIGH OPEN 23-APR-07 Datafile 1: '/disk1/oradata/prod/
system01.dbf' contains one or more
corrupt blocks
Wherever possible, RMAN consolidates failures while displaying the result of the
LIST FAILURE command. For example, if a data file contains multiple block
failures, the LIST FAILURE command consolidates and displays the repair options.
3. If you suspect that some failures that have not been automatically diagnosed by
the database exist, then check for corrupt blocks and missing data files by using
the following command:
VALIDATE DATABASE;
If a problem is detected during the validation, then RMAN triggers the execution
of a failure assessment
4. Determine repair options, both automatic and manual, by using the following
command:
ADVISE FAILURE;
5. Fix the failures by using the following command:
REPAIR FAILURE;
Automated repairs are performed by the Data Recovery Advisor. In certain cases,
such as when no backups exist for a lost control file, the only repair option
possible is the manual option.
... zobacz całą notatkę
Komentarze użytkowników (0)