Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to remove corrupted blocks from datafile.
Hi Uday,
I don't know in which version dbv is stable; but, I know dbv was very buggy product. I recommend:
New table will not contain corrupted block.
Following event should be used if blocks are accessed through index: event="10233 trace name context forever, level 10"
udaycb wrote:
> 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
>
> ------------------------------------------------------------------------
> Name: winmail.dat
> winmail.dat Type: DAT Dosyası
>(application/x-unknown-content-type-dat_auto_file)
> Encoding: 7bit
-- Web: http://www.unal-bilisim.com ********* Questions and Answers: http://www.unal-bilisim.com/qa/discus/ ********* itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. ********* iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. ********* -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: danisment.unal_at_unal-bilisim.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 Wed Jun 06 2001 - 06:20:44 CDT