oracle lists函数,oracle-rman-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/sjg/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 tag '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 3689528;--列出scn为3689528以后的日志备份

RMAN> list backup of archivelog until scn 3689589;--列出scn为3689589之前的日志备份

RMAN> list backup of archivelog from scn 3689528 until scn 3689589; --列出scn为3689528-3689528之间的日志备份

RMAN> list backup of archivelog from logseq 12365;--列出logseq为12365之后的日志备份

RMAN> list backup of archivelog until logseq 12370;--列出logseq为12370之前的日志备份

RMAN> list backup of archivelog from logseq 12365 until logseq 12370;--列出logseq为12365-12370之间的日志备份

列出所有的归档日志

RMAN> list archivelog all;

列出所有失效的归档日志

RMAN>list expired archivelog all;

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

RMAN> list copy of tablespace 'SYSTEM';

列出数据库Incarnations

RMAN> list incarnation;

RMAN> list incarnation database;

RMAN> list incatnation database ***;