Holly.
I look for your errors descriptions
$ oerr ORA 01115
01115, 00000, "IO error reading block from file %s (block # %s)"
// *Cause: Device on which the file resides is probably offline
// *Action: Restore access to the device
$ oerr ORA 01110
01110, 00000, "data file %s: '%s'"
// *Cause: Reporting file name for details of another error
// *Action: See associated error message
$ oerr ORA 27069
27069, 00000, "skgfdisp: attempt to do I/O beyond the range of the file"
// *Cause: internal error, the range of blocks being read or written is
// outside the range of the file, additional information indicates
// the starting block number, number of blocks in I/O, and the
// last valid block in the file
// *Action: check for trace file and contact Oracle Support
I think that you need to run next command as sysdba
"alter tablespace <YOUR_TABLESPACE_NAME> add file
'NEW_FILE_PATH_FOR_TABLESPACE' "
> OS:WIN2K
> DB:Oracle 9.0.1 (ArchiveLog & Production)
>
> I'm facing those error with one my datafile. The datafile is >4GB. The
> datafile is in autoextend mode, so I don't aware about the datafile
> increasing, until suddenly database down:( Unfortunetly, I've no backup at
> all also. The person who responsible to do offline backup never backup the
> database. Some archive log is missing also:(
>
> Please help me, to solve the problem. Any comment or suggestion I would
> appreciate.
>
> thank in advance,
> ~holly~
--
Best regards
Michael Ivanov, TD "ERA"
y 筅 ~'"jS
kڝاzN
nu楊w{Zx
I_at_ND
Received on Wed Oct 23 2002 - 03:23:57 CDT
