Re: DBMS_REPAIR Package

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 17 Jul 2003 23:44:15 +1000
Message-Id: <25946.338248@fatcity.com>

This is a multi-part message in MIME format.

--Boundary_(ID_N5+TYipBc1KjNljWRvYsDg)
Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: 7BIT

MessageHi Stefick,

Running stored procedures/packages is somewhat difficult with a shutdown database, so the database needs to be opened.

Depending on the type of corrupted block in question answers whether or not the block is actually repaired (eg. bitmap block in ASSM segments, freelist blocks...) or simply marked as corrupt and thus could be made "skippable" meaning that your FTS will now work and skip the stuffed buggers.

That said, I would recommend restoring you stuffed datafile, perform a database recovery and hope the corruption wasn't duplicated in your backup(s). dbms_repair should be used if all else fails (or you don't really mind losing that "bit" of your database).

Good Luck

Richard Foote

Original Message ----- From: Stefick Ronald S Contr ESC/HRIDD To: Multiple recipients of list ORACLE-L Sent: Thursday, July 17, 2003 11:54 PM 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_at_randolph.af.mil
  210-565-2540

--Boundary_(ID_N5+TYipBc1KjNljWRvYsDg)
Content-type: text/html; charset=iso-8859-1 Content-transfer-encoding: 7BIT

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2723.2500" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi Stefick,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Running stored procedures/packages is somewhat
difficult with a shutdown database, so the database needs to be opened.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Depending on the type of corrupted block in
question answers whether or not the block is actually repaired (eg. bitmap block in ASSM segments, freelist blocks...) or simply marked as corrupt and thus could be made "skippable" meaning that your FTS will now work and skip the stuffed buggers.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>That said, I would recommend restoring you stuffed
datafile, perform a database recovery and hope the corruption wasn't duplicated in your backup(s). dbms_repair should be used if all else fails (or you don't really mind losing that "bit" of your database).</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Good Luck</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Richard Foote</FONT></DIV>
<BLOCKQUOTE dir=ltr

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">   <DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>   <DIV
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>   <A title=Ronald.Stefick_at_RANDOLPH.AF.MIL   href="mailto:Ronald.Stefick_at_RANDOLPH.AF.MIL">Stefick Ronald S Contr   ESC/HRIDD</A> </DIV>
  <DIV style="FONT: 10pt arial"><B>To:</B> <A title=ORACLE-L_at_fatcity.com   href="mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list ORACLE-L</A>   </DIV>
  <DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, July 17, 2003 11:54   PM</DIV>

  <DIV style="FONT: 10pt arial"><B>Subject:</B> DBMS_REPAIR Package</DIV>
  <DIV><BR></DIV>
  <DIV>
  <P><FONT size=2>Ha<SPAN class=030084212-17072003>s</SPAN>&nbsp;<SPAN

class=030084212-17072003>anyone</SPAN> 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? <SPAN class=030084212-17072003> </SPAN><SPAN class=030084212-17072003>We ran DBVerify and</SPAN> found <SPAN class=030084212-17072003>several</SPAN> corrupt DB files in one of our DB's. </FONT></P>

  <P><FONT size=2></FONT>&nbsp;</P>
  <P><SPAN class=030084212-17072003><FONT size=2>TIA,</FONT></SPAN></P>
  <P><SPAN class=030084212-17072003><SPAN lang=en-us><FONT 
  face="Monotype Corsiva">Scott Stefick</FONT></SPAN> <BR><SPAN lang=en-us><FONT 
  face=Arial size=2>MILPDS OCP Oracle DBA</FONT></SPAN> <BR><SPAN 
  lang=en-us><FONT face=Arial size=2><A

href="mailto:scott.stefick_at_randolph.af.mil">scott.stefick_at_randolph.af.mil</A></FONT></SPAN> <BR><SPAN lang=en-us><FONT face=Arial><FONT size=2><SPAN class=030084212-17072003>210-</SPAN>565-2540</FONT></FONT></SPAN> </P></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px"> <DIV><FONT face=Tahoma
size=2></FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML> Received on Thu Jul 17 2003 - 08:44:15 CDT