shell脚本

#!/bin/bash
PATH=$PATH:$HOME/bin
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
ORACLE_SID=xxx
PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_BASE ORACLE_HOME ORACLE_SID
export PATH
NLS_LANG=AMERICAN_AMERICA.UTF8
export NLS_LANG
#export DELTIME=`date -d "15 days ago" +%Y%m%d`
export CRMBACKUPTIME=`date +%Y%m%d%H%M%S`
#备份crm用户的数据
expdp XXX/密码@SID schemas=crm dumpfile=CRM$CRMBACKUPTIME.dmp directory=bdir logfile=crm.log;
#备份ky用户的数据
export KYBACKUPTIME=`date +%Y%m%d%H%M%S`
expdp KY/密码@SID schemas=ky dumpfile=KY$KYBACKUPTIME.dmp directory=bdir logfile=ky.log;
#备份NW_BJ_AISINO用户数据
export NWBACKUPTIME=`date +%Y%m%d%H%M%S`
expdp NW_BJ_AISINO/密码@SID schemas=NW_BJ_AISINO dumpfile=NW_BJ_AISINO$NWBACKUPTIME.dmp directory=bdir logfile=nw_bj_aisino.log; 
#备份weixin用户数据
export WEIXINBACKUPTIME=`date +%Y%m%d%H%M%S`
expdp WEIXIN/密码@SID schemas=WEIXIN dumpfile=WEIXIN$WEIXINBACKUPTIME.dmp directory=dpir logfile=weixin.log;
#备份payorder用户的数据
export PAYBACKUPTIME=`date +%Y%m%d%H%M%S`
expdp PAYORDER/密码@SID schemas=PAYORDER dumpfile=PAYORDER$PAYBACKUPTIME.dmp directory=bdir logfile=payorder.log;

#删除2天前的备份
find /u01/app/oracle/backup -type f -name "*.dmp" -mtime +2 -exec rm -rf {} \; > /dev/null 2>&1
#find /u01/app/oracle/backup/ -mtime +2 -name "KY*.dmp" -exec rm -rf {} ;
#find /u01/app/oracle/backup/ -mtime +2 -name "NW_BJ_AISINO*.dmp" -exec rm -rf {} ;
#find /u01/app/oracle/backup/ -mtime +2 -name "WEIXIN*.dmp" -exec rm -rf {} ;
#find /u01/app/oracle/backup/ -mtime +2 -name "PAYORDER*.dmp" -exec rm -rf {} ;

定时任务

[oracle@crmdb1 ~]$ crontab -e
#每天凌晨2点开始备份数据
0 2 * * 0-6 /bin/bash -x /u01/app/oracle/backup/scripts/expdp.sh >/dev/null 2>&1