RE: DBMS_REPAIR Package

If you ran dbverify with the database up, it's very likely that there is nothing wrong with the datafiles.

If dbv reads a block in transition, it will appear corrupt.

Run it again, and there will either be no errors, or they will appear to be in different blocks.

Personally, I think it a colossal waste of time to run dbverify.

In 9 years of DBA'ing, I've experienced maybe 3 or 4 instances of a corrupt block, and it was always an index. The solution was to drop/rebuild the index.

Jared

Stefick Ronald S Contr ESC/HRIDD <Ronald.Stefick_at_RANDOLPH.AF.MIL> Sent by: ml-errors_at_fatcity.com
 07/17/2003 07:39 AM
 Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        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-----
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 Received on Thu Jul 17 2003 - 12:31:41 CDT