Re: DBV

I had a scheduled job that ran dbv on Solaris 8.0.4 databases once a week. Never a problem. It has been awhile since I used it on Windows, and I don't recall using it on 7.3 (not that I did not, but my memory is starting to go...). I have never had a problem with it, either with the db up or down.
 From the 8i Data Server Internals (which I have found accurate) "DBVERIFY Utility...Opens data files read-only; can run while the database is open."

dbverify was introduced in 7.3, so you could have encountered a bug. It is definitely a good idea to try it out first on a test database.

Dan Fink

JApplewhite_at_austin.isd.tenet.edu wrote:

>Dan,
>
>That must be new for 9i, since my 8.1.7 docs say it is an "offline"
>utility. I remember hosing an entire 7.3 test database years ago when I
>first ran DBV on it while it was up and open - can't remember the errors,
>but the DB was unusable. One of the (too) many times I learned to read the
>docs more carefully. :-(
>
>Jack C. Applewhite
>Database Administrator
>Austin Independent School District
>Austin, Texas
>512.414.9715 (wk)
>512.935.5929 (pager)
>JApplewhite_at_austin.isd.tenet.edu
>
>
>
>
> "Daniel W. Fink"
> <optimaldba_at_yahoo To: Multiple recipients of list ORACLE-L
> .com> <ORACLE-L_at_fatcity.com>
> Sent by: cc:
> root_at_fatcity.com Subject: Re: DBV
>
>
> 02/26/2003 01:54
> PM
> Please respond to
> ORACLE-L
>
>
>
>
>
>
>Yes, you can. It may report that a block is influx if the block is being
>written while dbv is looking at it. If you encounter this error, run it
>again. If it does not report the same block, you are in the clear.
>As with any i/o intensive process, run it off-hours.
>
>Dan Fink
>
>Breno A. K. Magnago wrote:
>
>
>
>>Hi,
>>Can I use the program DBV on a production datafile (read and write),
>>without take offline the tablespace ?
>>
>>
>>
>
>--
>Author: Daniel W. Fink
> INET: optimaldba_at_yahoo.com
>
>
>
>
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Daniel W. Fink
  INET: optimaldba_at_yahoo.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).