Oracle本地自动备份脚本

每天自动备份打包压缩，自动删除dmp文件,和7天前的压缩备份文件

#!/bin/sh 
source ~/.bash_profile
BACKUPTIME=$(date +%Y%m%d)
dmpfile=.dmp
logfile=.log
DMPNAME=chwcrm-$BACKUPTIME$dmpfile
LOGNAME=chwcrm-$BACKUPTIME$logfile
echo $BACKUPTIME
echo $DMPNAME
echo $LOGNAME
expdp xxx/xxx@orcl directory=TESTDIR dumpfile=$DMPNAME logfile=$LOGNAME  schemas=chwcrm
tar -zcPvf /dta/chwbak/$DMPNAME.tar.gz /dta/chwbak/$DMPNAME
rm -rf /dta/chwbak/$DMPNAME