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

Thank you to everyone,
The Metalink Note 317174.1
to do a full recover on 9.2.0.3 and upgrade database

maybe could help I'll try, any other idea is welcome :)

On 1/11/07, Reidy, Ron <Ron.Reidy_at_arraybiopharma.com> wrote:
>
> Juan,
>
>
>
> Does this http://www.dbasupport.com/forums/archive/index.php/t-29517.htmlapply to you? Is your file > 4 GB?
>
>
>
> --
>
> Ron Reidy
>
> Lead DBA
>
> Array BioPharma, Inc.
>
>
> ------------------------------
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Juan Carlos Reyes Pacheco
> *Sent:* Thursday, January 11, 2007 5:01 PM
> *To:* oracle-l
> *Subject:* please :) urgent help 27069: skgfdisp: attempt to do I/O beyond
> the range of the file
>
>
>
> 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
>
> ------------------------------
> This electronic message transmission is a PRIVATE communication which
> contains information
> which may be confidential or privileged. The information is intended to be
> for the use of the individual
> or entity named above. If you are not the intended recipient, please be
> aware that any disclosure,
> copying, distribution or use of the contents of this information is
> prohibited. Please notify the sender
> of the delivery error by replying to this message, or notify us by
> telephone (877-633-2436, ext. 0),
> and then delete it from your system.
>
>

-- 
----------------------------------------
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