| 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
One of the issues with dbv is that is assumes that you use a 2k block
size. In addition, you will want to ignore files for temporary tablespaces.
I use the following code to create a shell script to run the dbverify
commands. Incorporate this code into a wrapper script and run it
periodically.
set pages 0 feedback off termout off lines 200
spool $ORAMON_HOME/bin/dbverify.ksh
select 'dbv file='||f.name||' blocksize='||p.value||' logfile=dbverify.out'
from v$datafile f,
v$parameter p
where p.name = 'db_block_size';
spool off
-- Daniel W. Fink http://www.optimaldba.com RMOUG Training Days March 5 & 6, 2003 Denver, CO IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Jeremiah Wilton wrote:Received on Thu Feb 27 2003 - 16:59:14 CST
>In Unix, maybe something like this?
>
>for X in *.dbf
> do
> dbv file="$X" &
> done
>
>Add logfiles, paths, etc. as you wish. I suppose something similar
>must be possible in batch scripting for windows. Then again maybe
>not!
>
>--
>Jeremiah Wilton
>http://www.speakeasy.net/~jwilton
>
>On Thu, 27 Feb 2003, JApplewhite_at_austin.isd.tenet.edu wrote:
>
>
>
>>Jeremiah,
>>
>>Perhaps the fact that my experience was with Personal Oracle 7.3.2.3 on
>>Win95 explains the hosed database - Win95 not being the best platform, to
>>say the least.
>>
>>I'll definitely try it again - on a test database, of course.
>>
>>BTW, I can't find any way to tell DBV to verify more than one datafile at a
>>time. Is there?
>>
>>Thanks.
>>
>>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
>>
>>
>>
>>
>> Jeremiah Wilton
>> <jwilton_at_speakeas To: Multiple recipients of list ORACLE-L
>> y.net> <ORACLE-L_at_fatcity.com>
>> Sent by: cc:
>> root_at_fatcity.com Subject: Re: DBV
>>
>>
>> 02/26/2003 06:34
>> PM
>> Please respond to
>> ORACLE-L
>>
>>
>>
>>
>>...
>>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.
>>...
>>
>>--
>>Jeremiah Wilton
>>http://www.speakeasy.net/~jwilton
>>
>>
>>
>>
>>
>>--
>>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).
>>
>>
>>
>>
>
>
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel W. Fink INET: optimaldba_at_yahoo.com 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).
 |
 |