Displaying Backups Stored in the RMAN Repository

Use the LIST command to view information about backups stored in the Oracle Recovery Manager (RMAN) repository. The information includes backups of data files, individual tablespaces, archived redo log files, and control files. You can also use this command to display information about expired and obsolete backups.

See Also:

Oracle Database Backup and Recovery User's Guide for more information about the LIST command

The syntax used to display backups of multitenant container databases (CDBs) and pluggable databases (PDBs), which has minor variations from that used for non-CDBs, is described in Oracle Database Backup and Recovery User's Guide.

To display all backups:

  1. Connect RMAN to the target database as described in "Connecting to the Target Database Using RMAN."

  2. Use the LIST command to display a summary of all the backups, both backup sets and image copies.

    LIST BACKUP SUMMARY;

List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
12      B  F  A DISK        28-MAR-12       1       1       NO         TAG20120328T051810
13      B  F  A DISK        28-MAR-12       1       1       NO         TAG20120328T051811
14      B  F  A DISK        28-MAR-12       1       1       NO         TAG20120328T051921
15      B  F  A DISK        28-MAR-12       1       1       NO         TAG20120328T051936
16      B  F  A DISK        28-MAR-12       1       1       NO         TAG20120328T052241

To display selected backups:

  1. Connect RMAN to the target database as described in "Connecting to the Target Database Using RMAN."
  2. Use the LIST BACKUP or LIST COPY command to display the specified backups, both backup sets and image copies.

    • For example, to list the backups of a particular datafile:

      LIST BACKUP OF DATAFILE 3;
LIST COPY OF DATAFILE '/orcl/oradata/trgt/system01.dbf';

    • To display backups sorted by the type of database file:

      LIST BACKUP BY FILE;

List of Datafile Backups
========================
File Key     TY LV S Ckp SCN    Ckp Time  #Pieces #Copies Compressed Tag
---- ------- -  -- - ---------- --------- ------- ------- ---------- ---
1    14      B  F  A 723546     28-MAR-12 1       1       NO         TAG20120328T051921
2    14      B  F  A 723546     28-MAR-12 1       1       NO         TAG20120328T051921
3    14      B  F  A 723546     28-MAR-12 1       1       NO         TAG20120328T051921
4    14      B  F  A 723546     28-MAR-12 1       1       NO         TAG20120328T051921
5    14      B  F  A 723546     28-MAR-12 1       1       NO         TAG20120328T051921

List of Control File Backups
===========================
CF Ckp SCN Ckp Time  BS Key  S #Pieces #Copies Compressed Tag
---------- --------- ------- - ------- ------- ---------- ---
723835     28-MAR-12 16      A 1       1       NO         TAG20120328T052241
723557     28-MAR-12 15      A 1       1       NO         TAG20120328T051936
723490     28-MAR-12 13      A 1       1       NO         TAG20120328T051811