Re[2]: DBV

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:breno_at_mercantilsoares.com.br
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

>> 

>> 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: Breno A. K. Magnago
  INET: breno_at_mercantilsoares.com.br

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