RMAN Report Command

The RMAN REPORT command generates various reports from the backup catalog.

To report which database files need to be backed up to meet the current retention policy use:

RMAN> REPORT NEED BACKUP;

To report all obsolete backups use:

RMAN> REPORT OBSOLETE;