LINUX下Oracle库备份脚本

huayuan61

于 2010-01-16 10:02:00 发布

阅读量566

点赞数

分类专栏： LINUX 文章标签： oracle linux library path buffer date

本文链接：https://blog.youkuaiyun.com/huayuan61/article/details/5197899

版权

LINUX 专栏收录该内容

9 篇文章

订阅专栏

vi /opt/back.sh(oracle用户)

#!/bin/ksh
tim=`date +%Y%m%d`
unset USERNAME
#export DISPLAY=0.0.0.0:0.0
#export ORACLE_BASE=/home/oraprod3
#export ORACLE_HOME=/prod/oracle/prod3db/9.2.0
#export ORACLE_SID=PROD3_db
#export LD_LIBRARY_PATH=/prod/oracle/prod3db/9.2.0/lib
#export ORACLE_TERM=vt100
#export ORA_NLS33=/prod/oracle/prod3db/9.2.0/ocommon/nls/admin/data
#export NLS_LANG=AMERICAN_AMERICA.zhs16gbk
#export PATH=/prod/oracle/prod3db/9.2.0/bin
#export LD_ASSUME_KERNEL=2.2.5
#export TMPDIR=/tmp
/prod/oracle/prod3db/9.2.0/bin/exp userid=mkoa/mkoapass file=/prod/oracle/c/exp/dmp/dat$tim.dmp buffer=2048000 >>/prod/oracle/c/exp/log/log$tim.log 2>&1
/usr/bin/gzip /prod/oracle/c/exp/dmp/dat$tim.dmp

------------------------------

vi /opt/oraback.sh(root用户)

su - oracle -c "/opt/back.sh"

------------

[root@rac2 bin]# chmod +x back.sh

[root@rac2 bin]# chmod +x oraback.sh
[root@rac2 bin]# crontab -e
1 30 * * * /opt/oraback.sh