Re: Corrupted datafile

From: <pollachi_at_my-deja.com>
Date: Tue, 26 Sep 2000 15:53:21 GMT
Message-ID: <8qqgpd$1to$1@nnrp1.deja.com>

In article <8qqbs6$leg$1_at_nnrp1.deja.com>, diaboliko_at_my-deja.com wrote:
> 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.
>

Sorry, you have to go back to your backup from last night. If you cannot afford data loss, you should be running in archivelogmode.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Sep 26 2000 - 10:53:21 CDT