RMAN list command usage

 The LIST command allows the backup data to be listed in the RMAN utility

Database

To list all existing backups use:

LIST BACKUP;

To list all existing database backups use:

LIST BACKUP OF DATABASE;

To list all existing backups of a specific datafile use:

LIST BACKUP OF DATAFILE <file#>;</file#>

For example:

LIST BACKUP OF DATAFILE 1;

Alternatively specify the datafile name. For example:

LIST BACKUP OF DATAFILE ;

To list all existing archivelogbackups use:

LIST BACKUP OF ARCHIVELOG ALL;

To list all existing controfilebackups use:

LIST BACKUP OF CONTROLFILE;

To list all existing SPFILE backups use:

LIST BACKUP OF SPFILE;

To list all archive logs use:

LIST ARCHIVELOG ALL;

To list all Backupsets or any individual backupset:

LIST BACKUPSET ;

For example:

LIST BACKUPSET 2001;

to list all or any Datafile Image Copies:

LIST DATAFILECOPY ALL;

To list an individual datafile image copy use:

LIST DATAFILECOPY ;

example command for the system tablespace file

LIST DATAFILECOPY 1;

LIST DATAFILECOPY '';

To list all controlfile copies:

LIST COPY OF CONTROLFILE;

To list an individual control file copy use:

LIST CONTROLFILECOPY ;
To list backups of a tablespace use the LIST BACKUP OF TABLESPACE command.

LIST BACKUP OF TABLESPACE ;