Displaying Backup Reports

Backup reports contain summary and detailed information about past backup jobs run by RMAN, including both backups run through Enterprise Manager and the RMAN command-line client.

To view backup reports, from the Maintenance property page, in the Backup and Recovery section, click Backup Reports.

The page contains a list of recent backup jobs. You can use the Filter By section of the page to restrict the backups listed by the time of the backup, the type of data backed up, and the status of the jobs to be listed (whether it succeeded or failed, and whether warnings were generated during the job). Specify any filter conditions and click Go to restrict the list to backups of interest.

The list contains basic information for each backup:

• The name, start time and run time of the backup

• The type of the backup (such as full or incremental database backup, archived log backup, backup of datafiles only, and so on)

• The status of the backup (whether it succeeded or failed, and whether there were warnings associated with it)

• The output destination (which can be disk or tape, or * to indicate output on both disk and tape

• The size of inputs (files backed up), output (files written to disk or tape) and the rate at which backups were written

To view detailed information about any backup, click the value in the Backup Name column. The View Backup Report page is displayed for the selected backup. This page contains summary information about this backup (how many files of each type were backed up, how much data total, and the number, size and type of output files created), as well as details about inputs and outputs for the backup job, such as:

• Datafiles backed up, by datafile number and tablespace name

• Archived logs by sequence and thread number, and range of times and SCNs covered by the logs

• Number of corrupt blocks found in input files

• Tags, backup piece names or filenames for outputs

• Size of output files and compression ratios

For recent jobs, you can also view a log of RMAN output for the job, by clicking the value in the Status column.

The View Backup Report page also contains a Filter By section that you can use to quickly run a search for another backup or backups from a specific date range. The resulting report contains aggregate information for backups matching the search criteria.