RE: Oracle's "dbv" : how frequently do you use it ?

Sorry to disagree with Peter but I run it everyday on our production backup mirror set. This mirror set is split off, then mounted on our failover/reporting server to write to tape. There is plenty of idle time on this servers so I run DBVerify against all of the datafiles. That way I know if the database was good when it went to tape. It also helps impel Operations to replace bad disks in a more timely fashion ;)

Mike Hand
Polaroid Corp

-----Original Message-----
Sent: Thursday, May 08, 2003 1:12 PM
To: Multiple recipients of list ORACLE-L

Hemant

To my knowledge dba's don't run dbv except when there have had some problems
with the disk system or the database has reported some problems ! There are one exception I have met and this Oracle dba that run dbv on standby databases or on year or month backup's just in case.

The store within Oracle was dbv was invented for the sales people to get a check mark when comparing database features agenst Sybase in the old days, since Sybase dba's had to run a utility every week to verify indexes for curroption and the new customers could not accept that this was not needed on the Oracle database :-)

Hemant K Chitale wrote:

>Yesterday, there was a server crash when the storage
>went "offline" at my site. The engineers were able
>to bring the storage back after a few hours and then
>ran "fsck" on the uFS file systems.
>I then started up the Oracle Database.
>Out of curiosity, I ran "dbv" on all the datafiles
>[online with the database open]. Only one page
>[an Index block] was reported as "Failing". I then
>rebuilt the Index [it was recreated to a different
>location]. Rerunning dbv I still saw the same
>error on the same block. As this block was now in
>a free extent, I wasn't concerned -- a new extent
>allocation would format the block when required.
>
>So now I am curious. How frequently do people run
>"dbv" ? Only after crash recovery OR Regularly
>on Open Databases ?
>I am thinking of setting up jobs to run "dbv" on
>critical databases regularly but would like to look
>for field experiences.
>
>Hemant K Chitale
>http://hkchital.tripod.com
>
>

-- 
Peter Gram, Miracle A/S
Phone : +45 2527 7107, Fax : +45 4466 8856
mailto:peter.gram@MiracleAS.dk - http://MiracleAS.dk



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hand, Michael T
  INET: HANDM_at_polaroid.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).