Oracle-L: Re: DBV

From: <JApplewhite_at_austin.isd.tenet.edu>
Date: Wed, 26 Feb 2003 13:18:44 -0800
Message-ID: <F001.0055A85F.20030226131844@fatcity.com>

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: 
  INET: JApplewhite_at_austin.isd.tenet.edu

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

Received on Wed Feb 26 2003 - 15:18:44 CST