- #!/bin/ksh
- # Author: Edward.Zhou -- <edgeman_03@163.com>
- # Purpose: 使用exp自动备份oracle并上传数据到ftp
- # Created: 2015/8/8
- source ~/.profile
- export ORACLE_SID=odb1
- export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
- HOSTNAME=`hostname -s`
- NOWDATE=`date +%Y_%m_%d`
- NOWTIME=`date +%Y%m%d%H%M%S`
- OLDDATE=`date +%Y_%m_%d -d '-1 days'`
- FTPOLDDATE=`date +%Y_%m_%d -d '-7 days'`
- #建议备份基本目录环境
- BACKUPDIR=/tmp/dmp
- [ -d ${BACKUPDIR} ] || mkdir -p ${BACKUPDIR}
- [ -d ${BACKUPDIR}/${NOWDATE} ] || mkdir -p ${BACKUPDIR}/${NOWDATE}
- [ ! -d ${BACKUPDIR}/${OLDDATE} ] || rm -fr ${BACKUPDIR}/${OLDDATE}
- #创建PIPE管道
- [ -p /tmp/exp.pipe ] || mknod /tmp/exp.pipe p
- # if [ ! -p /tmp/exp.pipe ];then
- # mknod /tmp/exp.pipe
- # fi
- #exp备份
- USERNAME=backup
- PASSWORD=backup
- # echo ${BACKUPDIR}/${NOWDATE}/${HOSTNAME}-${ORACLE_SID}-fullbackup_${NOWTIME}.dmp
- bzip2 -9 < /tmp/exp.pipe > ${BACKUPDIR}/${NOWDATE}/${HOSTNAME}-${ORACLE_SID}-fullbackup_${NOWTIME}.dmp.bz2 &
- exp ${USERNAME}/${PASSWORD} file=/tmp/exp.pipe log=${BACKUPDIR}/${NOWDATE}/${HOSTNAME}-${ORACLE_SID}-fullbackup_${NOWTIME}.log full=y direct=y consistent=y buffer=102400
- #上传备份至FTP
- HOST=1.1.1.1
- FTP_USERNAME=backup
- FTP_PASSWORD=backup
- cd ${BACKUPDIR}
- ftp -i -n -v <<EOF
- open ${HOST}
- user ${FTP_USERNAME} ${FTP_PASSWORD}
- bin
- mkdir oradmp
- cd oradmp
- mkdir ${HOSTNAME}
- cd ${HOSTNAME}
- mkdir ${NOWDATE}
- cd ${NOWDATE}
- lcd ${NOWDATE}
- mput *
- cd ..
- cd ${FTPOLDDATE}
- mdelete .
- cd ..
- rmdir ${FTPOLDDATE}
- bye
- EOF
- #清除临时文件
- rm -fr /tmp/exp.pipe
- #该片段来自于http://www.codesnippet.cn/detail/1108201513397.html
来源: http://www.codesnippet.cn/detail/1108201513397.html