1. List command improvements

You can now choose between BY BACKUP and BY FILE output orientation.
BY BACKUP is the default as long as there is no OF option specified
in the LIST command, otherwise BY FILE is the default.

o BY BACKUP output orientation shows
   - Backup sets and the contents of each backup set (pieces and files)
   - Backup copies of any file
o BY FILE output orientation shows
   - The file name
   - Backup sets where the file appears
   - Backup copies of this file
o A SUMMARY option is available with the BY BACKUP orientation, which
   gives a one-line summary for each file or backupset
o Note that BY and SUMMARY | VERBOSE options only apply to LIST BACKUP,
   not to LIST COPY
o SUMMARY | VERBOSE only applies to BY BACKUP orientation
o Defaults: BY BACKUP, VERBOSE


2. Listing Backups

List of Backup Sets (when in verbose mode)

Column             Indicates
-----------------  ------------------------------------------
BS Key             a unique key identifying this backup set.

                  If you are connected to a recovery catalog, then BS Key
                  is the primary key of the backup set in the catalog. It
                  corresponds to BS_KEY in the RC_BACKUP_SET view. If you
                  are connected in NOCATALOG mode, then BS Key displays the
                  RECID from V$BACKUP_SET. RECID and STAMP form a concatenated
                  primary key that uniquely identifies this record in the
                  target control file.
Type              the type of backup: Full or Incr (incremental).
LV                the level of the backup: NULL for non-incrementals, level 0-4
                  for incrementals.
Size              the size of the backup in bytes.
Device Type       the type of device on which the backup was made, for example,
                  DISK or sbt.
Elapsed Time      the duration of the backup.
Completion Time   the date and time that the backup set completed. Note that the
                  format of this field depends on the NLS_LANG and NLS_DATE_FORMAT
                  environment settings.


RMAN> list backup;



RMAN> list backup by file;

List of Datafile Backups
========================

File Key     TY LV S Ckp SCN    Ckp Time  #Pieces #Copies Tag
---- ------- -  -- - ---------- --------- ------- ------- ---
1    1904    B  F  A 243580     14-APR-01 1       1      
     1860    B  F  A 243559     14-APR-01 1       1      
     1608    B  F  A 194543     02-APR-01 1       1      

4. List of Backup Sets (LIST BACKUP ... SUMMARY)

Column        Indicates
------------- -------------------------------------------------------
Key           a unique key identifying this backup set.

              If you are connected to a recovery catalog, then BS Key
              is the primary key of the backup set in the catalog. It
              corresponds to BS_KEY in the RC_BACKUP_SET view. If you
              are connected in NOCATALOG mode, then BS Key displays the
              RECID from V$BACKUP_SET. RECID and STAMP form a concatenated
              primary key that uniquely identifies this record in the target
              control file.




The following example lists a summarized version of all RMAN backups:

RMAN> list backup summary;

List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Tag
------- -- -- - ----------- --------------- ------- ------- ---
1607    B  F  A DISK        02-APR-01       1       1      
1608    B  F  A DISK        02-APR-01       1       1      

RMAN> exit

Recovery Manager complete.



5. Quick guide examples:

LIST BACKUP .. [listoptions];

listoptions: [BY <BACKUP|FILE>]
             [SUMMARY | VERBOSE]

This example lists all backups in default verbose mode:

RMAN> list backup;

This example groups all backups by file:

RMAN> list backup by file;

The following example lists a summarized version of all RMAN backups:

RMAN> list backup summary;

The following command lists image copies of all the files in the
database, skipping the temp tablespace:

RMAN> LIST COPY OF DATABASE SKIP TABLESPACE temp;

LIST BACKUP;  # lists backup sets, backup pieces, and proxy copies


Optionally, specify the EXPIRED keyword to identify those backups
that were not found during a crosscheck:

     LIST EXPIRED BACKUP;

To generate a list of copies and backups restricted by object or other conditions:

  1. After connecting to the target database and recovery catalog (if you use one),
     execute LIST COPY or LIST BACKUP with the listObjList or recordSpec condition.
     For example, enter:

     # lists backups of all files in database
     LIST BACKUP OF DATABASE;

     # lists copy of specified datafile   
     LIST COPY OF DATAFILE '/oracle/dbs/tbs_1.f';

     # lists specified backup set
     LIST BACKUPSET 213;

     # lists datafile copy
     LIST DATAFILECOPY '/df1.f';


  2. You can also restrict the search by specifying the maintQualifier or
     RECOVERABLE clause. For example, enter:

     # specify a backup by tag
     LIST BACKUP TAG 'weekly_full_db_backup';

     # specify a backup or copy by device type
     LIST COPY OF DATAFILE '/oracle/dbs/tbs_1.f' type sbt;

     # specify a backup or copy by directory or path
     LIST BACKUP LIKE '/oracle/backup/%';

     # specify a backup or copy by a range of completion dates
     LIST COPY OF DATAFILE 2 COMPLETED BETWEEN '10-DEC-2000' AND '17-DEC-2000';