OGG运维优化脚本（九）-查询维护类--进程重复表检查

路径:$HOME/ggscript/ggrepeat

功能：该脚本为处理目标端因为源端重复配置源端表，导致目标端数据重复的问题而设计。可以针对进程检查重复配置的表名，并罗列具体信息和所在文件行数

可以配合note快速注释脚本进行源端重复表清理操作

#!/bin/bashecho "+--------------------------------------------------------+"echo "|This script will search for the repeat table ( by RenYi)|"echo "+--------------------------------------------------------+"if [ $# -eq 0 ]; then        echo "REPEAT EXTRACT"        exit 2fibackuptime=`date +%Y%m%d-%H%M`datenow=`date +%Y%m%d%H`val=$1val=`echo $val|tr a-z A-Z`echo "-------------------------"echo "The process name is $val"echo "-------------------------"val=`echo $val.PRM|tr A-Z a-z`cd $HOME/ggserver/dirprmif [ ! -e $val ]; then        echo "the EXTRACT is not exist"        exit 2ficd $HOME/ggscript/ggrepeatcat $HOME/ggserver/dirprm/$val|awk '/TABLE#/,/#TABLE/{if(i>1)print x;x=$0;i++}' > tempawk -F '--'  '($1) { print $1}' temp > temp2rm -rf tempsed  -e '/^$/d'  temp2 > temp3rm -rf temp2awk -F ',' '{print $1}' temp3 >temp4rm -rf temp3awk -F ';' '{print $1}' temp4 >temp5rm -rf temp4cat temp5|awk  -F 'TABLE '  '{print $2}' > Temprm -rf temp5sort Temp |uniq -d > $HOME/ggscript/ggrepeat/tmpecho "-------------------------"echo "The repeat table:"echo "-------------------------"cat tmpi=1num=`sed -n '$=' tmp`echo "num = $num"echo "-------------------------"echo "The Detailed results:"echo "-------------------------"while [ ! -n "$num" ]do        echo "no result"        exit 2donewhile [ "$i" -le "$num" ]do        TAL=`sed -n $i'p' tmp`        echo $TAL        grep -ni $TAL $HOME/ggserver/dirprm/$val        ((i++));doneecho "-------------------------"