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

Home -> Community -> Mailing Lists -> Oracle-L -> DBMS_REPAIR Package

DBMS_REPAIR Package

From: Stefick Ronald S Contr ESC/HRIDD <Ronald.Stefick_at_RANDOLPH.AF.MIL>
Date: Thu, 17 Jul 2003 07:56:04 -0500
Message-Id: <25946.338241@fatcity.com>


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_01C34C62.C85BEB55
Content-Type: text/plain

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

------_=_NextPart_001_01C34C62.C85BEB55
Content-Type: text/html

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>

<META content="MSHTML 5.50.4926.2500" name=GENERATOR></HEAD>
<BODY>
<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?&nbsp;<SPAN class=030084212-17072003>
</SPAN><SPAN class=030084212-17072003>We ran DBVerify
and</SPAN>&nbsp;found&nbsp;<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>scott.stefick_at_randolph.af.mil</FONT></SPAN>&nbsp;<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></BODY></HTML> Received on Thu Jul 17 2003 - 07:56:04 CDT

Original text of this message

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