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 <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/17/2003 07:39 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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-----
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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
