Rman List Commands

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

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 <file#>;
For example:

RMAN> LIST BACKUP OF DATAFILE 4;
Alternatively specify the datafile name. For example:

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;
Archive Logs
To list all archive logs use:

RMAN> LIST ARCHIVELOG ALL;
Backup sets
To list the contents of an individual backup set use:

RMAN> LIST BACKUPSET <key>;
For example:

RMAN> LIST BACKUPSET 44;
Datafile Image Copies
To list all datafile image copies use:

RMAN> LIST DATAFILECOPY ALL;
To list an individual datafile image copy use:

RMAN> LIST DATAFILECOPY <key>;
For example:

RMAN> LIST DATAFILECOPY 26;
Alternatively specify the name of the datafile image copy file:

RMAN> LIST DATAFILECOPY '/u01/app/oracle/copy/users01.dbf';
Controlfile Image Copies
To list all controlfile copies use

RMAN> LIST COPY OF CONTROLFILE;
For example:

RMAN> LIST COPY OF CONTROLFILE;

List of Control File Copies
===========================

Key     S Completion Time Ckp SCN    Ckp Time
------- - --------------- ---------- ---------------
25      A 15-AUG-15       3324254    15-AUG-15
        Name: /u01/app/oracle/copy/cf_D-TEST_id-2066695660_23qekadv
        Tag: TAG20150815T001910

20      A 14-AUG-15       3322965    14-AUG-15
        Name: /u01/app/oracle/copy/cf_D-TEST_id-2066695660_1tqek8bd
        Tag: TAG20150814T234341

15      A 14-AUG-15       3322589    14-AUG-15
        Name: /u01/app/oracle/copy/cf_D-TEST_id-2066695660_1nqek7j8
        Tag: TAG20150814T232907
To list an individual control file copy use:

RMAN> LIST CONTROLFILECOPY <key>;
For example:

RMAN> LIST CONTROLFILECOPY 20;

List of Control File Copies
===========================

Key     S Completion Time Ckp SCN    Ckp Time
------- - --------------- ---------- ---------------
20      A 14-AUG-15       3322965    14-AUG-15
        Name: /u01/app/oracle/copy/cf_D-TEST_id-2066695660_1tqek8bd
        Tag: TAG20150814T234341
Tablespaces
To list backups of a tablespace use the LIST BACKUP OF TABLESPACE command. For example:

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

RMAN> LIST INCARNATION;

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       TEST     2066695660       PARENT  1          17-SEP-11
2       2       TEST     2066695660       PARENT  995548     30-NOV-11
3       3       TEST     2066695660       ORPHAN  1190860    09-FEB-12
4       4       TEST     2066695660       CURRENT 1190860    09-FEB-12