RMAN LIST Command
RMAN LIST Command

To list all existing backups use:
RMAN> LIST BACKUP;

To list all existing database backups use:
RMAN> LIST BACKUP OF DATABASE;

To list all existing backups of a specific datafile use:
RMAN> LIST BACKUP OF DATAFILE 4;

RMAN> LIST BACKUP OF DATAFILE '/u01/app/oradata/TEST/users01.dbf';

To list all existing archivelog backups use:
RMAN> LIST BACKUP OF ARCHIVELOG ALL;

To list all existing controfile backups use:
RMAN> LIST BACKUP OF CONTROLFILE;

To list all existing SPFILE backups use:
RMAN> LIST BACKUP OF SPFILE;

To list all archive logs use:
RMAN> LIST ARCHIVELOG ALL;

To list the contents of an individual backup set use:
RMAN> LIST BACKUPSET 44;

To list all datafile image copies use:
RMAN> LIST DATAFILECOPY ALL;

To list an individual datafile image copy use:
RMAN> LIST DATAFILECOPY 26;
RMAN> LIST DATAFILECOPY '/u01/app/oracle/copy/users01.dbf';

To list all controlfile copies use
RMAN> LIST COPY OF CONTROLFILE;
RMAN> LIST CONTROLFILECOPY 20;

To list backups of a tablespace use the LIST BACKUP OF TABLESPACE command. For example:
RMAN> LIST BACKUP OF TABLESPACE USERS;

The LIST INCARNATION command shows the incarnations of the database. Note that multiple incarnations may share the same database ID.
RMAN> LIST INCARNATION;