[RMAN] list backup of archivelog all 與 list archivelog all 的差別

RMAN>  list backup of archivelog all;  ==> 會列出backuppiece 與archive logs

不要小看此指令, 當backupset 的檔名亂取時, 判斷arc log 資訊就是靠它

List of Backup Sets

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

BS Key  Size       Device Type Elapsed Time Completion Time

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

2       54.22M     DISK        00:00:00     20140726 01:32:53

        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: BACKUP_ORCL_000001_072614013149

        Piece Name: /oracle/db102/dbs/03peari5_1_1

  List of Archived Logs in backup set 2

  Thrd Seq     Low SCN    Low Time          Next SCN   Next Time

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

  1    31      426604     20140726 01:11:00 441429     20140726 01:15:19

  1    32      441429     20140726 01:15:19 444127     20140726 01:32:52

RMAN> list archivelog all;

List of Archived Log Copies

Key     Thrd Seq     S Low Time          Name

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

1       1    31      A 20140726 01:11:00 /oracle/arch/1_31_853894793.dbf

2       1    32      A 20140726 01:15:19 /oracle/arch/1_32_853894793.dbf

RMAN>