I ran it. No problem. (Windows 2000 / Oracle 9i) Thanks for all.
More information : The problem, four datafile contains corrupt block. (two indexes and two tables). One table I used the package DBMS_REPAIR and made a export, with DIRECT=Y (without it an error happened) and them I imported this table. I lost only 8 rows with this procedure. For the other table I will make the same. About the index, I will recreate it. My online backup is corrupted too. -- Breno A. K. Magnago mailto:[EMAIL PROTECTED] Mercantil de Alimentos Soares Wednesday, February 26, 2003, 9:34:49 PM, you wrote: JW> I have used DBV repeatedly and heavily on a variety of platforms from JW> version 7.3.2 on. ALthough it has always been called an "Offline JW> Verification Utility," that has never meant that it cannot be used on JW> open datafiles. It just means it is not a utility that connects to JW> the database. JW> DBV has never done anything to datafiles but read. So unless Jack had JW> an OS that writes when you ask it to read, there's no way that DBV JW> could have done anything bad to your database. JW> 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. JW> -- JW> Jeremiah Wilton JW> http://www.speakeasy.net/~jwilton JW> On Wed, 26 Feb 2003, Daniel W. Fink wrote: >> 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 >> >> [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] >> > >> > >> > >> > >> > >> > >> > >> >> -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Breno A. K. Magnago INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
