Ora-19510/ora-27037

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 you can find a scheduled task and find that all archiving tasks are deleted every hour. This indicates that when oracle completes archive preparation and 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 Oracle topics page http://www.bkjia.com/topicnews.aspx? Tid = 12