ora-19510/ora-27037

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

服務器租用/服務器托管中國五強！虛擬主機域名注冊頂級提供商！15年品質保障！--億恩科技[ENKJ.COM]