Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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_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> <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> </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> <BR><SPAN lang=en-us><FONT face=Arial><FONT size=2><SPANclass=030084212-17072003>210-</SPAN>565-2540</FONT></FONT></SPAN>