Re: Oracle Corrupted file

First off, take a full cold backup of everything you've got (if you haven't already). Then take a full export. If you get the export to work OK (you say the bad blocks aren't used) then at least you have one rebuild option - which is better than nothing. :-)

If you've been running in archivelog mode and you've remembered to save your archive logs, look at doing a complete recovery (database, tablespace or datafile - your choice depending on the damage/up-time requirements).

If you haven't then it looks like the IMP/EXP is the way to go. Might also be worth running some OS utils across you're drives to see why you have bad blocks in the first place - bad disk? If so, you might be looking at a restore/import anyway. No good making a short-term fix of a few blocks if it's all going to fall apart next week...

MotoX.

broder_at_my-dejanews.com wrote in message <6uta9n$a2r$1_at_nnrp1.dejanews.com>...
>I have repaired some database corruptions - however dbv still shows
>some file corruptions even though the blocks with the file are marked
>as free space. We are worried that Oracle might try to reuse these
>free blocks and end up corrupting another table. We plan to try and
>reduce the chances of this happening by using up the free block around
>the corrupted block by dummy tables - the alternative would be a
>lengthy export/import of the affected tablespaces.
>
>Any ideas ??
>
>Cheers !
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
Received on Tue Oct 06 1998 - 10:57:14 CDT