A major down side of dbv is that it is strictly an offline tool. 'twould be nice to have a low-impact online version (like has been eluded to in this thread) to proactively check for corruption before it's effect is noticed.
But I suppose, like everything, that'll be in 10i. :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -----Original Message----- > From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 23, 2002 11:08 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: quckways to find block corruption > > > Srinivas > I think that as a minimum, to detect corruption you must > read all data > blocks. There are several methods, most involve an Oracle > process that will > error if a corrupt block is encountered. Export to /dev/null > was mentioned > already. I have used ANALYZE TABLE VALIDATE STRUCTURE > CASCADE, which will > also check out the indexes and verify they point to good > blocks, but is > quite resource intensive. If you use RMAN to back up your > database, then as > a bonus it always verifies your data blocks and will error out when it > encounters a bad block. > I haven't used dbv personally, but assume that dbv was one > of the most > efficient methods of checking your datafiles since it runs > outside Oracle > and therefore doesn't tie up your Oracle resources. Perhaps > you can spell > out the problems you are encountering with dbv and what you > are trying to > accomplish in more detail. > > Dennis Williams -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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).
