Ora-27037: unabletoobtainfilestatusLinux-x86_64Error: 2: Nosuchfileordirectory why is there no archive? Who deleted it?
Ora-27037: unable to obtain file statusLinux-x86_64 Error: 2: No such file or directory why is there No archive? Who deleted it?
In the morning, I received an alert text message on the way to work. An error occurred while archiving an alert library.
The content of the alert. log file is as follows:
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/41059432_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/41059432_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/41059432_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
.......
From error log analysis,
ARC0: Error 19510 Closing archive log file '/oracle/oradata/skate/archive/41059432_713742632.dbf'
ARCH: Archival stopped, error occurred. Will continue retrying
An exception occurred when closing the archive log file because the file handle cannot be obtained. The OS layer prompts that the file does not exist.
Ora-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Why is there no archive file? Who deleted it? Everyone has not been to the company this morning. Who will delete the archive file? The possible cause is that the scheduled task deletes the archive, so the scheduled task is searched and found that there is a task to delete all archives every hour. This indicates that when oracle completes archive preparation close, if the archive file is deleted by a scheduled task, the above error is reported. The logic of this scheduled task is wrong, so I adjusted it to delete the Archive two hours ago each time.
---- End ----
For more information about Oracle, see the Oracle topic page? Tid = 12