Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Now, I understand that the USER03.DBF data file is
somehow inaccessable. But the permissions on the file are "Full Modify" and nothing else is accessing this specific file, like a backup software or antivirus; this is a dedicated oracle box.

Given the the file is not being able to be read or write from, what are my options?
The file size is 27GB, but size on disk is 4GB; I am not sure if this is of any significance. And disk is definatly not out of space.

Autoextend is set at 100MB. And database is about 150GB. Within alerts.log, there were over 50 autoextend notes before the corrupt block error showed up.

This question came from our site for professional and enthusiast programmers.

1

Have you checked the alert log for the database?
–
DCookieAug 19 '12 at 4:33

I agree with DCookie - you need to check the alert log.
–
APCAug 19 '12 at 8:44

But just to be clear: are you saying you got this error while connecting to the database in a local session, that is +on the database server+ itself? Because that seems unlikely.
–
APCAug 19 '12 at 8:46

@apc: yes, it is on the database server. dcookie: I will go over the alerts.log and post what I discover.
–
lvchallaAug 19 '12 at 12:32

The problem is that one of the blocks of the datafile was corrupt.. You should have taken the last version from the backup and then recover with the archive logs. This will restore the file to the state before it got corrupt.
–
steveAug 23 '12 at 4:07

2 Answers
2

O/S-Error: (OS 665) The requested operation could
not be completed due to a file system limitation

So the windows error 665 is the reason for the error an the error refers to file C:\ORADATAFILES\ORAPROD03\USERS03.DBF.What is the problem with the file? The following article discusses this error message: What factors can lead to Win32 error 665 (file system limitation)?. If the reason is file fragmentation a patch is available. I know it is to late but maybe a restore will not be necessary in this situation.