>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
[EMAIL PROTECTED] 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) [EMAIL PROTECTED] "Daniel W. Fink" <[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L .com> <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
