全库备份oracle

最新推荐文章于 2022-09-21 10:20:55 发布

weixin_33895604

最新推荐文章于 2022-09-21 10:20:55 发布

阅读量181

点赞数

CC 4.0 BY-SA版权

文章标签：数据库 python

原文链接：https://my.oschina.net/xiaoqqq/blog/381090

2019独角兽企业重金招聘Python工程师标准>>>

#!/bin/sh
export DATA_DIR=/weblogic/gs_bak/DBdata
export DELTIME=`date -d "7 days ago" +%Y%m%d`
export BAKUPTIME=`date +%Y%m%d`

filename="XXXX_DB_10.6.11.28_pisr_$BAKUPTIME"
echo "pre filename: "$filename

mkdir -p $DATA_DIR

echo "Starting bakup..."
echo "Bakup file: $DATA_DIR/$filename.dmp"
su - oracle -c "exp uuuu/pppp@orcl file=$DATA_DIR/$filename.dmp"

echo "tar the db backup file..."

cd $DATA_DIR
tar czvf $filename.tar.gz $DATA_DIR/$filename.dmp

echo "Delete the bakup file 7 days ago..."
rm -rf $DATA_DIR/XXXX_DB_10.6.11.28_xxxx_$DELTIME*.dmp
rm -rf $DATA_DIR/XXXX_DB_10.6.11.28_xxxx_$DELTIME.tar.gz
echo "Delete the file bakup successfully. "

echo "Bakup completed."

转载于:https://my.oschina.net/xiaoqqq/blog/381090