Message-Id: <25946.338253@fatcity.com> From: Date: Thu, 17 Jul 2003 10:02:58 -0400 Subject: Re: RE: DBMS_REPAIR Package This is a multi-part message in MIME format. ------=____1058450578945_Ey_J3u_Ei8 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit are there any practical uses for dbms_repair? or is it just a stop gap measure to use if your not able to do a recovery at that time? > > From: Stefick Ronald S Contr ESC/HRIDD > Date: 2003/07/17 Thu AM 10:39:24 EDT > To: Multiple recipients of list ORACLE-L > Subject: RE: DBMS_REPAIR Package > > 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----- > Sent: Thursday, July 17, 2003 8:55 AM > To: Multiple recipients of list ORACLE-L > > > > 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 > > > > > ------=____1058450578945_Ey_J3u_Ei8 Content-Type: text/html; name="reply" Content-Disposition: inline; filename="reply" 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