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

.......

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

關(guān)閉歸檔日志文件時(shí)異常，錯(cuò)誤的原因是不能獲得文件句柄，在os層提示沒(méi)有這個(gè)文件

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

為什么會(huì)沒(méi)有歸檔文件了呢？誰(shuí)刪除了？大早晨的，大家還都沒(méi)到公司，誰(shuí)會(huì)刪除歸檔文件呢？想到可能是定時(shí)任務(wù)刪除歸檔，于是查找定時(shí)任務(wù)，發(fā)現(xiàn)有個(gè)每小時(shí)刪除所有歸檔的任務(wù)，這說(shuō)明Oracle在操作完歸檔準(zhǔn)備close的時(shí)候，發(fā)現(xiàn)歸檔文件被定時(shí)任務(wù)給刪除了，所以就報(bào)如上的錯(cuò)誤了。這個(gè)定時(shí)任務(wù)的邏輯有問(wèn)題，于是我調(diào)整為，每次刪除2小時(shí)以前的歸檔。

----end----

服務(wù)器租用/服務(wù)器托管中國(guó)五強(qiáng)！虛擬主機(jī)域名注冊(cè)頂級(jí)提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]