Quickie script to run dbv on your database...
Submitted by dmann on Fri, 01/22/2010 - 11:49
This script will generate dbv commands into a shell script and then execute the shell script. run-dbv.sql:
set head off set lines 200 set feedback off set define off spool dbv.sh select 'dbv file='||name||' blocksize = '||block_size|| ' LOGFILE=FILE-'||FILE#||'.LOG' from v$datafile; spool off host chmod 755 dbv.sh spool dbv_results.log host ./dbv.sh spool offOutput will be created as separate log files. You can run it and review results like this:
$ sqlplus "/ as sysdba" @run-dbv.sql ... application output will scroll by... $ grep Corrupt *.LOG