[20150612]使用bvi查看数据块.txt
--编写一个简单的脚本实现bvi查看数据块，主要我现在喜欢使用bbed查看，而修改选择bvi。
--通过例子来说明：
SCOTT@test> select rowid,dept.* from dept ;
ROWID DEPTNO DNAME LOC
------------------ ------------ -------------- -------------
AABJVUAAEAAAAdzAAA 10 ACCOUNTING NEW YORK
AABJVUAAEAAAAdzAAB 20 RESEARCH DALLAS1
AABJVUAAEAAAAdzAAC 30 SALES CHICAGO
AABJVUAAEAAAAdzAAD 40 OPERATIONS BOSTON
AABJVUAAEAAAAd3AAA 50 MARKETING LONDON
SCOTT@test> @ lookup_rowid AABJVUAAEAAAAdzAAA
OBJECT FILE BLOCK ROW DBA TEXT
------------ ------------ ------------ ------------ -------------------- ----------------------------------------
300372 4 1907 0 4,1907 alter system dump datafile 4 block 1907
--如果通过bvi查看要先算偏移量,1907*block_size = 1907*8192=15622144.然后执行:
bvi -b 15622144 -s 8192 /u01/app/oracle11g/oradata/test/users01.dbf
$ cat bbvi.sql
column bvi_command format a90
select 'bvi -b '|| &2*BLOCK_SIZE||' -s '||block_size||' '||NAME bvi_command from v$datafile where file#=&1 ;
--顺便练习写一个shell脚本：
$ cat bbvi
#! /bin/bash
# convert bvi runnning format
# bbvi file# block#
# $1 = file# $2 = block#
if [ $# -ne 2 ] ; then
echo
echo "USAGE: $0 file# block#"
echo
exit 1;
fi
bvi_command=`sqlplus -S / as sysdba set pagesize 0 feedback off verify off heading off echo off
select 'bvi -b '|| \$2*BLOCK_SIZE ||' -s '||block_size||' '||NAME bvi_command from v\\$datafile where file#=\$1 ;
exit;
END`
if [ -z "$bvi_command" ]; then
echo "No rows returned from database"
exit 0
else
echo
read -p "press ctrl+c break, press return run .. $bvi_command "
echo
eval $bvi_command
fi
