选项

示例

解释

BY BACKUP

LIST BACKUP OF DATABASE BY BACKUP

按备份集组织输出。

BY FILE

LIST BACKUP BY FILE

根据备份的文件显示备份

SUMMARY

LIST BACKUP SUMMARY

显示摘要信息

选项

示例

解释

EXPIRED

LIST EXPIRED COPY

列出记录在RMAN库中记录的备份，但上次执行的CROSSCHECK命令之后，当前并不在希望的磁盘或磁带的位置上。

RECOVERABLE

LIST BACKUP RECOVERABLE

列出状态为AVAILABLE，并且可用于备份和恢复的数据文件的备份和拷贝。

--1. 列出数据库备份集

RMAN> list backup of database;

List of Backup Sets

===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

1       Full    1.08G      DISK        00:01:49     06-JUL-13     

        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20130706T192144

        Piece Name: /u01/app/oracle/fast_recovery_area/TESTDB12/backupset/2013_07_06/o1_mf_nnndf_TAG20130706T192144_8xk9n8of_.bkp

  List of Datafiles in backup set 1

  File LV Type Ckp SCN    Ckp Time  Name

  ---- -- ---- ---------- --------- ----

  1       Full 1142921    06-JUL-13 /u01/app/oracle/oradata/TestDB12/system01.dbf

  2       Full 1142921    06-JUL-13 /u01/app/oracle/oradata/TestDB12/sysaux01.dbf

  3       Full 1142921    06-JUL-13 /u01/app/oracle/oradata/TestDB12/undotbs01.dbf

  4       Full 1142921    06-JUL-13 /u01/app/oracle/oradata/TestDB12/users01.dbf

  5       Full 1142921    06-JUL-13 /u01/app/oracle/oradata/TestDB12/example01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

4       Full    1.08G      DISK        00:03:08     06-JUL-13     

        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: TAG20130706T202137

        Piece Name: /u01/app/oracle/fast_recovery_area/TESTDB12/backupset/2013_07_06/o1_mf_nnndf_TAG20130706T202137_8xkf4l36_.bkp

  List of Datafiles in backup set 4

  File LV Type Ckp SCN    Ckp Time  Name

  ---- -- ---- ---------- --------- ----

  1       Full 1145755    06-JUL-13 /u01/app/oracle/oradata/TestDB12/system01.dbf

  2       Full 1145755    06-JUL-13 /u01/app/oracle/oradata/TestDB12/sysaux01.dbf

  3       Full 1145755    06-JUL-13 /u01/app/oracle/oradata/TestDB12/undotbs01.dbf

  4       Full 1145755    06-JUL-13 /u01/app/oracle/oradata/TestDB12/users01.dbf

  5       Full 1145755    06-JUL-13 /u01/app/oracle/oradata/TestDB12/example01.dbf

--2.列出数据文件1, 2的镜像

RMAN> list copy of datafile 1, 2;

specification does not match any datafile copy in the repository

--3. 从序号0列出归档日志的备份

RMAN> list backup of archivelog from sequence 0;

List of Backup Sets

===================

BS Key  Size       Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

3       5.09M      DISK        00:00:00     06-JUL-13     

        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20130706T202136

        Piece Name: /u01/app/oracle/fast_recovery_area/TESTDB12/backupset/2013_07_06/o1_mf_annnn_TAG20130706T202136_8xkf4jno_.bkp

  List of Archived Logs in backup set 3

  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

  ---- ------- ---------- --------- ---------- ---------

  1    9       1141987    06-JUL-13 1145746    06-JUL-13

BS Key  Size       Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

6       161.00K    DISK        00:00:00     06-JUL-13     

        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20130706T202541

        Piece Name: /u01/app/oracle/fast_recovery_area/TESTDB12/backupset/2013_07_06/o1_mf_annnn_TAG20130706T202541_8xkfd5tj_