Category: External Table Types
-
Validating Backup Files Before Restoring – RMAN Backups and Reporting
There are several levels of verification that you can perform on backup files without actually restoring anything. If you just want RMAN to verify that the files exist and check the file headers, then use the RESTORE … VALIDATE HEADER command, as shown here: RMAN> restore database validate header; The command only validates the existence…
-
Previewing Backups Used for Recovery – RMAN Backups and Reporting
Use the RESTORE … PREVIEW command to list the backups and archive redo log files that RMAN will use to restore and recover database data files. The RESTORE … PREVIEW command does not actually restore any files. Rather, it lists the backup files that will beused for a restore operation. This example previews in detail…
-
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…
-
Using Data Recovery Advisor – RMAN Backups and Reporting
The Data Recovery Advisor tool was introduced in Oracle Database 11g. In the event of a media failure, this tool will display the details of the failure, recommend corrective actions, and perform the recommended actions if you specify that it do so. It is like having another set of eyes to provide feedback when in…
-
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
