RMAN - LIST & REPORT

LIST BACKUP;           # lists backup sets, image copies, and proxy copies
LIST BACKUPSET;    # lists only backup sets and proxy copies
LIST COPY;                # lists only disk copies

LIST EXPIRED BACKUP;
LIST BACKUP BY FILE; # shows backup sets, proxy copies, and image copies
LIST COPY BY FILE;      # shows only disk copies

LIST EXPIRED BACKUP BY FILE;

LIST BACKUP SUMMARY;  # lists backup sets, proxy copies, and disk copies
LIST EXPIRED BACKUP SUMMARY;

# lists backups of all files in database

LIST BACKUP OF DATABASE; 

# lists copy of specified datafile

LIST COPY OF DATAFILE 'ora_home/oradata/trgt/system01.dbf'; 

# lists specified backup set

LIST BACKUPSET 213; 

# lists datafile copy

LIST DATAFILECOPY '/tmp/tools01.dbf';

# specify a backup set by tag

LIST BACKUPSET TAG 'weekly_full_db_backup';

# specify a backup or copy by device type

LIST COPY OF DATAFILE 'ora_home/oradata/trgt/system01.dbf' DEVICE TYPE sbt;

# specify a backup by directory or path

LIST BACKUP LIKE '/tmp/%';

# specify a backup or copy by a range of completion dates

LIST COPY OF DATAFILE 2 COMPLETED BETWEEN '10-DEC-2002' AND '17-DEC-2002';

# specify logs backed up at least twice to tape

LIST ARCHIVELOG ALL BACKED UP 2 TIMES TO DEVICE TYPE sbt;

#List Incarnations of DB

LIST INCARNATION;
LIST INCARNATION OF DATABASE prod3;
LIST INCARNATION OF DATABASE;

# Reports which database files need to be backed up to meet a configured or specified retention policy

REPORT NEED BACKUP

#Reports which database files require backup because they have been affected by some NOLOGGING operation such as a direct-path INSERT

REPORT UNRECOVERABLE

#Full backups, datafile copies, and archived redo logs recorded in the RMAN repository that can be deleted because they are no longer needed.

REPORT OBSOLETE

#The names of all datafiles (permanent and temporary) and tablespaces for the target database at the specified point in time

REPORT SCHEMA

#Displays objects requiring backup to satisfy a recovery window-based retention policy.

REPORT NEED BACKUP RECOVERY WINDOW OF n DAYS

#Displays objects requiring backup to satisfy a redundancy-based retention policy.

REPORT NEED BACKUP REDUNDANCY n

#Displays files that require more than n days' worth of archived redo log files for recovery.

REPORT NEED BACKUP DAYS n

#Displays files that require application of more than n incremental backups for recovery.

REPORT NEED BACKUP INCREMENTAL n
REPORT NEED BACKUP RECOVERY WINDOW OF 2 DAYS DATABASE SKIP TABLESPACE TBS_2;
REPORT NEED BACKUP REDUNDANCY 2 DATAFILE 1;
REPORT NEED BACKUP TABLESPACE TBS_3; # uses configured retention policy
REPORT NEED BACKUP INCREMENTAL 2; # checks entire database

REPORT NEED BACKUP RECOVERY WINDOW OF 2 DAYS DATABASE DEVICE TYPE sbt;
REPORT NEED BACKUP DEVICE TYPE DISK;
REPORT NEED BACKUP TABLESPACE TBS_3 DEVICE TYPE sbt;

REPORT UNRECOVERABLE;