Search This Blog

Wednesday, July 16, 2008

ORA-38701 + ORA-27091 + ORA-27070 + OSD-04008


Today morning i got alots of call from my office... application program is not working.

when i reach office and check database then i found database is goes down (shutdown stage).

I checked alertlog file and found the following entries

ORA-38701: Flashback database log 156 seq 359 thread 1: "E:\FLASH_RECOVERY\ORAMFE\FLASHBACK\O1_MF_47SJ8LSY_.FLB"

ORA-27091: unable to queue I/O

ORA-27070: async read/write failed

OSD-04008: WriteFile() failure, unable to write to file

O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.

After that I done the following

Mount the database

sql> startup mount

trun off flashback option

sql> alter database flashback off;

open the database

sql> alter database open;

Now everyone get connection with database and everything is normal. but my work is not complete after that i want to know exact reason for above error.

so i checked with metalink and found it is reported as a BUG.

kindly refer the following metalink note: 311150.1

Our database is already patched with 10.1.0.5.0.

Above BUG is fixed in 10gr2.

No comments: