​[20231023]生成bbed的执行脚本(bash shell).txt

[20231023]生成bbed的执行脚本(bash shell).txt --//尝试使用bbed 恢复rename IDL_UB1$的情况,前面的准备分析时间很长,恢复很容易。但是每次做修复数据块的一致性时，我总是还要 --//查询我以前写的文档，特别浪费时间记不住一些细节。实际上主要写计算公式上，我想既然已经给出提示信息。通过外部命令计算很 --//容易生成bbed的执行脚本，自己尝试看看。 --//bbed执行verify后出现6110，6111错误，简单更正公式如下: --//code 6110 --//avsp = dtl-used-fsc --//code 6111 --//tosp = avsp+stb+fsc --//code=6110的情况： BBED> verify DBVERIFY - Verification starting FILE = /mnt/ramdisk/book/system01.dbf BLOCK = 243 Block Checking: DBA = 4194547, Block Type = KTB-managed data block data header at 0x8ec644 kdbchk: the amount of space used is not equal to block size         used=7298 fsc=66 avsp=822 dtl=8120 Block 243 failed with check code 6110 --//avsp = dtl-used-fsc --//avsp= 8120-7298-66 = 756 --//补充建议:我看有一些选择设置fsc=0,方法就是要修改对应事务itl的fsc值，要看行记录的lock，才知道那个事务的ITL。 --//这样可能avsp不需要修改。比如修改成如下： used=7298 fsc=0 avsp=822 dtl=8120 --//dtl-used-fsc 8120-7298-0 = 822. BBED> assign kdbh.kdbhavsp=756 sb2 kdbhavsp                                @78       756 --//code=6111的情况： BBED> verify DBVERIFY - Verification starting FILE = /mnt/ramdisk/book/system01.dbf BLOCK = 243 Block Checking: DBA = 4194547, Block Type = KTB-managed data block data header at 0x8ec644 kdbchk: space available on commit is incorrect         tosp=890 fsc=66 stb=0 avsp=756 Block 243 failed with check code 6111 --//tosp = avsp+stb+fsc --//tosp= 756+0+66  = 822 BBED> assign kdbh.kdbhtosp=822 sb2 kdbhtosp                                @80       822 --//建立脚本如下： $ cat bbed1011.sh #! /bin/bash # create bbed script ,resolve code 6110 and 6111 # argument1=dba a=$1 echo verify dba $a| rlbbed | grep "code 6110" > /dev/null if [ $? -eq 0 ] ; then #    echo verify dba $a | rlbbed | tr -d '\r' | grep "avsp" | sed -e "s/^\s*//;s/ /;/g;s/$/;dtl-used-fsc/"| bc -q | sed "s/^/ assign dba $a kdbh.kdbhavsp = /" echo verify dba $a | rlbbed | tr -d '\r' | grep "avsp" | sed -e "s/^\s*//;s/ /;/g;s/$/;dtl-used-fsc/" | bc -q | sed "s/^/ assign dba $a kdbh.kdbhavsp = /" fi echo verify dba $a| rlbbed | grep "code 6111" > /dev/null if [ $? -eq 0 ] ; then     echo verify dba $a | rlbbed | tr -d '\r' | grep "avsp" | sed -e "s/^\s*//;s/ /;/g;s/$/;avsp+stb+fsc/"| bc -q | sed "s/^/assign dba $a kdbh.kdbhtosp = /" fi --//感觉不需要调用这么多次bbed,再引入1个参数输出code代码,修改如下: $ cat bbed1011x.sh #! /bin/bash # create bbed script ,resolve code 6110 and 6111 # argument1=dba argument2=bbed code # if [$2 -eq 6110  ] ; then #     str1=";dtl-used-fsc" #     str2="kdbh.kdbhavsp" # fi # if [$2 -eq 6110  ] ; then #     str1=";avsp+stb+fsc" #     str2="kdbh.kdbhtosp" # fi a=$1 case $2 in     6110|10)         str1=";dtl-used-fsc"         str2="kdbh.kdbhavsp"         str3=6110         ;;     6111|11)         str1=";avsp+stb+fsc"         str2="kdbh.kdbhtosp"         str3=6111         ;; esac echo verify dba $a| rlbbed | tr -d '\r' | grep -B1 "code ${str3}$" | grep "avsp" | sed -e "s/^\s*//;s/ /;/g;s/$/${str1}/"| bc -q | sed "s/^/assign dba $a $str2 = /" #echo verify dba $a | rlbbed | grep -B1 "code ${str3}$" | grep "avsp" | sed -e "s/^\s*//;s/ /;/g;s/$/${str1}/"| bc -q | sed "s/^/ assign dba $a $str2 = /" #echo verify dba $a| rlbbed | grep -B1 "code 6110$" | grep "avsp" | sed -e "s/^\s*//;s/ /;/g;s/$/;dtl-used-fsc/"| bc -q | sed "s/^/ assign dba $a kdbh.kdbhavsp = /" #echo verify dba $a| rlbbed | grep -B1 "code 6111$" | grep "avsp" | sed -e "s/^\s*//;s/ /;/g;s/$/;avsp+stb+fsc/"| bc -q | sed "s/^/ assign dba $a kdbh.kdbhtosp = /" --//测试在cygwin ,过滤出来的内容有1个\r字符,要删除掉. --//测试看看: 1.环境: SCOTT@test01p> @ver1 PORT_STRING                    VERSION        BANNER                                                                               CON_ID ------------------------------ -------------- -------------------------------------------------------------------------------- ---------- IBMPC/WIN_NT64-9.1.0           12.2.0.1.0     Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production              0 SCOTT@test01p> create table deptx as select * from dept; Table created. SCOTT@test01p> select rowid,deptx.* from deptx where rownum=1; ROWID                  DEPTNO DNAME                LOC ------------------ ---------- -------------------- ------------- AAAHZ8AALAAABLTAAA         10 ACCOUNTING           NEW YORK SCOTT@test01p> @ rowid AAAHZ8AALAAABLTAAA     OBJECT       FILE      BLOCK        ROW ROWID_DBA            DBA                  TEXT ---------- ---------- ---------- ---------- -------------------- -------------------- ----------------------------------------      30332         11       4819          0  0x2C012D3           11,4819              alter system dump datafile 11 block 4819 SCOTT@test01p> delete from deptx where deptno = 10; 1 row deleted. SCOTT@test01p> commit ; Commit complete. SCOTT@test01p> alter system checkpoint; System altered. 2.尝试恢复看看: BBED> x /rncc dba 11,4820 *kdbr[0] rowdata[66]                                 @8162 ----------- flag@8162: 0x3c (KDRHFL, KDRHFF, KDRHFD, KDRHFH) lock@8163: 0x02 cols@8164:    0 BBED> assign dba 11,4820 offset 8162=0x2c; ub1 rowdata[0]                              @8162     0x2c BBED> x /rncc dba 11,4820 *kdbr[0] rowdata[66]                                 @8162 ----------- flag@8162: 0x2c (KDRHFL, KDRHFF, KDRHFH) lock@8163: 0x02 cols@8164:    3 col    0[2] @8165: 10 col   1[10] @8168: ACCOUNTING col    2[8] @8179: NEW YORK BBED> sum apply dba 11,4820 Check value for File 11, Block 4820: current = 0x1c09, required = 0x1c09 BBED> verify dba 11,4820 DBVERIFY - Verification starting FILE = D:\APP\ORACLE\ORADATA\TEST\TEST01P\USERS01.DBF BLOCK = 4819 Block Checking: DBA = 46142163, Block Type = KTB-managed data block data header at 0x2b7027c kdbchk: the amount of space used is not equal to block size         used=118 fsc=24 avsp=7946 dtl=8064 --// assign kdbh.kdbhavsp = 7922 Block 4819 failed with check code 6110 DBVERIFY - Verification complete $ ./bbed1011.sh 11,4820 6110 ; ./bbed1011x.sh 11,4820 6110 assign dba 11,4820 kdbh.kdbhavsp = 7922 assign dba 11,4820 kdbh.kdbhavsp = 7922 --//ok!! BBED> assign dba 11,4820 kdbh.kdbhavsp = 7922 b2 kdbhavsp                                 @134      7922 BBED> sum apply dba 11,4820 Check value for File 11, Block 4820: current = 0x1df1, required = 0x1df1 BBED> verify dba 11,4820 DBVERIFY - Verification starting FILE = D:\APP\ORACLE\ORADATA\TEST\TEST01P\USERS01.DBF BLOCK = 4819 Block Checking: DBA = 46142163, Block Type = KTB-managed data block data header at 0x2b7027c kdbchk: space available on commit is incorrect         tosp=7972 fsc=24 stb=0 avsp=7922 --// assign kdbh.kdbhtosp = 7946 Block 4819 failed with check code 6111 DBVERIFY - Verification complete $ ./bbed1011.sh 11,4820 6110 ; ./bbed1011x.sh 11,4820 6111 assign dba 11,4820 kdbh.kdbhtosp = 7946 assign dba 11,4820 kdbh.kdbhtosp = 7946 BBED> assign dba 11,4820 kdbh.kdbhtosp = 7946 b2 kdbhtosp                                 @136      7946 BBED> sum apply dba 11,4820 Check value for File 11, Block 4820: current = 0x1ddf, required = 0x1ddf BBED> verify dba 11,4820 DBVERIFY - Verification starting FILE = D:\APP\ORACLE\ORADATA\TEST\TEST01P\USERS01.DBF BLOCK = 4819 DBVERIFY - Verification complete --//OK!修复完成. SCOTT@test01p> alter system flush BUFFER_CACHE; System altered. SCOTT@test01p> select rowid,deptx.* from deptx ; ROWID                  DEPTNO DNAME                LOC ------------------ ---------- -------------------- ------------- AAAHZ8AALAAABLTAAA         10 ACCOUNTING           NEW YORK AAAHZ8AALAAABLTAAB         20 RESEARCH             DALLAS AAAHZ8AALAAABLTAAC         30 SALES                CHICAGO AAAHZ8AALAAABLTAAD         40 OPERATIONS           BOSTON