RMAN LIST and REPORT commands

The LIST Command:

• This command may be used to determine which backups are currently available
• Displays details of backups of the database, tablespaces, datafiles, archived logs and control files

Examples:

RMAN> LIST BACKUP BY BACKUP;
or
RMAN> LIST BACKUPSET BY BACKUP;
or
RMAN> LIST BACKUP BY BACKUP VERBOSE;
RMAN> LIST COPY OF DATABASE;
RMAN> LIST COPY OF TABLESPACE USERS;
RMAN> LIST COPY OF DATAFILE 3;

The REPORT Command:

• Helps a database administrator answer questions that are relevant to the backup and recovery strategy being implemented
• Some questions that are answered by the REPORT command are:

  Which files are in need of a backup?
  Which files are obsolete and may be deleted?
  What is the current physical structure of the database, and what was it at a previous point in time?

Examples:

RMAN>REPORT NEED BACKUP;
RMAN> REPORT NEED BACKUP DAYS=7 DATABASE;
RMAN> REPORT OBSOLETE;
RMAN> REPORT SCHEMA;
RMAN> REPORT NEED BACKUP RECOVERY WINDOW OF 2 DAYS DATABASE SKIP TABLESPACE TBS_2;
RMAN> REPORT NEED BACKUP REDUNDANCY 2 DATAFILE 1;
RMAN> REPORT NEED BACKUP TABLESPACE TBS_3; 
RMAN> REPORT NEED BACKUP INCREMENTAL 2;