Corrupted datafile

From: <diaboliko_at_my-deja.com>
Date: Tue, 26 Sep 2000 14:29:54 GMT
Message-ID: <8qqbs6$leg$1@nnrp1.deja.com>

Hi all;

We have a problem on our oracle database. the following query produced an error (see below):

select * from q_biauto_deb_suspwhere (substr(bi_data_record,63,6)) ='028975'

ERROR:
ORA-01578: ORACLE data block corrupted (file # 5, block # 53047) ORA-01110: data file 5: '/db01/data/PROD/users_1.dbf'

Can this be recovered without restoring the entire database? We back up nightly after shutting down the database. We do not run in archivelogmode and cannot afford loss of data.

rgds
Dean

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Sep 26 2000 - 09:29:54 CDT