Re: please :) urgent help 27069: skgfdisp: attempt to do I/O beyond the range of the file
- From: "Juan Carlos Reyes Pacheco" <juancarlosreyesp@xxxxxxxxx>
- To: "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
- Date: Thu, 11 Jan 2007 20:38:53 -0400
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@xxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxx [mailto:
oracle-l-bounce@xxxxxxxxxxxxx] *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
Other related posts:
