RE: quckways to find block corruption

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
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM]
> 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: Rich.Jesse_at_qtiworld.com

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: ListGuru_at_fatcity.com (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).