bbed批量修改asm的datafile脚本

**导读**

> 作者：杨漆

> 16年关系型数据库管理，从oracle 9i 、10g、11g、12c到Mysql5.5、5.6、5.7、8.0 到TiDB获得3个OCP、2个OCM；运维路上不平坦，跌过不少坑、熬过许多夜。把工作笔记整理出来分享给大伙儿，希望帮到大家少走弯路、少熬夜。

需要修改的数据文件块特别多时，可以用我写的以下脚本为bbed提供批量修改数据

通过名字过滤出仅含datafile的文件 (此处仅以system文件举例)

ll /data/|grep system|awk '{print $9}' >datafile_name.txt

准备数据块偏移量

cat bbed_repair_data.sh

#!/bin/sh

rm -rf /home/oracle/116.txt

rm -rf /home/oracle/112.txt

rm -rf /home/oracle/140.txt

rm -rf /home/oracle/148.txt

rm -rf /home/oracle/484.txt

rm -rf /home/oracle/488.txt

rm -rf /home/oracle/492.txt

rm -rf /home/oracle/500.txt

rm -rf /home/oracle/504.txt

rm -rf /home/oracle/122.txt

rm -rf /home/oracle/120.txt

rm -rf /home/oracle/order_datafile_name.txt

rm -rf /home/oracle/rm_old_asm_file

cp /home/oracle/datafile_name.txt   /home/oracle/order_datafile_name.txt

cp  /home/oracle/datafile_name.txt /home/oracle/rm_old_asm_file

i=1

cat /home/oracle/datafile_name.txt|while read line

do

sed -i "s/^$line/$i  \/data\/$line/"  /home/oracle/order_datafile_name.txt

i=$[$i+1]

done

i=1

cat /home/oracle/datafile_name.txt|while read line

do

echo "set dba $i,1">>/home/oracle/112.txt

echo "m /x 88ed offset 112">>/home/oracle/112.txt

echo "Y">>/home/oracle/112.txt

echo "set offset +2">>/home/oracle/112.txt

echo "m /x b03a">>/home/oracle/112.txt

echo "sum apply">>/home/oracle/112.txt

i=$[$i+1]

done

i=1

cat /home/oracle/datafile_name.txt|while read line

do

echo "m /x 01000000 dba $i,1 offset 116">>/home/oracle/116.txt

echo "Y">>/home/oracle/116.txt

echo "sum apply">>/home/oracle/116.txt

i=$[$i+1]

done

i=1

cat /home/oracle/datafile_name.txt|while read line

do

echo "set dba $i,1">>/home/oracle/484.txt

echo "m /x dc2c offset 484">>/home/oracle/484.txt

echo "Y">>/home/oracle/484.txt

echo "set offset +2">>/home/oracle/484.txt

echo "m /x fef4">>/home/oracle/484.txt

echo "sum apply">>/home/oracle/484.txt

i=$[$i+1]

done

i=1

cat /home/oracle/datafile_name.txt|while read line

do

echo "set dba $i,1">>/home/oracle/488.txt

echo "m /x 002e offset 488">>/home/oracle/488.txt

echo "Y">>/home/oracle/488.txt

echo "sum apply">>/home/oracle/488.txt

i=$[$i+1]

done

i=1

cat /home/oracle/datafile_name.txt|while read line

do

echo "m /x 24e54f40 dba $i,1 offset 492">>/home/oracle/492.txt

echo "Y">>/home/oracle/492.txt

echo "sum apply">>/home/oracle/492.txt

i=$[$i+1]

done

i=1

cat /home/oracle/datafile_name.txt|while read line

do

echo "m /x 0f800300 dba $i,1 offset 500">>/home/oracle/500.txt

echo "Y">>/home/oracle/500.txt

echo "sum apply">>/home/oracle/500.txt

i=$[$i+1]

done

i=1

cat /home/oracle/datafile_name.txt|while read line

do

echo "set dba $i,1">>/home/oracle/504.txt

echo "m /x d247 offset 504">>/home/oracle/504.txt

echo "Y">>/home/oracle/504.txt

echo "set offset +2">>/home/oracle/504.txt

echo "m /x 0000">>/home/oracle/504.txt

echo "sum apply">>/home/oracle/504.txt

i=$[$i+1]

done

i=1

cat /home/oracle/datafile_name.txt|while read line

do

echo "m /x 67510400 dba $i,1 offset 148">>/home/oracle/148.txt

echo "Y">>/home/oracle/148.txt

echo "sum apply">>/home/oracle/148.txt

i=$[$i+1]

done

i=1

cat /home/oracle/datafile_name.txt|while read line

do

echo "m /x 68510400 dba $i,1 offset 140">>/home/oracle/140.txt

echo "Y">>/home/oracle/140.txt

echo "sum apply">>/home/oracle/140.txt

i=$[$i+1]

done

i=1

cat /home/oracle/datafile_name.txt|while read line

do

echo "m /x 00000000 dba $i,1 offset 120">>/home/oracle/120.txt

echo "Y">>/home/oracle/120.txt

echo "sum apply">>/home/oracle/120.txt

i=$[$i+1]

done

i=1

cat /home/oracle/datafile_name.txt|while read line

do

echo "m /x 00000000 dba $i,1 offset 122">>/home/oracle/122.txt

echo "Y">>/home/oracle/122.txt

echo "sum apply">>/home/oracle/122.txt

i=$[$i+1]

done

i=1

cat /home/oracle/rm_old_asm_file.txt|while read line

do

sed -i "s/^$line/rm -rf $line/" /home/oracle/rm_old_asm_file.txt

i=$[$i+1]

done

cat  /home/oracle/116.txt > repair.txt

cat  /home/oracle/112.txt >> repair.txt

cat  /home/oracle/140.txt >> repair.txt

cat  /home/oracle/148.txt >> repair.txt

cat  /home/oracle/484.txt >> repair.txt

cat  /home/oracle/488.txt >> repair.txt

cat  /home/oracle/492.txt >> repair.txt

cat  /home/oracle/500.txt >> repair.txt

cat  /home/oracle/504.txt >> repair.txt

cat  /home/oracle/122.txt >> repair.txt

cat  /home/oracle/120.txt >> repair.txt

最后登录bbed, 跑repair.txt里的内容既可完成数据文件块的批量修改

回传ASM前，到grid用户下asmcmd跑rm_old_asm_file.txt内容完成批量删除datafile，之后将bbed修复后的新datafile文件传过来既可