Skip to content

RMAN LIST Command

    RMAN LIST Command uses the information in the RMAN repository to provide lists of backups and other objects.

    Listing Backups

    This RMAN LIST Command example lists all backups. The output shows two backup sets on disk: one containing data files and the other containing autobackups. The output also shows one SBT backup containing archived redo log files.

    RMAN> LIST BACKUP;
    CopyList of Backup Sets
    ===================
     
    BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    200     Full    509.78M    DISK        00:01:03     15-FEB-13
            BP Key: 202   Status: AVAILABLE  Compressed: NO  Tag: TAG20130215T171219
            Piece Name: /disk2/PROD/backupset/2013_02_15/o1_mf_nnndf_TAG20130215T171219_2xb17nbb_.bkp
      List of Datafiles in backup set 200
      File LV Type Ckp SCN    Ckp Time  Name
      ---- -- ---- ---------- --------- ----
      1       Full 421946     15-FEB-13 /disk1/oradata/prod/system01.dbf
      2       Full 421946     15-FEB-13 /disk1/oradata/prod/sysaux01.dbf
      3       Full 421946     15-FEB-13 /disk1/oradata/prod/undotbs01.dbf
      4       Full 421946     15-FEB-13 /disk1/oradata/prod/cwmlite01.dbf
      5       Full 421946     15-FEB-13 /disk1/oradata/prod/drsys01.dbf
      6       Full 421946     15-FEB-13 /disk1/oradata/prod/example01.dbf
      7       Full 421946     15-FEB-13 /disk1/oradata/prod/indx01.dbf
      8       Full 421946     15-FEB-13 /disk1/oradata/prod/tools01.dbf
      9       Full 421946     15-FEB-13 /disk1/oradata/prod/users01.dbf
     
    BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    201     Full    7.98M      DISK        00:00:03     15-FEB-13
            BP Key: 203   Status: AVAILABLE  Compressed: NO  Tag: TAG20130215T171219
            Piece Name: /disk2/PROD/backupset/2013_02_15/o1_mf_ncsnf_TAG20130215T171219_2xb19prg_.bkp
      SPFILE Included: Modification time: 15-FEB-13
      SPFILE db_unique_name: PROD
      Control File Included: Ckp SCN: 421968       Ckp time: 15-FEB-13
     
    BS Key  Size       Device Type Elapsed Time Completion Time
    ------- ---------- ----------- ------------ ---------------
    227     30.50M     SBT_TAPE    00:00:11     15-FEB-13
            BP Key: 230   Status: AVAILABLE  Compressed: NO  Tag: TAG20130215T171334
            Handle: 0bia4rtv_1_1   Media:
     
      List of Archived Logs in backup set 227
      Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
      ---- ------- ---------- --------- ---------- ---------
      1    5       389156     15-FEB-13 411006     15-FEB-13
      1    6       411006     15-FEB-13 412972     15-FEB-13
      1    7       412972     15-FEB-13 417086     15-FEB-13
      1    8       417086     15-FEB-13 417114     15-FEB-13
      1    9       417114     15-FEB-13 417853     15-FEB-13
      1    10      417853     15-FEB-13 421698     15-FEB-13
      1    11      421698     15-FEB-13 421988     15-FEB-13

    Listing a Summary of Backups

    RMAN> LIST BACKUP SUMMARY;
     
    List of Backups
    ===============
    Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
    ------- -- -- - ----------- --------------- ------- ------- ---------- ---
    200     B  F  A DISK        15-FEB-13       1       1       NO         TAG20130215T171219
    201     B  F  A DISK        15-FEB-13       1       1       NO         TAG20130215T171219
    227     B  A  A SBT_TAPE    15-FEB-13       1       1       NO         TAG20130215T171334

    Listing Backups by File

    This example groups all backups by file. The tag column of the data file backup indicates that one backup set contains backup pieces with different tags. The status column of the archived log backup indicates that the backup set is unavailable.

    RMAN> LIST BACKUP BY FILE;
    
    List of Datafile Backups
    ========================
     
    File Key     TY LV S Ckp SCN    Ckp Time  #Pieces #Copies Compressed Tag
    ---- ------- -  -- - ---------- --------- ------- ------- ---------- ---
    1    329     B  F  A 454959     16-FEB-13 1       1       NO         DF1
    2    349     B  F  A 454997     16-FEB-13 1       1       NO         DF2
    3    527     B  F  A 455218     16-FEB-13 1       1       NO         FRI_BKP
         368     B  F  A 455022     16-FEB-13 1       1       NO         DF3
    4    387     B  F  X 455042     16-FEB-13 1       1       NO         DF4
    5    407     B  F  A 455063     16-FEB-13 1       1       NO         DF5
    6    428     B  F  A 455083     16-FEB-13 1       2       NO         *
    7    450     B  F  X 455103     16-FEB-13 1       1       NO         DF7
    8    473     B  F  A 455123     16-FEB-13 1       1       NO         DF8
    9    497     B  F  A 455143     16-FEB-13 1       1       NO         DF9
     
    List of Archived Log Backups
    ============================
     
    Thrd Seq     Low SCN    Low Time  BS Key  S #Pieces #Copies Compressed Tag
    ---- ------- ---------- --------- ------- - ------- ------- ---------- ---
    1    5       389156     15-FEB-13 227     U 1       1       NO         TAG20130215T171334
    1    6       411006     15-FEB-13 227     U 1       1       NO         TAG20130215T171334
    1    7       412972     15-FEB-13 227     U 1       1       NO         TAG20130215T171334
    1    8       417086     15-FEB-13 227     U 1       1       NO         TAG20130215T171334
    1    9       417114     15-FEB-13 227     U 1       1       NO         TAG20130215T171334
    1    10      417853     15-FEB-13 227     U 1       1       NO         TAG20130215T171334
    1    11      421698     15-FEB-13 227     U 1       1       NO         TAG20130215T171334
     
    List of Control File Backups
    ============================
     
    CF Ckp SCN Ckp Time  BS Key  S #Pieces #Copies Compressed Tag
    ---------- --------- ------- - ------- ------- ---------- ---
    454974     16-FEB-13 330     A 1       1       NO         DF1
    421968     15-FEB-13 201     A 1       1       NO         TAG20130215T171219
    List of SPFILE Backups
    ======================
     
    Modification Time BS Key  S #Pieces #Copies Compressed Tag
    ----------------- ------- - ------- ------- ---------- ---
    15-FEB-13         330     A 1       1       NO         DF1
    15-FEB-13         201     A 1       1       NO         TAG20130215T171219

    Listing Image Copies

    The following example lists all data file, control file, and archived redo log copies known to RMAN:

    RMAN> LIST COPY;
    
    List of Datafile Copies
    =======================
     
    Key     File S Completion Time Ckp SCN    Ckp Time
    ------- ---- - --------------- ---------- ---------------
    618     1    A 16-FEB-13       461057     16-FEB-13
            Name: /disk2/PROD/datafile/o1_mf_system_2xdbrg13_.dbf
            Tag: TAG20130216T140706
     
    631     2    A 16-FEB-13       461163     16-FEB-13
            Name: /disk2/PROD/datafile/o1_mf_sysaux_2xdbzybx_.dbf
            Tag: TAG20130216T141109
     
    List of Control File Copies
    ===========================
     
    Key     S Completion Time Ckp SCN    Ckp Time
    ------- - --------------- ---------- ---------------
    619     A 16-FEB-13       461133     16-FEB-13
            Name: /disk2/PROD/controlfile/o1_mf_TAG20130216T140706_2xdbz5tb_.ctl
            Tag: TAG20130216T140706
     
    594     A 16-FEB-13       460650     16-FEB-13
            Name: /disk2/PROD/controlfile/o1_mf_TAG20130216T135954_2xdbbz99_.ctl
            Tag: TAG20130216T135954
     
    List of Archived Log Copies for database with db_unique_name PROD
    =====================================================================
     
    Key     Thrd Seq     S Low Time
    ------- ---- ------- - ---------
    105     1    5       A 15-FEB-13
            Name: /disk1/oradata/prod/arch/archive1_5_614616887.dbf
     
    122     1    6       A 15-FEB-13
            Name: /disk1/oradata/prod/arch/archive1_6_614616887.dbf
     
    123     1    7       A 15-FEB-13
            Name: /disk1/oradata/prod/arch/archive1_7_614616887.dbf
     
    124     1    8       A 15-FEB-13
            Name: /disk1/oradata/prod/arch/archive1_8_614616887.dbf
     
    125     1    9       A 15-FEB-13
            Name: /disk1/oradata/prod/arch/archive1_9_614616887.dbf
     
    185     1    10      A 15-FEB-13
            Name: /disk1/oradata/prod/arch/archive1_10_614616887.dbf
     
    221     1    11      A 15-FEB-13
            Name: /disk1/oradata/prod/arch/archive1_11_614616887.dbf
     
    262     1    12      A 15-FEB-13
            Name: /disk1/oradata/prod/arch/archive1_12_614616887.dbf
     
    263     1    13      A 15-FEB-13
            Name: /disk1/oradata/prod/arch/archive1_13_614616887.dbf

    Listing Database Incarnations

    This example lists all database incarnations recorded in the recovery catalog.

    RMAN> LIST INCARNATION;
    
    List of Database Incarnations
    DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
    ------- ------- -------- ---------------- --- ---------- ----------
    78      94      PROD     1619073740       PARENT  1          14-FEB-13
    78      79      PROD     1619073740       CURRENT 388003     15-FEB-13

    Listing Failures

    This example lists all failures regardless of their priority. If you do not specify ALL, then LIST FAILURE output does not include failures with LOW priority.

    RMAN> LIST FAILURE ALL;
     
    List of Database Failures
    =========================
     
    Failure ID Priority Status    Time Detected Summary
    ---------- -------- --------- ------------- -------
    142        HIGH     OPEN      23-APR-13     One or more non-system datafiles are missing
    101        HIGH     OPEN      23-APR-13     Datafile 1: '/disk1/oradata/prod/system01.dbf'
                                                contains one or more corrupt blocks

    Also See:

    Oracle RMAN

    LIST command