Centos自动备份Oracle数据

1. 编写数据库备份脚本文件(db_bak.sh)

#!/bin/bash
# This is Shell For Backing Db
# Creator:SANMEL;
# Email:saynmel@gmail.com
# Date:2019/12/19

echo '↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓'
echo '↓↓↓↓↓↓↓Oracle数据库定时备份开始↓↓↓↓↓↓↓'
echo '==> Date:'`date`
echo '↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓'

# 加载环境变量(必须添加，否则crontab任务计划不能执行)
export ORACLE_BASE=/orcl/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.2.0/dbhome_1/
export PATH=$PATH:/usr/bin:/bin
export PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export LANG=C
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK


# 设置备份根路径文件夹
bak_root_path="/home/oracle/db_bak"
echo '备份根路径:'${
   bak_root_path}

# 备份保留天数
saveDay=7
echo '备份保留天数'$