Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle's "dbv" : how frequently do you use it ?

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

From: Peter Gram <>
Date: Thu, 08 May 2003 09:12:11 -0800
Message-ID: <>


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

Peter Gram, Miracle A/S
Phone : +45 2527 7107, Fax : +45 4466 8856 -

Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii" Content-Transfer-Encoding: 7bit The previous attachment was filtered out by the ListGuru mailing software at because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact for clarification. --------------ms050004070902040707030409-- -- Please see the official ORACLE-L FAQ: -- Author: Peter Gram INET: Fat City Network Services -- 858-538-5051 San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: (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).

  • application/x-pkcs7-signature attachment: smime.p7s
Received on Thu May 08 2003 - 12:12:11 CDT

Original text of this message