Oracle 11g New Feature: RMAN Data Recovery Advisor
In Oracle 11g, RMAN provides a new advisor called Data Recovery Advisor (DRA). DRA has several new commands to help DBAs for performing recovery tasks.
To list of database failures, you can issue:
1 2 3 4 5 6 7 8 9 |
RMAN> list failure; List of Database Failures ========================= Failure ID Priority Status Time Detected Summary ---------- -------- --------- ------------- ------- 522 HIGH OPEN 08-SEP-09 One or more non-system datafiles are missing |
DRA will consolidate related failures into a single failure. You can list a failure individually by issuing “list failure X detail” command.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
RMAN> list failure 522 detail; List of Database Failures ========================= Failure ID Priority Status Time Detected Summary ---------- -------- --------- ------------- ------- 522 HIGH OPEN 08-SEP-09 One or more non-system datafiles are missing Impact: See impact for individual child failures List of child failures for parent failure ID 522 Failure ID Priority Status Time Detected Summary ---------- -------- --------- ------------- ------- 525 HIGH OPEN 08-SEP-09 Datafile 4: '/abc' is missing Impact: Some objects in tablespace USERS might be unavailable |