please :) urgent help 27069: skgfdisp: attempt to do I/O beyond the range of the file

From: Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com>
Date: Thu, 11 Jan 2007 20:00:59 -0400
Message-ID: <cd4305c10701111600v8664269geaefe8df2111694c@mail.gmail.com>

Hi, please, I can't open a datafile on production database, I got the following error and can't recover rolling forward from a previous backup of the datafile either.

Is there a way to at least to open as readonly to recover data please is urgent any idea:)

Errors in file e:\orasfon\trace\user\sfon_ora_636.trc:

ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 3 cannot be read at this time
ORA-01110: data file 3: 'E:\ORASFON\DATAFILES\DFL_USER_SFON'
ORA-06512: at line 6


KCF: write/open error block=0x7f966 online=1
     file=3 E:\ORASFON\DATAFILES\DFL_USER_SFON
     error=27069 txt: 'OSD-04026: Invalid parameter passed. (OS 522598)'

Automatic datafile offline due to write error on file 3: E:\ORASFON\DATAFILES\DFL_USER_SFON

SQL> recover datafile 'E:\oraSFON\datafiles\DFL_USER_SFON';

ORA-00283: recovery session canceled due to errors
ORA-01115: IO error reading block from file 3 (block # 524241)
ORA-01110: data file 3: 'E:\ORASFON\DATAFILES\DFL_USER_SFON'
ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
OSD-04026: Invalid parameter passed. (OS 524241)

http://www.oracleboliviaspecialists.com/

Oracle Certified Profesional 9i 10g
Oracle Certified Professional Developer 6i

10 years of experience from Oracle 7 to Oracle10g and developer 6i

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jan 11 2007 - 18:00:59 CST