Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Recover datafile that has extended beyond OS limit?

669345Jul 27 2010 — edited Jul 27 2010
We have a Linux server running Oracle 8.1.7 and we have a data file (users01.dbf) that had "autoextend" enabled and has now grown past the upper limit of the underlying filesystem. Oracle will not open the file, as the OS returns an error: "Linux Error: 75: Value too large for defined data type"

Here are some details:

OS: Redhat 7
Filesystem: Ext2
Oracle Ver: 8.1.7
DBF Size: >2gb

I have attempted to copy the .dbf files to a new server with little luck. Redhat 10 with Oracle 10 complained that the ctl files were corrupt, so I deleted them and recreated them based on the data files. After that, the DB indicated that the datafiles needed a media recovery, so I performed a "recover datafile..." on each of them successfully. Once I try to open the database, I get a "End of communication channel" error. I cannot mount it in Windows as the blocksizes are different (8192 vs. 4096)

I am at the end of my ideas on how to recover this file. Any suggestions?

I have thought of:

1. Bring a copy of 8.1.7 up on a new Redhat system running a newer FS (Reiser) and try to open the file
2. Add a new drive to the old sever and format that with the new FS, copy the dbf files there and point the DB to those files

Any tools that I try to run on the old server all hit the roadblock of the Linux:75 error.

Thanks for any ideas that come to mind.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 24 2010
Added on Jul 27 2010
2 comments
717 views