Re: RE: DBMS_REPAIR Package

[rgaffuri]

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 <[EMAIL PROTECTED]>
> Date: 2003/07/17 Thu AM 10:39:24 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> 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 
> [EMAIL PROTECTED] 
> 210-565-2540 
> 
> 
> 
> 
> 

Title: Message

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 
[EMAIL PROTECTED] 
210-565-2540