Category: Incomplete Recovery
-
Changing the Status of a Failure – RMAN Backups and Reporting
One last note on the Data Recovery Advisor: if you know that you have had a failure and that it is not 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 is a…
-
Suggesting Corrective Action – RMAN Backups and Reporting
The ADVISE FAILURE command gives advice about how to recover from potential problems detected by the Data Recovery Advisor. If you have multiple failures with your database, you can directly specify the failure ID to get advice on a given failure, like so: RMAN> advise failure 6222; Here is a snippet of the output for…
-
Determining What to Restore – RMAN Backups and Reporting
Media recovery requires that you perform manual tasks to get your database back in one piece. These tasks usually involve a combination of RESTORE and RECOVER commands. You have to issue an RMAN RESTORE command if, for some reason (accidental deleting of files, disk failure, and so on), your data files have experienced media failure.…
-
RMAN Reporting – RMAN Backups and Reporting
There are several different methods for reporting on the RMAN environment: • LIST command • REPORT command • Query metadata via data dictionary views When first learning RMAN, the difference between the LIST and REPORT commands may seem confusing because the distinction between the two is not clear-cut. In general, I use the LIST command…
Recent Posts
- Create a Directory Object and Granting Access – External Tables
- External Table Types – External Tables
- SQL*Loader vs. External Tables – External Tables
- Restoring and Recovering to a Different Server – RMAN Backups and Reporting
- FLASHBACK DATABASE – RMAN Backups and Reporting
