星期六, 7月 26, 2014

[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>

沒有留言:

LinkWithin-相關文件

Related Posts Plugin for WordPress, Blogger...