Quickie script to run dbv on your database...
Submitted by dave 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 off
Output 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
Add new comment