Re: bad data file

From: Adrian Carlson-Hedges <adrian.ch_at_btinternet.com>
Date: Thu, 22 Nov 2001 19:54:30 -0000
Message-ID: <9tjl68$f5v$1@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 Thu Nov 22 2001 - 13:54:30 CST