oracle 定时备份脚本 #!/bin/shexport ORACLE_BASE=/data/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11

oracle 定时备份脚本

#!/bin/shexport ORACLE_BASE=/data/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0export ORCLE_SID=orclexport LD_LIBRARY_PATH=$ORACLE_HOME/bin:$PATH:$HOME/binexport 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.dmpchmod 755 /data/orabak/oracleBack_$rq.log#oradatabak=oracleBack_$rq.tar.gzdmpbak=oracleBack_$rq.dmplogbak=oracleBack_$rq.logdays=3tar -zcvPf /data/orabak/$oradatabak /data/orabak/oracleBack_$rq.dmp /data/orabak/oracleBack_$rq.logfind "/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权限