Reporting in RMAN

As much as it is important to backup your database, it is equally important that you know what you have done already and what is still pending. For example, you must know which data files you have already backed up and which still require backing up. For this kind of reporting in RMAN, there are two commands available: LIST and REPORT. Though both the commands are meant to be used for reporting purposes, they solve two very distinct purposes. In this section, we will have a look at RMAN's reporting commands.

Using the LIST command

The LIST command is primarily used to list the existing backups and image copies of the database. There are several other variations of this command as well, for example, listing the failures (like a data file is deleted) or the stored scripts, and so on. The following are a few examples using the LIST command:

RMAN> LIST BACKUP SUMMARY;

List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag...