Re: RE: DBMS_REPAIR Package

From: <rgaffuri_at_cox.net>
Date: Thu, 17 Jul 2003 10:02:58 -0400
Message-Id: <25946.338253@fatcity.com>

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 <Ronald.Stefick_at_RANDOLPH.AF.MIL>
> Date: 2003/07/17 Thu AM 10:39:24 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> 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_at_randolph.af.mil
> 210-565-2540
>
>
>
>
>

------=____1058450578945_Ey_J3u_Ei8
Content-Type: text/html;

name="reply"
Content-Disposition: inline;

filename="reply"

<!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>
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.

<P><FONT size=2></FONT>&nbsp;</P>
<P>&nbsp;</P></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">

<DIV></DIV>
 <DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>-----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 </DIV>
 <DIV>
 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.

  <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  210-565-2540 </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px"> <DIV></DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML> Received on Thu Jul 17 2003 - 09:02:58 CDT