现在开始介绍脚本,所有的脚本必须在prm配置文件添加注释后才能成功使用
实际的运维过程中,我们的OGG程序都统一部署在$home/ggserver路径下,
批量加表
文件名: insert.sh
脚本所在路径:$HOME/ggscript/gginsert
功能:为满足应用时常提出的大批量增加同步表需求
用于批量加表,包括重复配置表过滤功能以及附加日志自动增加功能
该脚本通过edit脚本选择调用
该脚本目前只能对EXTRACT和发送进程生效
日志路径: $HOME/gglog/gginsert
#!/bin/bash
backuptime=`date +%Y%m%d-%H%M`
datenow=`date +%Y%m%d%H`
cd $HOME/ggscript/gginsert
echo $backuptime
echo "This script will search for the table that has been added and insert new table( by RenYi)"
echo $backuptime > ''$HOME'/ggscript/gginsert/log/InsertLog-'$backuptime'.log'
ls -lrt $HOME/ggserver/dirprm/e*.prm $HOME/ggserver/dirprm/p*.prm
$val
#输入需操作的进程对应文件名(prm结尾)
read -p "Please enter the prm file name:" val
echo "--------insert file name------" >> ''$HOME'/ggscript/gginsert/log/InsertLog-'$backuptime'.log'
echo $val >> ''$HOME'/ggscript/gginsert/log/InsertLog-'$backuptime'.log'
#输入需要批量增加表对应的区域
cat $HOME/ggserver/dirprm/$val|grep Begin
read -p "Please enter the Area name:" area
echo "--------insert area------" >> ''$HOME'/ggscript/gginsert/log/InsertLog-'$backuptime'.