OGG運(yùn)維優(yōu)化腳本（三.五）-信息修改類--附加日志增加
文件名: addtrandata.sh
成都創(chuàng)新互聯(lián)公司是一家專注于成都做網(wǎng)站、成都網(wǎng)站建設(shè)與策劃設(shè)計(jì),洛龍網(wǎng)站建設(shè)哪家好?成都創(chuàng)新互聯(lián)公司做網(wǎng)站,專注于網(wǎng)站建設(shè)十年,網(wǎng)設(shè)計(jì)領(lǐng)域的專業(yè)建站公司;建站業(yè)務(wù)涵蓋:洛龍等地區(qū)。洛龍做網(wǎng)站價(jià)格咨詢:18980820575
所在路徑:$HOME/ggscript/gginsert
功能：用于批量增加表附加日志，屬于從加表腳本中獨(dú)立出來的功能，用于應(yīng)對(duì)表附加日志丟失以及加表附加日志增加失敗的情況
#!/bin/bash
echo "This script will add trandata( by RenYi)"
ls -lrt $HOME/ggserver/dirprm/e*.prm
echo "The EXTRACT process:"
cd $HOME/ggserver
(echo info all;echo exit)|./ggsci|grep "EXTRACT" |awk 'BEGIN {FS=" +"} {print $3}'|grep '^E'
cd $HOME/ggscript/gginsert
echo "Please press any key"
read -n 1
read -p "Please enter the EXTRACT name:" val2
val=`echo $val2.PRM|tr A-Z a-z`
cd $HOME/ggserver/dirprm
if [ ! -e $val ]; then
echo "the EXTRACT is not exist"
echo "the EXTRACT is not exist" >> ''$HOME'/gglog/gginsert/InsertLog-'$backuptime'.log'
exit 2
fi
echo "Please Enter the table (Please enter any key)"
read -n 1
cat /dev/null > trandaTmp
vi trandaTmp
sed 's/^/add trandata /' trandaTmp > addtrandata
NUX=`sed -n '$=' addtrandata`
echo $NUX
i=1
echo $i
cd $HOME/ggserver
echo dblogin `more $HOME/ggserver/dirprm/$val|grep USERID` > dirdat/addtrandata
echo $login
while [ "$i" -le "$NUX" ]
do
sed -n "${i}p" $HOME/ggscript/gginsert/addtrandata >> dirdat/addtrandata
i=`expr $i + 1`
done
echo OBEY dirdat/addtrandata |./ggsci
當(dāng)前名稱：OGG運(yùn)維優(yōu)化腳本（三.五）-信息修改類--附加日志增加
文章位置：http://m.jiaotiyi.com/article/pjppjo.html