Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to remove corrupted blocks from datafile.

Re: How to remove corrupted blocks from datafile.

From: <Diana_Duncan_at_ttpartners.com>
Date: Tue, 05 Jun 2001 17:43:55 -0700
Message-ID: <F001.0031D2C7.20010605171023@fatcity.com>

When this has happened to me in the past, I've done exactly as you did, but in addition I renamed the table with the bad blocks to something like BAD_<table>, and just left it there. That way, the blocks weren't reused. Not elegant, but it worked...

Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC 27560
VM: 919.466.7337 x 316
F: 919.466.7427
E: Diana_Duncan_at_ttpartners.com

                                                                                       
                            
                    "udaycb"                                                           
                            
                    <udaycb_at_trwas        To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>       
                    p.com>               cc:                                           
                            
                    Sent by:             Fax to:                                       
                            
                    root_at_fatcity.        Subject:     How to remove corrupted blocks 
from datafile.                
                    com                                                                
                            
                                                                                       
                            
                                                                                       
                            
                    06/05/2001                                                         
                            
                    04:42 PM                                                           
                            
                    Please                                                             
                            
                    respond to                                                         
                            
                    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

(See attached file: winmail.dat)


Received on Tue Jun 05 2001 - 19:43:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US