Linux定时备份oracle数据库shell脚本，并删除15天以前备份

俗尘某某

已于 2022-06-26 12:46:05 修改

阅读量1k

点赞数

分类专栏：程序员记录文章标签： Linux 数据库备份

于 2019-06-20 21:07:58 首次发布

本文链接：https://blog.csdn.net/u014642153/article/details/93133917

版权

程序员记录专栏收录该内容

27 篇文章 0 订阅

订阅专栏

Linux定时备份oracle数据库shell脚本，并删除15天以前备份，打包，修改权限为700

#!/bin/sh
export USER=oracle
export ORACLE_SID=orcl
export ORACLE_PORT=1521
export ORACLE_ADDR=192.168.230.128
export ORACLE_BASE=/home/oracle/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export LD_LIBRARY_PATH=:$ORACLE_HOME/lib:/usr/local/oracle:$LD_LIBRARY_PATH:.
export PATH=PATH=$ORACLE_HOME/bin:$PATH
export DATA_DIR=/home/oracle/shell/dmp数据库备份
export LOGS_DIR=/home/oracle/shell/dmp数据库备份/log
export DELTIME=`date -d "15 days ago" +%Y%m%d`
export BAKUPTIME=`date +%Y%m%d%H%M%S`
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
mkdir -p $DATA_DIR
mkdir -p $LOGS_DIR
echo "开始备份,备份目录:$DATA_DIR/$ORACLE_SID_$BAKUPTIME.dmp"
exp LZSMW/LZSMW@$ORACLE_ADDR:$ORACLE_PROT/$ORACLE_SID file=$DATA_DIR/LZSMW_$BAKUPTIME.dmp log=$LOGS_DIR/LZSMW_$BAKUPTIME.log
exp LZSMW_DB/LZSMW_DB@$ORACLE_ADDR:$ORACLE_PROT/$ORACLE_SID file=$DATA_DIR/LZSMW_DB_$BAKUPTIME.dmp

log=$LOGS_DIR/LZSMW_DB$BAKUPTIME.log
echo "备份和压缩文件授权所属用户读写执行权限！"
if [ ! -f "$DATA_DIR/swsmk_$BAKUPTIME.dmp" ];then
    echo "swsmk_$BAKUPTIME.dmp文件不存在!"
else
    tar zcPvf $DATA_DIR/LZSMW_$BAKUPTIME.dmp.tar.gz $DATA_DIR/swsmk_$BAKUPTIME.dmp
    chmod 700 $DATA_DIR/LZSMW_$BAKUPTIME.dmp.tar.gz
    chmod 700 $DATA_DIR/LZSMW_$BAKUPTIME.dmp
fi
if [ ! -f "$DATA_DIR/LZSMW_DB_$BAKUPTIME.dmp" ];then
    echo "bams_$BAKUPTIME.dmp文件不存在!"
else
    tar zcPvf $DATA_DIR/LZSMW_DB_$BAKUPTIME.dmp.tar.gz $DATA_DIR/bams_$BAKUPTIME.dmp
    chmod 700 $DATA_DIR/LZSMW_DB_$BAKUPTIME.dmp.tar.gz
    chmod 700 $DATA_DIR/LZSMW_DB_$BAKUPTIME.dmp
fi
echo "日志文件授权所属用户读写执行权限！"
if [ ! -f "$LOGS_DIR/LZSMW_$BAKUPTIME.log" ];then
    echo "swsmk_$BAKUPTIME.log文件不存在!"
else
    chmod 700 $LOGS_DIR/LZSMW_$BAKUPTIME.log
fi
if [ ! -f "$LOGS_DIR/LZSMW_$BAKUPTIME.log" ];then
    echo "LZSMW_$BAKUPTIME.log文件不存在!"
else
    chmod 700 $LOGS_DIR/LZSMW_$BAKUPTIME.log
fi
echo "删除15天之前的DMP备份和日志文件！"
rm -rf $DATA_DIR/LZSMW_$DELTIME*.dmp
rm -rf $DATA_DIR/LZSMW_DB_$DELTIME*.dmp
rm -rf $LOGS_DIR/LZSMW_$DELTIME*.log
rm -rf $LOGS_DIR/LZSMW_DB_$DELTIME*.log
echo "数据备份完成！"