oracle 定期备份脚本,suse下oracle的自动备份脚本

ORACLE_BASE=/opt/oracle

ORACLE_HOME=$ORACLE_BASE/product/10g

ORACLE_SID=ora10g

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

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib

NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;

export ORACLE_BASE ORACLE_HOME PATH LD_LIBRARY_PATH NLS_LANG

su - oracle

cd /opt/dbbackup/

exp office/wyplz@ora10g WNER=office FILE="`date +%Y%m%d`office.dmp" LOG="`date +%Y%m%d`office.log"

zip `date +%Y%m%d`office.zip `date +%Y%m%d`office.dmp `date +%Y%m%d`office.log

exp apollo/apollo@ora10g WNER=apollo FILE="`date +%Y%m%d`apollo.dmp" LOG="`date +%Y%m%d`apollo.log"

zip `date +%Y%m%d`apollo.zip `date +%Y%m%d`apollo.dmp `date +%Y%m%d`apollo.log

exit

scp `date +%Y%m%d`office.zip `date +%Y%m%d`apollo.zip root@1.2.3.4:/home

rm `date +%Y%m%d`apollo.dmp

rm `date +%Y%m%d`apollo.log

rm `date +%Y%m%d`office.dmp

rm `date +%Y%m%d`office.log

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/90618/viewspace-616208/，如需转载，请注明出处，否则将追究法律责任。