| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_randolph.af.mil
210-565-2540
------_=_NextPart_001_01C34C68.CD43E088
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><SPAN class=368073613-17072003>I dug a little more and found my
answer. </SPAN><SPAN class=368073613-17072003>I found</SPAN> 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.</FONT></P>
<P><FONT size=2></FONT> </P>
<P> </P></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Stefick Ronald S
Contr ESC/HRIDD <BR><B>Sent:</B> Thursday, July 17, 2003 8:55 AM<BR><B>To:</B>
Multiple recipients of list ORACLE-L<BR><B>Subject:</B> DBMS_REPAIR
Package<BR><BR></FONT></DIV>
<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
 |
 |