Oracle in a Nutshell

Name

LIST

Synopsis

Oracle9i syntax:

LIST 
   { INCARNATION [OF DATABASE [[']database_name[']]] 
   | [EXPIRED]
     { listObjectSpec 
       [ mntQualifer | RECOVERABLE [until] ] 
       [ mntQualifer | RECOVERABLE [until] ]... 
     | recordSpec
     }
   };

listObjectSpec :=
{ BACKUP [OF listObjList] [listBackupOption]
| COPY [OF listObjList]
}

listBackupOption :=
[ [BY BACKUP] [VERBOSE]
| SUMMARY
| BY { BACKUP SUMMARY | FILE }
]

Oracle8i syntax:

LIST 
   { INCARNATION [OF DATABASE [ [']database_name['] ] ] 
   | { BACKUP | COPY } [OF listObjList]
     [ listOptions [listOptions ...] ]
   };

listOptions :=
{ { TAG [=] [']tag_name[']
  | completedTimeSpec }
| RECOVERABLE [ until ]
| DEVICE TYPE deviceSpecifier [, deviceSpecifier ...]
| LIKE 'string_pattern' }

Produces a list of backups or image copies.

Keywords

EXPIRED

Lists backup sets that have been marked as EXPIRED in the control files of the target database of the recovery catalog.

BY BACKUP

Lists backup sets and their contents.

VERBOSE

Lists detailed backup set information.

SUMMARY

Lists a one-line summary for backup sets or files and summary information for backup sets or files.

Common keywords and clauses: completedTimeSpec, deviceSpecifier listObjList, mntQualifier, recordSpec, tag_name, until.