Re: bad data file

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Fri, 23 Nov 2001 05:51:36 +1100
Message-ID: <3bfd48b6$0$13481$afc38c87@news.optusnet.com.au>

Use the 8i dbms_repair package to mark that block as skippable. You lose whatever is in it, and since it's block 3 that might be a bit of a worry (it might be the head of a free list, or part of a tablespace's extent allocation bitmap, for example, being that far towards the head of the file).

The alternative, of course, is to blow the file away, restore from a backup, and perform a complete recovery.

Regards
HJR

--
Resources for Oracle: http://www.hjrdba.com
===============================


"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 - 12:51:36 CST