Re: Export fails with ORA-01115 and ORA-27072 Errors

From: roblop <roblop_at_friko2.onet.pl>
Date: 2000/04/20
Message-ID: <ZCwL4.20867$hK2.411726@news.tpnet.pl>#1/1

I'm not sure but I think that you have damage tablespace. What to do? Recover that.

Roblop

Yes napisa³(a) w wiadomoœci: <38FDE566.365C1DDC_at_ibm.net>...
>Running Oracle 8.0.5.2 on Solaris 2.7
>
>When performing a full export of the database last night, I received the
>following error:
>
>EXP-00056: ORACLE error 1115 encountered
>ORA-01115: IO error reading block from file 12 (block # 262144)
>ORA-01110: data file 12: '/apps/ora_disk04/PROD/prod04.dbf'
>ORA-27072: skgfdisp: I/O error
>SVR4 Error: 25: Inappropriate ioctl for device
>Additional information: 262143
>
>I did my research, and have yet to find the reason for this error.
>I also tried to run the dbv program against the hotbackup of this
>particular datafile, but because it's 2 Gigs in size this utility does
>not seem to work...
>Always get DBV-00100: Specified FILE <> not accessible (and I recieve
>this error for any file that's 2GB in size).
>
>TIA for any help
>
>
Received on Thu Apr 20 2000 - 00:00:00 CDT