Managing Oracle Backups: Reporting


Use the RMAN LIST command to display information about backup sets, proxy copies, and image copies recorded in the repository. Use this command to list:


•        Backups and copies that do not have the AVAILABLE status in the RMAN repository
•        Backups and copies of data files that are available and can possibly be used in a restore operation
•        Backup sets and copies that contain a backup of a specified list of data files or specified tablespaces
•        Backup sets and copies that contain a backup of any archived logs with a specified name or range
•        Backup sets and copies restricted by tag, completion time, recoverability, or device
•        Incarnations of a specified database or of all databases known to the repository
•        Stored scripts in the recovery catalog

Use the RMAN REPORT command to analyze information in the RMAN repository in more detail.

The REPORT NEED BACKUP command is used to identify all data files that need a backup. The report assumes that the most recent backup would be used in the event of a restore.

Using the REPORT OBSOLETE command, you can identify files that are no longer needed to satisfy backup retention policies. By default, the REPORT OBSOLETE command reports which files are obsolete under the currently configured retention policy. You can generate reports of files that are obsolete according to different retention policies by using REDUNDANCY or RECOVERY WINDOW retention policy options with the REPORT OBSOLETE command.