LIST

2.27 LIST

Purpose

Use the LIST command to display backups and information about other objects recorded in the RMAN repository.

See Also:

Oracle Database Backup and Recovery User's Guide to learn how to make lists and reports, and REPORT

Additional Topics

Prerequisites

Execute LIST only at the RMAN prompt. Either of the following conditions must be met:

RMAN must be connected to a target database. If RMAN is not connected to a recovery catalog, and if you are not executing the LIST FAILURE command, then the target database must be mounted or open. If RMAN is connected to a recovery catalog, then the target database instance must be started.
RMAN must be connected to a recovery catalog and SET DBID must have been run.

To list preplugin backups, you must connect to the root as a common user with the SYSDBA or SYSBACKUP privilege.

Usage Notes

Except for LIST FAILURE, the LIST command displays the backups and copies against which you can run CROSSCHECK and DELETE commands. The LIST FAILURE command displays failures against which you can run the ADVISE FAILURE and REPAIR FAILURE commands.

"RMAN Backups in a Data Guard Environment" explains how RMAN handles backups in a Data Guard environment. In general, RMAN considers tape backups created on one database in the environment as accessible to all databases in the environment, whereas disk backups are accessible only to the database that created them. In a Data Guard environment, LIST displays those files that are accessible to the connected target database.

RMAN prints the LIST output to either standard output or the message log, but not to both at the same time.

Syntax

list::=

Description of the illustration list.eps

(listObjectSpec::=, recordSpec::=, maintQualifier::=, forDbUniqueNameOption::=, untilClause::=)

maintQualifier::=

Description of the illustration maintqualifier.eps

(completedTimeSpec::=, deviceSpecifier::=)

listObjectSpec::=

Description of the illustration listobjectspec.eps

(listObjList::=, listBackupOption::=, archivelogRecordSpecifier::=, foreignlogRecordSpecifier::=)

recoverableClause::=

Description of the illustration recoverableclause.eps

(untilClause::=)

listBackupOption::=

Description of the illustration listbackupoption.eps

Semantics

list

Syntax Element	Description
`DB_UNIQUE_NAME`	Lists the `DB_UNIQUE_NAME` of one or more databases registered in the recovery catalog. RMAN must be connected to a recovery catalog. RMAN must also be connected to a mounted or open target database, or you must identify the target database with the `SET` `DBID` command. The DBID for a primary database is identical to the DBID of its associated standby databases: they are distinguished by `DB_UNIQUE_NAME`. See Also: Table 2-28 for a description of the output
`ALL`	Lists the `DB_UNIQUE_NAME` of every database registered in the RMAN repository.
`OF DATABASE` `database_name`	Lists the `DB_UNIQUE_NAME` of every database with the specified `DB_NAME`.
`EXPIRED`	Displays backup sets, proxy copies, and image copies marked in the repository as `EXPIRED`, which means they were not found. See Table 2-9 for a description of the output. To ensure that `LIST EXPIRED` shows up-to-date output, use a `CROSSCHECK` command periodically. When you use a `CROSSCHECK` command, RMAN searches disk and tape for backups and copies recorded in the repository. If it does not find them, then it updates their repository records to status `EXPIRED`.
`PREPLUGIN`	Lists preplugin backups.
`listObjectSpec`	Specifies the type of expired object or objects that you are listing. See Also: `listObjectSpec`
`maintQualifier`	Restricts the range of the listing. See Also: `maintQualifier` To display backups of PDBs that were dropped, use the `GUID` option with the `LIST` command and specify the GUID of the dropped PDB. Query the `dba_pdb_history` view to determine the GUID, of dropped PDBs.
`recordSpec`	Specifies the expired object or objects that you are listing. See Also: `recordSpec`
`forDbUniqueNameOption`	Lists the expired files in `listObjectSpec` or `recordSpec` that are exclusively associated with the specified `DB_UNIQUE_NAME` in a Data Guard environment. You can specify a database with `db_unique_name` or use `ALL` for all uniquely named databases recorded in the catalog for a particular DBID. A database is uniquely identified in the recovery catalog by a DBID and the value of the `DB_UNIQUE_NAME` initialization parameter. RMAN must be connected to a recovery catalog. RMAN must also be connected to a mounted or open target database, or you must have run the `SET` `DBID` command. See Also: `forDbUniqueNameOption` for descriptions of the options in this clause
`FAILURE`	Lists failures recorded by the Data Recovery Advisor. The database to which RMAN is connected must be a single-instance database and must not be a physical standby database. See Also: "Oracle RAC and Data Recovery Advisor" The Data Recovery Advisor can detect and repair a wide variety of physical problems that cause data loss and corruption. Physical corruptions are typically caused by faulty I/O subsystems or human error. The Data Recovery Advisor may not detect or handle some types of logical corruptions. Corruptions of this type require help from Oracle Support Services. For Data Recovery Advisor, a failure is a persistent data corruption that is mapped to a set of repair actions. Data failures are detected by checks, which are diagnostic procedures that assess the health of the database or its components. Each check can diagnose one or more failures, which are mapped to a set of repairs. The typical use case is to run `LIST FAILURE` to list any failures, then use `ADVISE FAILURE` to display repair options, and `REPAIR FAILURE` to fix the failures. Run these commands in the same RMAN session. If no options are specified on `LIST FAILURE`, then the command lists only the highest priority failures that have status `OPEN`. Therefore, `CRITICAL` and `HIGH` failures are always listed in the command output if they exist. Failures with `LOW` priority are listed only if no `CRITICAL` or `HIGH` priority failures exist. Failures are sorted in reverse order of occurrence, with the most recent failure listed first. The `LIST FAILURE` command does not initiate checks to diagnose new failures; rather, it lists the results of previously executed assessments. Thus, repeatedly executing `LIST FAILURE` reveals new failures only if the database automatically diagnosed them in response to errors that occurred in between command executions. However, `LIST FAILURE` revalidates all existing failures when the command is issued. If a user fixed failures manually, or if the failures were transient problems that disappeared, then Data Recovery Advisor removes these failures from the `LIST FAILURE` output. See Also: Table 2-27 for an explanation of the column headings of the `LIST` `FAILURE` output table and Example 2-113 for an illustration
`ALL`	Lists failures with all priorities and status `OPEN`.
`CRITICAL`	Lists only critical failures with status `OPEN`.
`HIGH`	Lists only failures with `HIGH` priority and status `OPEN`.
`LOW`	Lists only failures with `LOW` priority with status `OPEN`.
`UNKNOWN`	Lists only failures whose priority cannot be determined until the database is mounted.
`failureNumber`	Specifies the failures by failure number.
`CLOSED`	Lists only closed failures.
`EXCLUDE FAILURE` `failureNumber`	Excludes the specified failures from the list.
`DETAIL`	Lists failures by expanding the consolidated failure. For example, if multiple block corruptions existed in a file, then specifying the `DETAIL` option would list each of the block corruptions.
`INCARNATION`	Displays information about the incarnations of a database. Whenever you open a database with the `RESETLOGS` option, you create a new incarnation of the database. If `LIST INCARNATION` displays `n` incarnations of a database, then you have reset the online redo logs for this database `n`-1 times. The `LIST` output includes the primary keys of all database incarnation records for the specified database name (in the column `Inc Key`, which contains the incarnation key). Use the key in a `RESET DATABASE` command to change the incarnation that RMAN considers to be current to a previous incarnation. See Also: Table 2-24 for an explanation of the column headings of the `LIST` `INCARNATION` output table and Example 2-112 for an illustration
`OF DATABASE` `database_name`	Specifies the name of the database. If you do not specify the `OF DATABASE` option, then `LIST` displays all databases registered in the recovery catalog.
`listObjectSpec`	Specifies the type of expired object or objects that you are listing. See Also: `listObjectSpec`
`maintQualifier`	Restricts the range of the listing. See Also: `maintQualifier`
`recoverableClause`	Restricts the list to data file backups or copies whose status in the repository is `AVAILABLE` and which can be used for restore and recovery in the current incarnation of the target database. See Also: `recoverableClause`
`recordSpec`	Specifies the object or objects that you are listing. See Also: `recordSpec`
`untilClause`	Specifies an end time, SCN, or log sequence number. See Also: `untilClause`
`RESTORE POINT`	Displays restore points known to the RMAN repository. See Also: Table 2-26 for an explanation of the column headings of the `LIST` `RESTORE POINT` output table
`restore_point_name`	Displays the specified restore point.
`ALL`	Displays all restore points known to the RMAN repository.
`forDbUniqueNameOption`	Lists the backups and restore points that are exclusively associated with the specified `DB_UNIQUE_NAME` in a Data Guard environment. You can specify a database with `db_unique_name` or use `ALL` for all uniquely named databases recorded in the catalog for a particular DBID. A database is uniquely identified in the recovery catalog by a DBID and the value of the `DB_UNIQUE_NAME` initialization parameter. RMAN must be connected to a recovery catalog. RMAN must also be connected to a mounted or open target database. See Also: `forDbUniqueNameOption` for descriptions of the options in this clause
`ALL SCRIPT NAMES`	RMAN lists all global and local scripts defined for all databases in the connected recovery catalog, along with any descriptive comments. You must be connected to a recovery catalog, but you do not need to be connected to a target database.
`GLOBAL SCRIPT NAMES`	RMAN lists only global scripts defined in the connected recovery catalog, along with any descriptive comments. You must be connected to a recovery catalog, but you do not need to be connected to a target database.
`SCRIPT NAMES`	Lists local and global scripts that can be executed on the current target database. You must be connected to a target database and a recovery catalog to use this form of the command. See Also: Table 2-25 for a description of the output and Example 3-19 for an illustration

listObjectSpec

This subclause specifies the type of object or objects that you are listing.

Syntax Element	Description
`BACKUP`	Displays information about backup sets (including detail on backup pieces) and proxy copies. See Also: Table 2-9 for a description of `LIST BACKUP` output and Example 2-108 for an illustration
`OF` `listObjList`	Restricts the list of objects operated on to the object type specified in the `listObjList` clause. If you do not specify an object, then `LIST` defaults to `OF DATABASE CONTROLFILE ARCHIVELOG ALL`. Note: The `LIST BACKUP ... LIKE` command is not valid. The only valid exception is `LIST BACKUP OF ARCHIVELOG LIKE`. See Also: `listObjList`
`listBackupOption`	Specifies whether to list summary information about backups or detailed information.
`archivelogRecordSpecifier`	Displays information about a range of archived redo log files.
`COPY`	Displays only information about data file copies, archived redo log files, and image copies of archived redo log files. By default, `LIST COPY` displays copies of all database files and archived redo log files. Both usable and unusable image copies are included in the output, even those that cannot be restored or are expired or unavailable. See Also: Table 2-21 and Table 2-23 for an explanation of the column headings of the `LIST COPY` output tables
`OF` `listObjList`	Restricts the list of objects operated on to the object type specified in the `listObjList` clause. See Also: `listObjList`
`foreignlogRecordSpecifier`	Displays information about a range of foreign archived redo log files.

recoverableClause

This subclause specifies recoverable backups.

Syntax Element Description

Syntax Element	Description
`RECOVERABLE`	Restricts the list to expired data file backups or copies whose status in the repository is `AVAILABLE` and which can be used for restore and recovery in the current incarnation of the target database. This list includes all backups and copies except the incremental backups that have no valid parent to which the incremental can be applied.
`TO RESTORE POINT` `restore_point_name`	Specifies a restore point, with the SCN at which the restore point was created as the upper, inclusive limit. Because the limit is inclusive, RMAN only lists files that are recoverable up to and including the SCN corresponding to the restore point.
`untilClause`	Specifies an end time, SCN, or log sequence number. See Also: `untilClause`

RECOVERABLE

Restricts the list to expired data file backups or copies whose status in the repository is AVAILABLE and which can be used for restore and recovery in the current incarnation of the target database. This list includes all backups and copies except the incremental backups that have no valid parent to which the incremental can be applied.

TO RESTORE POINT restore_point_name

Specifies a restore point, with the SCN at which the restore point was created as the upper, inclusive limit. Because the limit is inclusive, RMAN only lists files that are recoverable up to and including the SCN corresponding to the restore point.

untilClause

Specifies an end time, SCN, or log sequence number.

See Also: untilClause

listBackupOption

Specifies whether to summarize backups or list the backups for a particular data file.

Syntax Element Description

Syntax Element	Description
`BY FILE`	Lists backups of each data file, archived redo log file, control file, and server parameter file. See Also: Table 2-18, Table 2-19, and Table 2-20 for a description of `LIST BACKUP ... BY FILE` output
`SUMMARY`	Gives a one-line summary for each backup. See Also: Table 2-16 for a description of `LIST BACKUP ... SUMMARY` output and Example 2-109 for sample output

BY FILE

Lists backups of each data file, archived redo log file, control file, and server parameter file.

See Also: Table 2-18, Table 2-19, and Table 2-20 for a description of LIST BACKUP ... BY FILE output

SUMMARY

Gives a one-line summary for each backup.

See Also: Table 2-16 for a description of LIST BACKUP ... SUMMARY output and Example 2-109 for sample output

LIST Command Output

The information that appears in the output is described in the following tables:

Table 2-9 List of Backup Sets (for data file backup sets)

Column	Indicates
`BS Key`	A unique key identifying this backup set. If RMAN is 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 RMAN is connected in the default `NOCATALOG` mode, then `BS` `Key` displays the `RECID` from `V$BACKUP_SET`.
`Type`	The type of backup: `Full` or `Incr` (incremental). Note: Column only included in data file backup sets.
`LV`	The level of the backup: `NULL` for nonincrementals, level `0` or level 1 for incrementals. Note: Column only included in data file backup sets.
`Size`	The size of the backup in bytes. Note: Column only included in data file backup sets.
`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. The format of this field depends on the `NLS_LANG` and `NLS_DATE_FORMAT` environment settings.
`List of data files in backup set ...`	See Table 2-11

Table 2-10 List of Backup Pieces (for sets with only one piece)

Column	Indicates
`BP Key`	A unique identifier for this backup piece in the recovery catalog or target database control file. If RMAN is connected to a recovery catalog, then `BP` `Key` is the primary key of the backup piece in the catalog. It corresponds to `BP_KEY` in the `RC_BACKUP_PIECE` view. If RMAN is connected in `NOCATALOG` mode, then `BP` `Key` displays the `RECID` from `V$BACKUP_PIECE`. Note: The values for `KEY` in the recovery catalog and the control file are different.
`Status`	The backup piece status: `AVAILABLE`, `UNAVAILABLE`, or `EXPIRED` (refer to the `CHANGE`, `CROSSCHECK`, and `DELETE` commands for an explanation of each status).
`Compressed`	Whether the backup piece is compressed (`YES` or `NO`).
`Tag`	The tag applied to the backup set. Tag names are not case sensitive and appear in all uppercase.
`Piece Name/Handle`	The file name or handle of the backup piece. If the backup piece is on SBT, then the Media ID is displayed with the name.
`SPFILE Included`	A server parameter file is included in the backup.
`Control File Included`	A control file is included in the backup. Note: This row appears only if the current control file is included in the backup.
`Ckp SCN`	The SCN of the backup control file checkpoint. All database changes recorded in the redo records before the specified SCN are reflected in this control file. Note: This row appears only if the current control file is included in the backup.
`Ckp time`	The time of the backup control file checkpoint. All database changes recorded in the redo records before the specified time are reflected in this control file. Note: This row appears only if the current control file is included in the backup.

Table 2-11 List of Data Files in backup set ...

Column	Indicates
`File`	The number of the file that was backed up.
`LV`	The level of the backup: `NULL` for nonincrementals, level 0 or 1 for incrementals.
`Type`	The type of backup: `Full` or `Incr` (incremental).
`Ckp SCN`	The checkpoint of the data file at the time it was backed up. All database changes before the SCN were written to the file; changes after the specified SCN were not written to the file.
`Ckp Time`	The checkpoint of the data file at the time it was backed up. All database changes before the time were written to the file; changes after the specified time were not written to the file.
`Name`	The location where this file would be restored now if it were restored from this backup set and no `SET` `NEWNAME` command was entered. See Also: `SET`

Table 2-12 List of Archived Logs in backup set ...

Column	Indicates
`Thrd`	The thread number of the redo log.
`Seq`	The log sequence number of the archived log.
`Low SCN`	The lowest SCN in the archived log.
`Low Time`	The time when the database switched into the redo log having this sequence number.
`Next SCN`	The low SCN of the next archived log sequence.
`Next Time`	The low time of the next archived log sequence.

Table 2-13 Backup Set Copy ... of backup set ... (only if multiple pieces)

Column	Indicates
`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. The format of this field depends on the `NLS_LANG` and `NLS_DATE_FORMAT` environment settings.
`Tag`	The tag applied to the backup set. Tag names are not case sensitive and appear in all uppercase.

Table 2-14 List of Backup Pieces for backup set ... Copy ... (if multiple pieces)

Column	Indicates
`BP Key`	A unique identifier for this backup piece in the recovery catalog or target database control file. If RMAN is connected to a recovery catalog, then `BP Key` is the primary key of the backup piece in the catalog. It corresponds to `BP_KEY` in the `RC_BACKUP_PIECE` view. If RMAN is connected in `NOCATALOG` mode, then `BP Key` displays the `RECID` from `V$BACKUP_PIECE`. Note: The values for `KEY` in the recovery catalog and the control file are different.
`Pc#`	The number of the backup piece in the backup set.
`Status`	The backup piece status: `AVAILABLE`, `UNAVAILABLE`, or `EXPIRED` (refer to the `CHANGE`, `CROSSCHECK`, and `DELETE` commands for an explanation of each status).
`Piece Name`	The file name or handle of the backup piece. If the backup piece is stored on SBT, then the media ID is also displayed.

Table 2-15 List of Proxy Copies

Column	Indicates
`PC Key`	A unique key identifying this proxy copy. If RMAN is connected to a catalog, then `PC` `Key` is the primary key of the proxy copy in the catalog. It corresponds to `XDF_KEY` in the `RC_PROXY_DATAFILE` view or `XCF_KEY` in the `RC_PROXY_CONTROLFILE` view. If RMAN is connected in `NOCATALOG` mode, then `PC` `Key` displays the `RECID` from `V$PROXY_DATAFILE`.
`File`	The absolute data file number of the file that was copied.
`Status`	The proxy copy status: `AVAILABLE`, `UNAVAILABLE`, or `EXPIRED` (refer to the `CHANGE`, `CROSSCHECK`, and `DELETE` commands for an explanation of each status).
`Completion Time`	The date and time that the backup set completed. The format of this field depends on the `NLS_LANG` and `NLS_DATE_FORMAT` environment settings.
`Ckp SCN`	The SCN of the proxy copy control file checkpoint. All database changes recorded in the redo records before the specified SCN are reflected in this control file.
`Ckp time`	The time of the proxy copy control file checkpoint. All database changes recorded in the redo records before the specified time are reflected in this control file.
`Datafile name`	The location where this file would be restored now if it were restored from this backup set and no `SET NEWNAME` command was entered. See Also: `SET` command
`Handle`	The media manager's handle for the proxy copy. If the object is on sbt, then the media ID is also displayed.
`Tag`	The tag applied to the proxy copy. Tag names are not case sensitive and appear in all uppercase.

Table 2-16 List of Backup Sets (LIST BACKUP ... SUMMARY)

Column	Indicates
`Key`	A unique key identifying this backup set. If RMAN is 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 RMAN is connected in `NOCATALOG` mode, then `BS Key` displays the `RECID` from `V$BACKUP_SET`.
`TY`	The type of backup: backup set (`B`) or proxy copy (`P`).
`LV`	For incremental backups, the incremental backup level (`0` or `1`). For backup sets containing full backups of data files, `F`. For backup sets containing archived redo log files, `A`.
`S`	The status of the backup: `A` (available), `U` (unavailable), or `X` (all backup pieces in set expired). Refer to the `CHANGE`, `CROSSCHECK`, and `DELETE` commands for an explanation of each status.
`Device Type`	The type of device on which the backup was made, for example, `DISK` or `sbt`.
`Completion Time`	The date and time that the backup set completed. The format of this field depends on the `NLS_LANG` and `NLS_DATE_FORMAT` environment settings.
`#Pieces`	The number of backup pieces in the backup set.
`#Copies`	The number of copies made of each backup piece in the set. The number is `1` if no duplexing was performed. Otherwise, the value ranges from `2` to `4`.
`Compressed`	`YES` if the backup set was compressed by RMAN; `NO` if not compressed by RMAN.
`Tag`	The tag applied to the backup set. An asterisk (*) indicates that backup pieces have different tags within the same backup set, which occurs when a user changes the tag when using `CATALOG` or `BACKUP BACKUPSET`. Tag names are not case sensitive and appear in all uppercase.

Table 2-17 List of Backup Pieces (LIST BACKUPPIECE ...)

Column	Indicates
`BP Key`	A unique identifier for this backup piece in the recovery catalog or target database control file. If RMAN is connected to a catalog, then `BP Key` is the primary key of the backup piece in the catalog. It corresponds to `BP_KEY` in the `RC_BACKUP_PIECE` view. If RMAN is connected in `NOCATALOG` mode, then `BP Key` displays the `RECID` from `V$BACKUP_PIECE`. Note: The values for `KEY` in the recovery catalog and the control file are different.
`BS Key`	A unique key identifying this backup set. If RMAN is 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 RMAN is connected in `NOCATALOG` mode, then `BS Key` displays the `RECID` from `V$BACKUP_SET`.
`Pc#`	The number of the backup piece in the backup set.
`Cp#`	The copy number of this backup piece in the backup set. The number is `1` if no duplexing was performed. Otherwise, the value ranges from `2` to `4`.
`Status`	The backup piece status: `AVAILABLE`, `UNAVAILABLE`, or `EXPIRED` (refer to the `CHANGE`, `CROSSCHECK`, and `DELETE` commands for an explanation of each status).
`Device Type`	The type of device on which the backup was made, for example, `DISK` or `sbt`.
`Piece Name`	The file name or handle of the backup piece. If the piece is stored on SBT, then the Handle and media ID are displayed.

Table 2-18 List of Datafile Backups (LIST BACKUP ... BY FILE)

Column	Indicates
`File`	The absolute data file number.
`Key`	A unique key identifying this backup set. If RMAN is connected to a recovery catalog, then `Key` is the primary key of the backup set in the catalog. It corresponds to `BS_KEY` in the `RC_BACKUP_SET` view. If RMAN is connected to a target database in `NOCATALOG` mode, then `Key` displays the `RECID` from `V$BACKUP_SET`.
`TY`	The type of backup: backup set (`B`) or proxy copy (`P`).
`LV`	The backup level: `F` for nonincrementals, level `0` or `1` for incrementals.
`S`	The status of the backup: `A` (available), `U` (unavailable), or `X` (all backup pieces in set expired). Refer to the `CHANGE`, `CROSSCHECK`, and `DELETE` commands for an explanation of each status.
`Ckp SCN`	The checkpoint of the data file at the time it was backed up. All database changes prior to the SCN have been written to the file; changes after the specified SCN have not been written to the file.
`Ckp Time`	The checkpoint of the data file at the time it was backed up. All database changes prior to the time have been written to the file; changes after the specified time have not been written to the file.
`#Pieces`	The number of backup pieces in the backup set.
`#Copies`	The number of copies made of each backup piece in the set. The number is `1` if no duplexing was performed. Otherwise, the value ranges from `2` to `4`.
`Compressed`	`YES` if the backup was compressed by RMAN; `NO` if not compressed by RMAN.
`Tag`	The tag applied to the backup set. An asterisk (*) indicates that backup pieces have different tags within the same backup set, which occurs when a user changes the tag when using `CATALOG` or `BACKUP BACKUPSET`. Tag names are not case sensitive and appear in all uppercase.

Table 2-19 List of Archived Log Backups (LIST BACKUP ... BY FILE)

Column	Indicates
`Thrd`	The thread number of the redo log.
`Seq`	The log sequence number of the archived log.
`Low SCN`	The lowest SCN in the archived log.
`Low Time`	The time when the database switched into the redo log having this sequence number.
`BS Key`	A unique key identifying this backup set. If RMAN is 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 RMAN is connected in `NOCATALOG` mode, then `BS Key` displays the `RECID` from `V$BACKUP_SET`.
`S`	The status of the backup: `A` (available), `U` (unavailable), or `X` (all backup pieces in set expired). Refer to the `CHANGE`, `CROSSCHECK`, and `DELETE` commands for an explanation of each status.
`#Pieces`	The number of backup pieces in the backup set.
`#Copies`	The number of copies made of each backup piece in the set. The number is `1` if no duplexing was performed. Otherwise, the value ranges from `2` to `4`.
`Compressed`	`YES` if the backup was compressed by RMAN; `NO` if not compressed by RMAN.
`Tag`	The tag applied to the backup set. Tag names are not case sensitive and appear in all uppercase.

Table 2-20 List of Control File Backups (LIST BACKUP ... BY FILE)

Column	Indicates
`CF Ckp SCN`	Checkpoint SCN of the control file.
`Ckp Time`	The log sequence number of the archived log.
`BS Key`	A unique key identifying this backup set. If RMAN is 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 RMAN is connected in `NOCATALOG` mode, then `BS Key` displays the `RECID` from `V$BACKUP_SET`.
`S`	The status of the backup: `A` (available), `U` (unavailable), or `X` (all backup pieces in set expired). Refer to the `CHANGE`, `CROSSCHECK`, and `DELETE` commands for an explanation of each status.
`#Pieces`	The number of backup pieces in the backup set.
`#Copies`	The number of copies made of each backup piece in the set. The number is `1` if no duplexing was performed. Otherwise, the value ranges from `2` to `4`.
`Compressed`	`YES` if the backup was compressed by RMAN; `NO` if not compressed by RMAN.
`Tag`	The tag applied to the backup set. Tag names are not case sensitive and appear in all uppercase.

Table 2-21 List of Datafile Copies

Column	Indicates
`Key`	The unique identifier for the data file copy. Use this value in a `CHANGE` command to alter the status of the data file copy. If RMAN is connected to a recovery catalog, then `Key` is the primary key of the data file copy in the catalog. It corresponds to `CDF_KEY` in the `RC_DATAFILE_COPY` view. If RMAN is connected in `NOCATALOG` mode, then `Key` displays the `RECID` from `V$DATAFILE_COPY`. Note: The values for `KEY` in the recovery catalog and the control file are different.
`File`	The file number of the data file from which this copy was made.
`S`	The status of the copy: `A` (available), `U` (unavailable), or `X` (expired). Refer to the `CHANGE`, `CROSSCHECK`, and `DELETE` commands for an explanation of each status.
`Completion Time`	The date and time that the copy completed. The value of this field is sensitive to the `NLS_LANG` and `NLS_DATE_FORMAT` environment variables.
`Ckp SCN`	The checkpoint of this data file when it was copied. All database changes prior to this SCN have been written to this data file.
`Ckp TIME`	The checkpoint of this data file when it was copied. All database changes prior to this time have been written to this data file.
`Name`	The file name of the data file copy.
`Tag`	The tag applied to the data file copy. Tag names are not case sensitive and appear in all uppercase.

Table 2-22 List of Control File Copies

Column	Indicates
`Key`	The unique identifier for the control file copy. Use this value in a `CHANGE` command to alter the status of the copy. If RMAN is connected to a recovery catalog, then `Key` is the primary key of the control file copy in the catalog. It corresponds to `CCF_KEY` in the `RC_CONTROLFILE_COPY` view. If RMAN is connected in `NOCATALOG` mode, then `Key` displays the `RECID` from `V$DATAFILE_COPY`. Note: The values for `Key` in the recovery catalog and the control file are different.
`S`	The status of the copy: `A` (available), `U` (unavailable), or `X` (expired). Refer to the `CHANGE`, `CROSSCHECK`, and `DELETE` commands for an explanation of each status.
`Completion Time`	The date and time that the copy completed. The value of this field is sensitive to the `NLS_LANG` and `NLS_DATE_FORMAT` environment variables.
`Ckp SCN`	The checkpoint of this control file when it was copied.
`Ckp TIME`	The checkpoint of this control file when it was copied.
`Name`	The file name of the control file copy.
`Tag`	The tag applied to the control file copy. Tag names are not case sensitive and appear in all uppercase.

Table 2-23 List of Archived Log Copies

Column	Indicates
`Key`	The unique identifier for this archived redo log copy. Use this value in a `CHANGE` command to alter the status of the copy. If RMAN is connected to a recovery catalog, then `Key` is the primary key of the backup set in the catalog. It corresponds to `AL_KEY` in the `RC_ARCHIVED_LOG` view. If RMAN is connected in `NOCATALOG` mode, then `Key` displays the `RECID` from `V$ARCHIVED_LOG`. Note: The values for `Key` in the recovery catalog and the control file are different.
`Thrd`	The redo log thread number.
`Seq`	The log sequence number.
`S`	The status of the copy: `A` (available), `U` (unavailable), or `X` (expired). Refer to the `CHANGE`, `CROSSCHECK`, and `DELETE` commands for an explanation of each status.
`Low Time`	The time when the database switched into the redo log having this sequence number.
`Name`	The file name of the archived redo log copy.

Table 2-24 List of Database Incarnations

Column	Indicates
`DB Key`	When combined with the `Inc Key`, the unique key by which RMAN identifies the database incarnation in the recovery catalog. Use this key to unregister a database from a recovery catalog, that is, delete all the rows associated with that database from the recovery catalog.
`Inc Key`	When combined with `DB` `Key`, the unique key by which RMAN identifies the database incarnation in the recovery catalog. Use this key in `RESET DATABASE` `TO INCARNATION` when recovering the database to a time before the most recent `RESETLOGS`.
`DB Name`	The database name as listed in the `DB_NAME` parameter.
`DB ID`	The database identification number, which the database generates automatically at database creation.
`STATUS`	`CURRENT` for the current incarnation, `PARENT` for the parent incarnations of the current incarnation, and `ORPHAN` for orphaned incarnations.
`Reset SCN`	The SCN at which the incarnation was created.
`Reset Time`	The time at which the incarnation was created.

Table 2-25 List of Stored Scripts in the Recovery Catalog (LIST SCRIPT NAMES)

Column	Indicates
`Script Name`	The name of the stored script.
`Description`	The comment provided when the script was created.

Table 2-26 List of Restore Points (LIST RESTORE POINT)

Column	Indicates
`SCN`	The SCN for the restore point.
`RSP Time`	The time specified in the `CREATE RESTORE POINT` statement; otherwise null.
`Type`	`GUARANTEED` if a guaranteed restore point; null if a normal restore point.
`Time`	The time that the restore point was created.
`Name`	The name of the restore point.

Table 2-27 List of Failures

Column	Indicates
`Failure ID`	The unique identifier for a failure.
`Priority`	The priority of the failure: `CRITICAL`, `HIGH`, or `LOW`. Failures with `CRITICAL` priority require immediate attention because they make the whole database unavailable. Typically, critical failures bring down the instance and are diagnosed during the subsequent startup. The database is not available until all critical failures are fixed (see `ADVISE FAILURE`). Failures with `HIGH` priority make a database partially unavailable or unrecoverable, and usually have to be repaired in a reasonably short time. Examples of such failures include physical data block corruptions, nonfatal I/O errors, missing archived redo log files or backup files, and so on. Failures with `LOW` priority can be ignored until more important failures are fixed. For example, a block corruption is initially assigned a high priority, but if this block is not important for the database availability, you can use `CHANGE` `FAILURE` to change the priority to `LOW`.
`Status`	The repair status of the failure. The status of a failure is `OPEN` (not repaired) until the appropriate repair action is invoked. The failure status changes to `CLOSED` when the repair is completed.
`Time Detected`	The date when the failure was diagnosed.
`Summary`	Summary of the failure.

Table 2-28 List of Databases (LIST DB_UNIQUE_NAME)

Column	Indicates
`DB Key`	When combined with `Inc Key`, the unique key by which RMAN identifies the database incarnation in the recovery catalog. Primary and standby databases share the same `DB Key` value.
`DB Name`	The `DB_NAME` of the database. Primary and standby databases share the same `DB Name` value.
`DB ID`	The DBID of the database. Primary and standby databases share the same DBID.
`Database Role`	`PRIMARY` if the database is a primary database; `STANDBY` if it is a standby database.
`Db_unique_name`	The `DB_UNIQUE_NAME` of the database. Primary and standby databases have different `DB_UNIQUE_NAME` values.

Examples

Example 2-108 Listing Backups

This 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;

List 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

Example 2-109 Listing a Summary of Backups

This example summarizes the RMAN backups listed in Example 2-108.

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

Example 2-110 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

Example 2-111 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

Example 2-112 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

Example 2-113 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