aix下oracle定時自動備份

  export ORACLE_BASE=/ora/oracle
export ORACLE_HOME=/ora/oracle/product/11.2.0
export ORACLE_SID=image
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin

export DATA_DIR=/home/backup/imagedata
export LOGS_DIR=/home/backup/imagelogs
export BAKUPTIME=`date +%Y%m%d%H%M%S`

TZ=TZ+192
#備份資料儲存7天

DELTIME=`date +%Y%m%d`
mkdir -p $DATA_DIR
mkdir -p $LOGS_DIR

echo "Starting bakup..."
echo "Bakup file path $DATA_DIR/$BAKUPTIME.dmp"
exp admin/admin@image file=$DATA_DIR/$BAKUPTIME.dmp log=$LOGS_DIR/$BAKUPTIME.log

echo "Delete the file bakup before 7 days..."
rm -rf $DATA_DIR/$DELTIME*.dmp
rm -rf $LOGS_DIR/$DELTIME*.log
echo "Delete the file bakup successfully. "

echo "Bakup completed."