Recover datafile that has extended beyond OS limit?
669345Jul 27 2010 — edited Jul 27 2010We 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.