#!/bin/bash
#刷新环境变量,很重要!!!
source /etc/profile
source ~/.bash_profile
#备份文件存放目录
datadir=/home/oracle/oracleBackup/data
logdir=/home/oracle/oracleBackup/logs
#cd $dir
#备份文件命名 YYYY-MM-DD_HH:mm
name=`date +zwzx%Y%m%d`
#设置本服务器的oracle字符集
export NLS_LANG='AMERICAN_AMERICA.UTF8'
#备份语句,在服务器上备份用服务名,不能用实例名
exp dhbjwl/dhbjwl123@198.11.0.121/orcl file=$datadir/${name}.dmp log=$logdir/${name}.log owner=scott
#删除7天前的备份
find $datadir -name "*.dmp" -mtime +7 | xargs rm -rf
find $logdir -name "*.log" -mtime +7 | xargs rm -rf