ora-19510/ora-27037

早上在上班的路上接到警示簡訊，警示一個庫的歸檔有問題。

alert.log檔案內容如下：
Wed Jul 25 06:00:02 2012
Errors in file /Oracle/app/oracle/admin/skate/bdump/skate_arc0_3618.trc:
ora-19510: failed to set size of 84875 blocks for file "/oracle/oradata/skate/archive/1_59432_713742632.dbf" (blocksize=512)
ora-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 9
Wed Jul 25 06:00:02 2012
Errors in file /oracle/app/oracle/admin/skate/bdump/skate_arc0_3618.trc:
ora-19510: failed to set size of 84875 blocks for file "/oracle/oradata/skate/archive/1_59432_713742632.dbf" (blocksize=512)
ora-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 9
Wed Jul 25 06:00:02 2012
ARC0: Error 19510 Closing archive log file '/oracle/oradata/skate/archive/1_59432_713742632.dbf'
ARCH: Archival stopped, error occurred. Will continue retrying
Wed Jul 25 06:00:02 2012
ORACLE Instance skate - Archival Error
Wed Jul 25 06:00:02 2012
ora-16038: log 1 sequence# 59432 cannot be archived
ora-19510: failed to set size of  blocks for file "" (blocksize=)
ora-00312: online log 1 thread 1: '/oracle/oradata/skate/redo01.log'
Wed Jul 25 06:00:02 2012
Errors in file /oracle/app/oracle/admin/skate/bdump/skate_arc0_3618.trc:
ora-16038: log 1 sequence# 59432 cannot be archived
ora-19510: failed to set size of  blocks for file "" (blocksize=)
ora-00312: online log 1 thread 1: '/oracle/oradata/skate/redo01.log

.......

從錯誤log分析，
ARC0: Error 19510 Closing archive log file '/oracle/oradata/skate/archive/1_59432_713742632.dbf'
ARCH: Archival stopped, error occurred. Will continue retrying

關閉歸檔記錄檔時異常，錯誤的原因是不能獲得檔案控制代碼，在os層提示沒有這個檔案

ora-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory

為什麼會沒有歸檔檔案了呢？誰刪除了？大早晨的，大家還都沒到公司，誰會刪除歸檔檔案呢？想到可能是定時任務刪除歸檔，於是尋找定時任務，發現有個每小時刪除所有歸檔的任務，這說明oracle在操作完歸檔準備close的時候，發現歸檔檔案被定時任務給刪除了，所以就報如上的錯誤了。這個定時任務的邏輯有問題，於是我調整為，每次刪除2小時以前的歸檔。

----end----

更多Oracle相關資訊見Oracle 專題頁面 http://www.bkjia.com/topicnews.aspx?tid=12