oracle执行shell脚本

最新推荐文章于 2023-05-18 23:20:09 发布

转载最新推荐文章于 2023-05-18 23:20:09 发布 · 245 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/atwanli/articles/4620364.html

文章标签：

#shell #数据库

本文介绍了一个用于批量备份并删除指定日期目录下文件的Shell脚本。该脚本适用于jinbangda、zhongchao、huangshi和all四个目录，首先检查目录是否存在，如果存在则进行备份并将原目录删除，同时执行SQL查询和删除操作。

echo "请输入时间(yyyymmdd)"
read date
cd /home/ap/ssp/filedir/infiledir/makecard/jinbangda/
if [ ! -d "$date" ]
then
echo "file $date not exist"
exit 0
else
echo "jinbangda file $date is exist,gameover"
cp -rf $date $date.bak
echo "jinbangda file $date is copy,filename is $date.bak ok"
rm -rf $date
echo "jinbangda delete file $date ok"
fi

cd /home/ap/ssp/filedir/infiledir/makecard/zhongchao/
if [ ! -d "$date" ]
then
echo "zhongchao file $date not exist"
exit 0
else
echo "zhongchao file $date is exist,gameover"
cp -rf $date $date.bak
echo "zhongchao file $date is copy,filename is $date.bak ok"
rm -rf $date
echo "zhongchao delete file $date ok"
fi

cd /home/ap/ssp/filedir/infiledir/makecard/huangshi/
if [ ! -d "$date" ]
then
echo "huangshi file $date not exist"
exit 0
else
echo "huangshi file $date is exist,gameover"
cp -rf $date $date.bak
echo "huangshi file $date is copy,filename is $date.bak ok"
rm -rf $date
echo "huangshi delete file $date ok"
fi

cd /home/ap/ssp/filedir/infiledir/makecard/all/
if [ ! -d "$date" ]
then
echo "all file $date not exist"
exit 0
else
echo "all file $date is exist,gameover"
cp -rf $date $date.bak
echo "all file $date is copy,filename is $date.bak ok"
rm -rf $date
echo "all delete file $date ok"
fi

sq <<EOF
set linesize 1000;
select * from batstat where command='dealmakecard' and inputstr like '$date%';
delete file_mon where filedate='$date';
EOF

转载于:https://www.cnblogs.com/atwanli/articles/4620364.html