RMAN LIST Command
RMAN LIST Command

to set the date format run the following before executing rman
Windows: set NLS_DATE_FORMAT=yyyy-mm-dd hh24:mi:ss
linux: export NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'

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;