OGG运维优化脚本（三. 五）-信息修改类--附加日志增加

文件名: addtrandata.sh

所在路径:$HOME/ggscript/gginsert

功能：用于批量增加表附加日志，属于从加表脚本中独立出来的功能，用于应对表附加日志丢失以及加表附加日志增加失败的情况

#!/bin/bashecho "This script will add trandata( by RenYi)"ls -lrt $HOME/ggserver/dirprm/e*.prmecho "The EXTRACT process:"cd $HOME/ggserver(echo info all;echo exit)|./ggsci|grep "EXTRACT" |awk 'BEGIN {FS=" +"} {print $3}'|grep  '^E'cd $HOME/ggscript/gginsertecho "Please press any key"read -n 1read -p "Please enter the EXTRACT name:"  val2val=`echo $val2.PRM|tr A-Z a-z`cd $HOME/ggserver/dirprmif [ ! -e $val ]; then        echo "the EXTRACT is not exist"         echo "the EXTRACT is not exist"  >> ''$HOME'/gglog/gginsert/InsertLog-'$backuptime'.log'        exit 2fiecho "Please Enter the table (Please enter any key)"read -n 1cat /dev/null > trandaTmpvi trandaTmpsed 's/^/add trandata /' trandaTmp > addtrandataNUX=`sed -n '$=' addtrandata`echo $NUXi=1echo $icd $HOME/ggserverecho dblogin `more $HOME/ggserver/dirprm/$val|grep USERID` > dirdat/addtrandataecho $login                        while [ "$i" -le "$NUX" ]                               do                                 sed -n "${i}p"  $HOME/ggscript/gginsert/addtrandata >> dirdat/addtrandata                                i=`expr $i + 1`                        doneecho   OBEY dirdat/addtrandata |./ggsci