Re: Corrupted datafile

The only option you have is restoring the last night backup because you don't run in archivelog. You can't restore the affected, as that would force the database in recovery.

This is just the way it is, and nothing can be done about it, the Oracle documentation and many Oracle books are clear enough about this issue.

Sorry,

Sybrand Bakker, Oracle DBA

<diaboliko_at_my-deja.com> wrote in message news:8qqbs6$leg$1_at_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 - 10:45:56 CDT