Message-Id: <25946.338247@fatcity.com> From: Stefick Ronald S Contr ESC/HRIDD Date: Thu, 17 Jul 2003 08:39:10 -0500 Subject: RE: DBMS_REPAIR Package This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C34C68.CD43E088 Content-Type: text/plain I dug a little more and found my answer. I found that Oracle uses DBMS_REPAIR just to put a band-aid on the corrupt blocks. It basically identifies the corrupt block and marks it so oracle skips over it like it's not even there. -----Original Message----- From: Stefick Ronald S Contr ESC/HRIDD Sent: Thursday, July 17, 2003 8:55 AM To: Multiple recipients of list ORACLE-L Subject: DBMS_REPAIR Package Has anyone ever used DBMS_REPAIR? If so, what do you think of it, does the DB have to be shutdown to run it. Does it really fix any corrupt blocks in the datafiles? We ran DBVerify and found several corrupt DB files in one of our DB's. TIA, Scott Stefick MILPDS OCP Oracle DBA scott.stefick@randolph.af.mil 210-565-2540 ------_=_NextPart_001_01C34C68.CD43E088 Content-Type: text/html Message

I dug a little more and found my answer.  I found that Oracle uses DBMS_REPAIR just to put a band-aid on the corrupt blocks. It basically identifies the corrupt block and marks it so oracle skips over it like it's not even there.

 

 

-----Original Message-----
From: Stefick Ronald S Contr ESC/HRIDD
Sent: Thursday, July 17, 2003 8:55 AM
To: Multiple recipients of list ORACLE-L
Subject: DBMS_REPAIR Package

Has anyone ever used DBMS_REPAIR? If so, what do you think of it, does the DB have to be shutdown to run it. Does it really fix any corrupt blocks in the datafiles?  We ran DBVerify and found several corrupt DB files in one of our DB's.

 

TIA,

Scott Stefick
MILPDS OCP Oracle DBA
scott.stefick@randolph.af.mil 
210-565-2540