Re: ORA-ERR

Steven,

This would seem to be ahardware problem. The last error indicates HP/UX detected an i/o error (the lines above tell you its a read error in data file 17 (system.dbf).

Do you have regular backups? Do you save the redo logs to tape or disk? Restore/recovery may be the quickest choice. If you get the error reading DBA tables and views, and not when reading other datafiles, then you really know the answer.

John

Steven wrote:

> I got all four ORA errors while using sqlplus for system check:
>
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01115: IO error reading block from file 17 (block #)
> ORA-01110: data file 17: '/disk5/system.dbf'
> ORA-07372: sfrfb: read error, unable to read requested block from
> database file
> HP-UX error: 5: i/o error
>
> Select from datafile instead of dba stuff is OK without the above
> messages.
> I do not find any OS i/o error.
> If system datafile is corrupted, that will be a major reinstallation.
>
> Any thought and HELP!?
>
Received on Fri Aug 21 1998 - 12:53:32 CDT