Re: Oracle 8.1.7.1 crashed on Win2K

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 16 Oct 2001 15:56:47 +0100
Message-ID: <3bcc4ac7$0$233$ed9e5944@reading.news.pipex.net>

My German (which doesn't begin to match your English) suggests that the datafile

'C:\ORACLE\ORADATA\SW\DATEN.DBF' is corrupt. You can verify this using dbverify. If it is corrupt I would definitely recommend checking the disk out. Once you are satisfied that the disk is Ok and assuming you are in archivelog you should be able to recover the situation by shutting down the database, restoring a backup copy of the datafile and then issuing the following

startup mount;
recover database;
alter database open;

regards

--
Niall Litchfield
Oracle DBA
Audit Commission UK

"Nicolas Bronke" <nb_at_trinity.de> wrote in message
news:9qh7e3$42q$05$1_at_news.t-online.com...


> Suddenly, I got following errors

>

> FEHLER in Zeile 1:

> ORA-01115: EA-Fehler beim Lesen von Block aus Datei 3 (Block Nr. 923)

> ORA-01110: Datendatei 3: 'C:\ORACLE\ORADATA\SW\DATEN.DBF'

> ORA-27091: skgfqio: E/A kann nicht in Warteschlange gestellt werden

> OSD-04006: ReadFile()-Fehler, Lesen aus Datei nicht möglich

> O/S-Error: (OS 1117) Die Anforderung konnte wegen eines E/A-Gerätefehlers

> nicht

> ausgeführt werden.

>

> Does that mean a truly disk error or is there a problem with the databas?

>

> The database is Oracle 8.1.7 with patch 8.1.7.1.1 on Win2K

>

> Thanks for recommendations.

>

> Nicolas

>

>

Received on Tue Oct 16 2001 - 09:56:47 CDT