在使用RMAN备份、还原的过程中，我们经常需要查看备份的一些详细信息，例如，RMAN提供了LIST命令。关于LIST命令的详细信息

可以参考Oracle Database Backup and Recovery Reference文档。

列出备份信息

列出详细备份信息：备份集（Backup Sets）,镜像备份(image copies),proxy copies的信息。

lists backup sets, image copies, and proxy copies

RMAN> list backup;

列出信息备份信息：备份集（Backup Sets）,proxy copies信息。

lists only backup sets and proxy copies

RMAN> list backupset;
列出所有数据文件的备份信息

lists backups of all files in database

RMAN> list backup of database;

列出特定表空间的所有数据文件备份集

RMAN> list backup of tablespace users;

列出指定文件的备份信息

RMAN> list backup of datafile 1;

或

RMAN> list backup of datafile '/u01/app/oracle/oradata/epps/system01.dbf';

按备份类型列出备份

RMAN> list backup by file;

列出备份的映像副本信息

lists only disk copies

RMAN> list copy;

列出过期备份信息（backup sets, proxy copies, and image copies）。

Displays backup sets, proxy copies, and image copies marked in the repository as EXPIRED, that is, "not found."

RMAN> list expired backup;

列出过期备份信息（backup sets, proxy copies）

RMAN> list expired backupset;

按备份类型列出过期备份信息

RMAN> list expired backup by file;

概述可用的备份

RMAN> list backup summary;

概述过期的备份

RMAN> list expired backup summary;

列出某个备份集的信息

RMAN> list backupset 59139;

列出数据文件映像副本

RMAN> list copy of datafile '/u01/app/oracle/oradata/epps/system01.dbf';

列出控制文件的备份信息

RMAN> list backup of controlfile;

列出备份集中TAGE的备份片信息

RMAN> list backupset tage 'TAG20160811T000724'

列出所有备份的控制文件信息

RMAN> list backup of controlfile;

列出备份的spfile文件信息

RMAN> list backup of spfile;

查看已备份的归档日志信息

RMAN> list backup of archivelog all;

RMAN> list backup of archivelog from scn 22727871375;

RMAN> list backup of archivelog until scn 22727813497;

RMAN> list backup of archivelog from scn 22727031113 until scn 22727268951;

RMAN> list backup of archivelog from logseq 25432;

RMAN> list backup of archivelog until logseq 25432;

RMAN> list backup of archivelog from logseq 25426 until logseq 25428;

列出所有的归档日志

RMAN> list archivelog all;

列出所有失效的归档日志

RMAN>list expired archivelog all;

列出指定表空间的备份信息

RMAN> list copy of tablespace 'SYSTEM';

Listing Database Incarnations

RMAN> list incarnation;

List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time

---

1 1 PPS 2179993557 PARENT 1 30-JUN-05
2 2 PPS 2179993557 PARENT 446075 19-JUL-09
3 3 PPS 2179993557 CURRENT 18010906971 26-APR-15

RMAN>

RMAN> list incarnation of database;
RMAN> list incarnation of database xxx;