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:
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, [EMAIL PROTECTED] 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) [EMAIL PROTECTED] Jeremiah Wilton <[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L y.net> <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] 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: [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).
