#编辑crontab定时任务,每分钟执行一次/home/oracle/bak/1.sh
crontab -e
*/1 * * * * /home/oracle/bak/1.sh >> /home/oracle/bak/backup.log
自动备份数据库并将上一次备份数据删除,并压缩
#**************************
#根据不同的oracle安装路径,设置的路径不同
#
#**************************
ORACLE_BASE=/export/home/oracle/u01/app/oracle export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/oracle/product/10.2.0/db_1 export ORACLE_HOME
ORACLE_SID=orcl export ORACLE_SID
PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin export PATH
NLS_LANG=american_america.zhs16gbk export NLS_LANG
#RUNDATE=$(date +%y%m%d)
#SNDDIR=/export/home/oracle/bak
SNDDIR=/tmp/bakJW
echo $RUNDATE
echo $SNDDIR
rm -rf $SNDDIR/backup.*.dmp
/export/home/oracle/u01/app/oracle/oracle/product/10.2.0/db_1/bin/exp test/test@orcl file=$SNDDIR/inkanetbackup.`date '+%y%m%d'`.dmp
######### uploadftp #############
ftp -n<<!
open 11.10.92.232
user oracle oracle
binary
cd /home/oradata/232bakup
lcd /tmp/bakJW
put inkanetbackup.`date '+%y%m%d'`.dmp
prompt
close
bye !
#/etc/init.d/./crond restart
crontab -e
*/1 * * * * /home/oracle/bak/1.sh >> /home/oracle/bak/backup.log
自动备份数据库并将上一次备份数据删除,并压缩
#**************************
#根据不同的oracle安装路径,设置的路径不同
#
#**************************
ORACLE_BASE=/export/home/oracle/u01/app/oracle export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/oracle/product/10.2.0/db_1 export ORACLE_HOME
ORACLE_SID=orcl export ORACLE_SID
PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin export PATH
NLS_LANG=american_america.zhs16gbk export NLS_LANG
#RUNDATE=$(date +%y%m%d)
#SNDDIR=/export/home/oracle/bak
SNDDIR=/tmp/bakJW
echo $RUNDATE
echo $SNDDIR
rm -rf $SNDDIR/backup.*.dmp
/export/home/oracle/u01/app/oracle/oracle/product/10.2.0/db_1/bin/exp test/test@orcl file=$SNDDIR/inkanetbackup.`date '+%y%m%d'`.dmp
######### uploadftp #############
ftp -n<<!
open 11.10.92.232
user oracle oracle
binary
cd /home/oradata/232bakup
lcd /tmp/bakJW
put inkanetbackup.`date '+%y%m%d'`.dmp
prompt
close
bye !
#/etc/init.d/./crond restart