Oracle RMAN物理备份技术之查询和报告

核心提示：RMAN备份的查询和报告： LIST命令：LIST BACKUP; # lists backup sets, image copies, and proxy copiesLIST BACKUPSET;# lists only backup sets and proxy copiesLIST COPY; # lists

RMAN备份的查询和报告：

LIST命令：

LIST BACKUP;　　　 # lists backup sets, image copies, and proxy copies
LIST BACKUPSET;　　# lists only backup sets and proxy copies
LIST COPY;　　　　 # lists only disk copies
LIST BACKUP BY FILE; # shows backup sets, proxy copies, and image copies
LIST COPY BY FILE;　 # shows only disk copies
LIST EXPIRED BACKUP;
LIST EXPIRED BACKUP BY FILE;
LIST BACKUP SUMMARY;　# lists backup sets, proxy copies, and disk copies
LIST EXPIRED BACKUP SUMMARY;
LIST BACKUP OF DATABASE;　　 # lists backups of all files in database
LIST COPY OF DATAFILE 'ora_home/oradata/trgt/system01.dbf';　　
　　　　　　　　　　　　　 # lists copy of specified datafile
LIST BACKUPSET 213;　　 # lists specified backup set
LIST DATAFILECOPY '/tmp/tools01.dbf';　　 # lists datafile copy
LIST BACKUPSET TAG 'weekly_full_db_backup';　
　　　　　　　　　　　　　　 # specify a backup set by tag
LIST COPY OF DATAFILE 'ora_home/oradata/trgt/system01.dbf' DEVICE TYPE sbt;
　　　　　　　　　　　　　　# specify a backup or copy by device type
LIST BACKUP LIKE '/tmp/%';　　# specify a backup by directory or path
LIST COPY OF DATAFILE 2 COMPLETED BETWEEN '10-DEC-2002' AND '17-DEC-2002';
　　　　　　　　# specify a backup or copy by a range of completion dates
LIST ARCHIVELOG ALL BACKED UP 2 TIMES TO DEVICE TYPE sbt;
　　　　　　　　　 # specify logs backed up at least twice to tape
LIST BACKUP OF DATAFILE 1;
LIST BACKUP OF TABLESPACE;
LIST BACKUP OF DATAFILE;
LIST BACKUP ARCHIVELOG ALL;　　#简要信息
LIST BACKUP OF ARCHIVELOG ALL;　　#详细信息
LIST BACKUP OF CONTROFILE;
LIST BACKUP OF SPFILE;