| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: DBV
I have used DBV repeatedly and heavily on a variety of platforms from
version 7.3.2 on. ALthough it has always been called an "Offline
Verification Utility," that has never meant that it cannot be used on
open datafiles. It just means it is not a utility that connects to
the database.
DBV has never done anything to datafiles but read. So unless Jack had an OS that writes when you ask it to read, there's no way that DBV could have done anything bad to your database.
The 7.3 docs are hilarious. Offline or online????
> DB_VERIFY is an external command-line utility that performs a
> physical data structure integrity check on an offline database. It
> can be used against backup files and online files (or pieces of
> files). You use DB_VERIFY primarily when you need to insure that a
> backup database (or datafile) is valid before it is restored or as a
> diagnostic aid when you have encountered data corruption problems.
-- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 26 Feb 2003, Daniel W. Fink wrote:Received on Wed Feb 26 2003 - 18:34:49 CST
> 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: Jeremiah Wilton INET: jwilton_at_speakeasy.net 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).
 |
 |