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

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






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 fatcity.com 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 Postmaster_at_fatcity.com for clarification.

--------------ms050004070902040707030409--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Peter Gram
  INET: peter.gram_at_miracleas.dk

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).



application/x-pkcs7-signature attachment: smime.p7s