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.