Re: Database recovery.

From: Vrajesh Patel <vrajesh_p_at_hotmail.com>
Date: Mon, 26 Jul 1999 15:44:48 GMT
Message-ID: <Qn%m3.385$%L2.63039@PM01NEWS>

Best way is to restore the datafile from backup and recover. But, your database should be in archive mode.

If not, find out the segment which is corrupted and if it is non-datadictionary drop and recreate it. and it is table or important one, use latest export file to restore it.

Go to Oracle support site to have document on this. As I had same problem before and resolved thru it.

Thanks,

--
Vrajesh Patel
Champion is not one who never fails, but one who NEVER QUITS !

Bertrand LEFEBVRE <blefebvre_at_dial.oleane.com> wrote in message news:379C71BD.AEDE0D19_at_dial.oleane.com...
: I'm using Oracle 8.0.5 for Linux. I'm really stucked because of a error
: wich had occured last friday. The error is the folowing when I'm doing
: delete from CLI ;
: 'ORA-01578: ORACLE data block corrupted (file #1, block # 19895)'
: 'ORA-01110: data file 1 : '/u2/oradata/BAR/system01.dbf' '
:
: And then I can't do anything. Has anybody got an idea it really would
: help !!
:
Received on Mon Jul 26 1999 - 10:44:48 CDT