Re: Urgent: System tablespace corruption

On Sun, 24 Sep 2000 9:01:08 +0200, Amol wrote (in message <8qk8rg$rgb$1_at_nnrp1.deja.com>):

> Oracle gurus,
>
> I have oracle 7.3.4 and the problem I am facing is block corruption in
> system tablespace. I cannot restore it from any of the backups as the
> corruption exists in all the backups of the DB. I did verify this using
> the tool "dbv". Please suggest if in any way the corruption can be
> removed without loss of any data.
>
> Can I use the export utility for the above problem? What would be the
> implication if I change the parameter DB_BLOCK_CHECKSUM to false? Will
> it solve this problem? Also suggest how to find which table/index is
> corrupt from the system datafile. This is very urgent and your
> suggestions will be very much appreciated.

You could try to do a full export and import in in a fresh created database. Without a valid backup you don't have much chance to do something else. If you know EXACTLY what you do you could use dd to manipulate the blocks but I don't think this is the case and I really can't recommend this to you. (oracle does not support it too).

-- 
Ronald

certified oracle dba/ unix sa
http://home.wxs.nl/~ronr/professional.html