ORA 27070 followed by OS 04016
Posted on 2010-01-06
I have been facing "i/O" errors trying to import data into my Oracle 10g database.
Initially the database files were hosted on a SAN volume, so I assumed it was a SAN issue.
So I switched to working on an eSATA drive. Same error.
So now... I am working on the INTERNAL drive (DELL PERC 6/i SCSI Disk Device) ! Same error!
The consistent error on the command prompt, and in the alert log is:
KCF: write/open error block=0x1289 online=1
error=27070 txt: 'OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 31) A device attached to the system is not functioning.'
Wed Jan 06 12:30:11 2010
Errors in file d:\oracledatabasefiles\am791\admin\bdump\am791_dbw1_5572.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01114: IO error writing block to file 2 (block # 4745)
ORA-01110: data file 2: 'D:\ORACLEDATABASEFILES\AM791\UNDOTBS01.DBFX'
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 31) A device attached to the system is not functioning.
I know that the DB in in noarchivelog mode, and the inability to recover doesn't bother me as much as the fact that the undo / system tablespace files just become invisible to my Oracle process. I can the files in windows explorer, they are right there!
What should I be looking at?