Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: bad data file

Re: bad data file

From: ed zappulla <zappullae_at_rcn.com>
Date: Fri, 23 Nov 2001 08:44:02 -0500
Message-ID: <9tljmg$93q$1@bob.news.rcn.net>


looks like the blocks were all allocated to a single large table. I truncated the table and imported from a previous export. its reatvily static data. i was then able to export the entier db. we will chuck the disk out now.

"Adrian Carlson-Hedges" <adrian.ch_at_btinternet.com> wrote in message news:9tjl68$f5v$1_at_uranium.btinternet.com...
> Are you running in archive log mode? Do you have a (recent) backup of the
> database?
>
> If yes, and yes, you should be able to get to where you were before the
> error occurred, by simply shutting down the database, copying across the
> backup of that file, restarting the database and recovering it. (This is a
> gross simplification, with lots of steps missing)
>
> If not I seem to remember it's possible to tell Oracle to ignore certain
> 'bad' blocks. Of course this might well leave a hole in your data.Off the
> top of my head I can't remember how, but I don't think all is lost.
>
> Adrian
>
> "ed zappulla" <zappullae_at_rcn.com> wrote in message
> news:9tivpv$ap$1_at_bob.news.rcn.net...
> > I'm getting the following errors. can it be fixed?
> >
> > ora 8.1.6, win2k pro
> >
> > EXP-00056: ORACLE error 1115 encountered
> > ORA-01115: IO error reading block from file 3 (block # 94834)
> > ORA-01110: data file 3: 'C:\ORA81\ORADATA\ORACLE\USERS01.DBF'
> > ORA-27091: skgfqio: unable to queue I/O
> > OSD-04006: ReadFile() failure, unable to read from file
> > O/S-Error: (OS 23) Data error (cyclic redundancy check).
> >
> >
> >
>
>
Received on Fri Nov 23 2001 - 07:44:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US