oracle 定时备份脚本

#!/bin/sh

export ORACLE_BASE=/data/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/11.2.0

export ORCLE_SID=orcl

export LD_LIBRARY_PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8



#

rq=$(date +%Y%m%d%H%M)



/data/app/oracle/product/11.2.0/bin/exp yo_online/yo_online123@orcl owner=yo_online rows=y indexes=n compress=y file=/data/orabak/oracleBack_$rq.dmp log=/data/orabak/oracleBack_$rq.log

#

chmod 755 /data/orabak/oracleBack_$rq.dmp

chmod 755 /data/orabak/oracleBack_$rq.log



#

oradatabak=oracleBack_$rq.tar.gz

dmpbak=oracleBack_$rq.dmp

logbak=oracleBack_$rq.log

days=3



tar -zcvPf /data/orabak/$oradatabak /data/orabak/oracleBack_$rq.dmp /data/orabak/oracleBack_$rq.log



find "/data/orabak" -type f -name "*.dmp" -mtime +$days -exec rm {} \;

find "/data/orabak" -type f -name "*.log" -mtime +$days -exec rm {} \;

find "/data/orabak" -type f -name "*.tar.gz" -mtime +$days -exec rm -rf {} \;

一定要赋予root权限