oracle下定时执行过程脚本

##用于将oracle数据导出 进行备份

date

DATE=`date +%w`

ORACLE_HOME=/home/oracle/OraHome1/product

export ORACLE_HOME

ORACLE_SID=oradbyj

export ORACLE_SID

ORACLE_TERM=xterm

export ORACLE_TERM

ORACLE_OWNER=oracle

export ORACLE_OWNER

NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16CGB231280"

export NLS_LANG

TNS_ADMIN=/home/oracle/OraHome1/product/network/admin

export TNS_ADMIN

CLASSPATH=$ORACLE_HOME/jdbc/lib/classes111.zip

export CLASSPATH

# Set up the search paths:

PATH=/usr/local/jre/bin:/usr/local/jdk/bin:/bin:/shin

PATH=$PATH:/usr/bin:/usr/sbin:/usr/local/bin:$ORACLE_HOME/bin

PATH=$PATH:/usr/local/sbin:/usr/bin/X11:/usr/X11R6/bin:.

export PATH

cd /backup/yjvip/

#rm *.*

rqOne=`date +%x%t%X`

echo '---------------------------------------------'>>/home/oracle/jobs/crontabf

ile.log

echo '过程vipback运行start时间：'$rqOne>>/home/oracle/jobs/crontabfile.log

exp parfile=/home/oracle/jobs/parfile.par file=yjvip$DATE.dmp log=yjvip$DATE.log

rqOne=`date +%x%t%X`

echo '过程vipback运行结束时间：'$rqOne>>/home/oracle/jobs/crontabfile.log

#rqOne=`date +%x%t%X`

#/bin/echo '过程ftpback运行start时间：'$rqOne >>/home/oracle/jobs/ftp.log

#ftp 10.249.129.66

#rqOne=`date +%x%t%X`

#/bin/echo '过程ftpback运行结束时间：'$rqOne >>/home/oracle/jobs/ftp.log

#su - oracle -c "/home/oracle/jobs/vipback.sh"

#echo '------------------------------------'>>/home/oracle/jobs/crontabfile.log

#/home/oracle/jobs/vipback.sh

cd /backup/yjvip/

#chown -R oracle:oinstall *

rqOne=`date +%x%t%X`

echo 'ftp运行start时间：'$rqOne>>/home/oracle/jobs/ftp.log

/usr/bin/ftp 10.249.129.66

rqOne=`date +%x%t%X`

echo 'ftp运行结束时间：'$rqOne>>/home/oracle/jobs/ftp.log

/******************************************* .netrc **********************************************************/

default login vippub passwd vipdoone

macdef init

passive

binary

prompt off

cd /vipbak

lcd /backup/yjvip

mput *.*

bye

上一页 [1] [2] [3] 下一页

复制本页网址和标题，发送给你QQ/Msn的好友一起分享

上一篇:在 Red Hat Linux 9.0 上安装 Oracle 8i

下一篇:生成带日期的文件名