RelationalDBDesign RelationalDBDesign

Backup Recovery   «Prev  Next»
Lesson 6 Reporting
Objective Create reports and lists about backups.

Oracle Database Backup Reports

Recovery Manager, or RMAN, can create useful lists and reports of backups and image copies. RMAN obtains the information from your metadata repository, either the control file or the recovery catalog. Use the report and list commands to determine what you have, or need to back up or copy. The information, which is available whether or not you use a recovery catalog, is extremely helpful in developing an effective backup strategy.
The list command shows the contents of RMAN's metadata repository, all RMAN backups (both backup sets and proxy copies) and image copies. The report command performs a more detailed analysis. For example, it can generate a report on the datafiles that need a backup when the backup pieces are obsolete. The report command can list backup sets and datafile copies that can be deleted either because they are redundant or because they are unrecoverable. RMAN writes the output from these commands to the screen or to a log file.
The list command queries the recovery catalog or control file and produces a record of its contents. Use it to list:
  1. Backups of a specified list of datafiles
  2. Image copies of a specified list of datafiles
  3. Backups of any datafile that is a member of a specified list of tablespaces
  4. Image copies of any datafile that is a member of a specified list of tablespaces
  5. Backups of any archived redo logs with a specified name and/or within a specified range
  6. Image copies of any archived redo log with a specified name and/or within a specified range
  7. Incarnations of a specified database

RMAN reports are intended to provide analysis of your backup and recovery situation. An RMAN report can answer questions such as:
  1. Which datafiles need a backup?
  2. Which datafiles have not been backed up recently?
  3. Which datafiles need to be backed up since less than n number of backups or copies are available?
  4. Which backups and copies can be deleted?
  5. Which datafiles are not recoverable because of unrecoverable operations performed on them?
  6. What is the current physical schema of the database or what was it at some previous time?
  7. Which backups are orphaned, that is, unusable within a restore operation, because they belong to incarnations of the database that are not direct predecessors of the current incarnation?


Within Oracle, the output of the LIST BACKUP command is significantly improved. It now prints the list of backups belonging to a backup set. This is contained within a separate section of the report, from the list of data files or archived logs included within the backup set.
A new command, REPORT NEED BACKUP REDUNDANCY, has been implemented. When fewer than a user-specified number of backups of a data file exist, this report alerts the user that a new backup is required.
In the following simulation, we will connect to RMAN and run one LIST and REPORT command, and review the results displayed by it.
Writing list Report Commands
The following SlideShow lists some of the new commands for the LIST and REPORT feature within RMAN.

Connect Target Rman
Designing Oracle Report
For REPORT commands, the next SlideShow illustrates the code requirements. Click the link below to see this SlideShow.
Incremental Report Backup
The next lesson describes some of the data dictionary views for backup and recovery.