Oracle数据库备份脚本

source ~/.bash_profile
export ORACLE_BASE=/u01/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_SID=oa
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin

echo "start beifen">>/tmp/log.txt
BAKUPTIME=date +%w
su - oracle -c "exp oaupgrade/oaupgrade_Dtrlb0 file=/u01/oadbbackup/$BAKUPTIME.dmp, log=/u01/oadbbackup/$BAKUPTIME.log"

echo ".....end beifen">>/tmp/log.txt