RE: How to remove corrupted blocks from datafile.

From: Kevin Lange <kgel_at_ppoone.com>
Date: Tue, 05 Jun 2001 14:01:52 -0700
Message-ID: <F001.0031CEB5.20010605135525@fatcity.com>

This is always an ugly problem. And I am sure there are utilities to take care of these things.... but for those of use who have to do things by the manual method, this is what we ended up doing.

Do a select of the row_ids on the table in row_id order. When we found a row_id bad record we then recorded this and then proceeded with a select where the rowid_was greater than that one. Sometimes we had to try a few IDs away from the bad one because they were all in bad blocks.
When the row_id select was done we then did a create to a temp table based on the row_ids that were good from the bad table.

In this manner we new exactly the count of bad records based on how many row_ids we skipped.

It was a very long weekend because this was a very large table we went thru. But it worked out in the end.

-----Original Message-----
Sent: Tuesday, June 05, 2001 3:43 PM
To: Multiple recipients of list ORACLE-L

Hi,
I found some corrupted blocks in one of the datafile. I have created the temp table by select all the records (excluding the records in corrupted blocks) from corrupted table, and dropped the table, renamed the temp table back to original. After this when i run DBV on that file, it still shows there are some corrupted blocks in the file. i have two questions,

1> How do i calculate how many records i have lost? 2> How do i remove corrupted blocks from the blocks?

Can anyone tell me ...
Thanks in advance
Uday

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Kevin Lange
INET: kgel_at_ppoone.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Jun 05 2001 - 16:01:52 CDT