Re: ORA error 1115 during export

yong, thanks.

I would love to run dbv on the hotbackup of the file, but for some reason this utility doesn't allow you to on files that are 2GB in size (and only 2GB).
Any suggestions?
(I may just need to call support on this one)

yong321_at_yahoo.com wrote:

> It may well be a hard drive problem. Try running dbv (DB Verify) on it.
> Unfortunately dbv is almost always too optimistic. If no error found,
> at OS level try copying this datafile to the same directory to a
> different filename. If fails, that's it. Also have your OS system admin
> take a look at this error. Finally call Oracle Support. I experienced
> similar problems in importing a few weeks ago. It was our hard drive.
>
> Yong Huang
>
> In article <390B1637.23188D04_at_yahoo.com>,
> Nikita <Nikita_at_yahoo.com> wrote:
> > We are running Oracle 8.0.5.2 on Solaris 2.7
> >
> > A couple of times now during a full export of our database, we receive
> > the following error message:
> >
> > EXP-00056: ORACLE error 1115 encountered
> > ORA-01115: IO error reading block from file 12 (block # 262145)
> > ORA-01110: data file 12: '/apps/ora_disk04/OMNI/omni04.dbf'
> > ORA-27072: skgfdisp: I/O error
> > SVR4 Error: 25: Inappropriate ioctl for device
> > Additional information: 262127
> >
> > Does this indicate that there could be problems with this particular
> > disk, and if so, why are exports successful all other times?
> >
> > Thanks.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon May 01 2000 - 00:00:00 CDT