linux crond 脚本.sh

编写执行脚本 bak.sh文件 修改文件权限

# chmod 775 bak.sh

#!/bin/sh
echo "exp Oracle"
export ORACLE_BASE=/u01/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/databasename

export ORACLE_SID=databaseSID
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

export DATA_DIR=/home/oracle/data
export LOGS_DIR=/home/oracle/logs
export DELTIME=$(date -d "20 days ago" +%Y%m%d)
export BAKUPTIME=$(date +%Y%m%d%H%M%S)

mkdir -p $DATA_DIR
mkdir -p $LOGS_DIR

echo "Starting bakup......"

exp username/password owner=username file=$DATA_DIR/$BAKUPTIME.dmp log=$LOGS_DIR/$BAKUPTIME.log grants=y

zip -rP zippassword $DATA_DIR/$BAKUPTIME.zip $DATA_DIR/$BAKUPTIME.dmp
rm -rf $DATA_DIR/$BAKUPTIME.dmp

echo "Delete the file bakup before 20 days..."
rm -rf $DATA_DIR/$DELTIME*.zip
rm -rf $LOGS_DIR/$DELTIME*.log