oracle数据库RMAN 下的 list 命令如何使用？

列出详细备份信息：备份集（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';

列出详细备份信息：备份集（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';

列出详细备份信息：备份集（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';