[20150902]rman的list archivelog命令.txt
[20150902]rman的list archivelog命令.txt
--昨天同事要查詢2015/8/13號日誌,要確定需要檢查日誌的範圍:
RMAN> list archivelog all completed between '2015-08-13' and '2015-08-13 18:00:00';
List of Archived Log Copies for database with db_unique_name xxxxxx
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - -------------------
2497 1 1421 A 2015-08-13 07:12:52
Name: /u01/app/oracle/oradata/xxxxxx/archivelog/1_1421_862160568.dbf
--很奇怪!僅僅看見一個例項有檔案。另外的例項呢?增加一點時間:
RMAN> list archivelog all completed between '2015-08-13' and '2015-08-14 00:00:00';
List of Archived Log Copies for database with db_unique_name xxxxxx
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - -------------------
2497 1 1421 A 2015-08-13 07:12:52
Name: /u01/app/oracle/oradata/xxxxxx/archivelog/1_1421_862160568.dbf
2499 1 1422 A 2015-08-13 16:09:00
Name: /u01/app/oracle/oradata/xxxxxx/archivelog/1_1422_862160568.dbf
2498 2 1237 A 2015-08-13 07:12:50
Name: /u01/app/oracle/oradata/xxxxxx/archivelog/2_1237_862160568.dbf
--終於明白為什麼?主要是要理解rman命令list archivelog命令裡面的completed,表示完成的時間。而它顯示的Low Time。
--我上面的查詢實際上指在'2015-08-13' and '2015-08-13 18:00:00'這個時間段完成的日誌。主要是單個日誌檔案設定太大。
RMAN> list archivelog all completed between '2015-08-13' and '2015-08-14 06:00:00';
List of Archived Log Copies for database with db_unique_name xxxxxx
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - -------------------
2497 1 1421 A 2015-08-13 07:12:52
Name: /u01/app/oracle/oradata/xxxxxx/archivelog/1_1421_862160568.dbf
2499 1 1422 A 2015-08-13 16:09:00
Name: /u01/app/oracle/oradata/xxxxxx/archivelog/1_1422_862160568.dbf
2501 1 1423 A 2015-08-13 20:44:16
Name: /u01/app/oracle/oradata/xxxxxx/archivelog/1_1423_862160568.dbf
2503 1 1424 A 2015-08-14 05:27:04
Name: /u01/app/oracle/oradata/xxxxxx/archivelog/1_1424_862160568.dbf
2498 2 1237 A 2015-08-13 07:12:50
Name: /u01/app/oracle/oradata/xxxxxx/archivelog/2_1237_862160568.dbf
2500 2 1238 A 2015-08-13 20:44:18
Name: /u01/app/oracle/oradata/xxxxxx/archivelog/2_1238_862160568.dbf
2502 2 1239 A 2015-08-14 05:27:03
Name: /u01/app/oracle/oradata/xxxxxx/archivelog/2_1239_862160568.dbf
--可以發現例項1需要'2015-08-13' and '2015-08-13 18:00:00'時間範圍內,實際需要檔案
--Name: /u01/app/oracle/oradata/xxxxxx/archivelog/1_1421_862160568.dbf
--Name: /u01/app/oracle/oradata/xxxxxx/archivelog/1_1422_862160568.dbf
--Name: /u01/app/oracle/oradata/xxxxxx/archivelog/2_1237_862160568.dbf
--如果要真正這樣查詢,上面的命令自己還要做1點點判斷,如何寫rman命令直接顯示需要的結果呢?自己測試以下,應該寫成如下。
RMAN> list archivelog time between '2015-08-13' and '2015-08-13 18:00:00';
List of Archived Log Copies for database with db_unique_name xxxxxx
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - -------------------
2497 1 1421 A 2015-08-13 07:12:52
Name: /u01/app/oracle/oradata/xxxxxx/archivelog/1_1421_862160568.dbf
2499 1 1422 A 2015-08-13 16:09:00
Name: /u01/app/oracle/oradata/xxxxxx/archivelog/1_1422_862160568.dbf
2498 2 1237 A 2015-08-13 07:12:50
Name: /u01/app/oracle/oradata/xxxxxx/archivelog/2_1237_862160568.dbf
--順便寫一個rman小技巧,查手冊太慢。可以輸入list archivelog,加兩次回車這樣會出現命令的一些解析,不斷猜出可以完成命令的拼寫。
--例子:
RMAN> list archivelog
2>
3>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "end-of-file": expecting one of: "all, from, high, like, low, scn, sequence, time, until, double-quoted-string, integer, single-quoted-string"
RMAN-01007: at line 3 column 1 file: standard input
RMAN> list archivelog time
2>
3>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "end-of-file": expecting one of: "between"
RMAN-01007: at line 3 column 1 file: standard input
RMAN> list archivelog time between '2015-08-13' and '2015-08-13 18:00:00';
List of Archived Log Copies for database with db_unique_name xxxxxx
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - -------------------
2497 1 1421 A 2015-08-13 07:12:52
Name: /u01/app/oracle/oradata/xxxxxx/archivelog/1_1421_862160568.dbf
2499 1 1422 A 2015-08-13 16:09:00
Name: /u01/app/oracle/oradata/xxxxxx/archivelog/1_1422_862160568.dbf
2498 2 1237 A 2015-08-13 07:12:50
Name: /u01/app/oracle/oradata/xxxxxx/archivelog/2_1237_862160568.dbf
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/267265/viewspace-1789599/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【RMAN】LIST命令演示
- 理解RMAN backup database plus archivelog命令DatabaseHive
- RMAN命令LIST操作總結
- RMAN的list和report命令詳解
- Oracle RMAN 的 show,list,crosscheck,delete命令整理OracleROSdelete
- 理解RMAN backup database plus archivelog delete all input命令DatabaseHivedelete
- Oracle 11g RMAN備份-RMAN的backup database plus archivelog命令背後的操作OracleDatabaseHive
- rman restore archivelog logRESTHive
- rman中關於archivelog的操作Hive
- Archivelog & Noarchivelog mode in RMANHive
- RMAN - backup archivelog all 與 backup database plus archivelog 區別HiveDatabase
- RMAN命令configure,report,list,crosscheck,delete的使用方法ROSdelete
- Oracle Rman 命令詳解(List report backup configure)Oracle
- 處理過期的archivelog和rman備份Hive
- 利用rman刪除硬碟上丟失的archivelog硬碟Hive
- RMAN database plus archivelog實現順序DatabaseHive
- Oracle RMAN的show,list,crosscheck,deleteOracleROSdelete
- RMAN delete archivelog命令刪除歸檔日誌及歸檔日誌拷貝deleteHive
- rman 還原歸檔日誌(restore archivelogRESTHive
- rman 還原歸檔日誌(restore archivelog)RESTHive
- rman report list crosscheck deleteROSdelete
- Openstack的的nova list命令
- rman 命令
- RMAN命令
- How to config (no)archivelog mode and manage archive log files by RMANHive
- redis命令之-listRedis
- RMAN備份list report crosscheck validate change delete 和恢復命令例項ROSdelete
- [20160202]crosscheck archivelog all.txtROSHive
- RMAN命令大全
- rman(2)--命令
- RMAN命令整理
- RMAN RAC Archivelog Restore Fails with RMAN-20242 (Doc ID 180169.1)HiveRESTAI
- [20160923]取出備份集的archivelog檔案.txtHive
- RMAN中常用的命令(一)
- RMAN常用的命令和操作
- RMAN常用的命令和操作:
- rman中的catalog命令!
- rman的一些命令