Backup And Recovery User's Guide-從RMAN開始-RMAN操作報表-列表顯示備份

選項

示例

解釋

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_