linux备份文件到ftp上,linux下自动备份数据库及利用ftp自动备份文件到备份服务器的脚本...

!/bin/sh

#oracle backup

##########################

#./etc/profile

#.~/.bash_profile

##########################

START_DATE=`date`

DATE=`date +"%y%m%d"`

cd /oracle/dmp

export ORACLE_SID=sypec

export ORACLE_HOME=/oracle/app/product/9.2.0.4

rm -f *.dmp

rm -f *.gz

echo "exp TEST start!" > backup.log

/oracle/app/product/9.2.0.4/bin/exp userid="\"sys/****** as

sysdba\"" file=/oracle/dmp/dbbackup.dmp

log=/oracle/dmp/dbbackup.log full=y statistics=none

if [ $? != 0 ] ; then

ERR_MSG="Data exported failure!!!"

fi

echo "exp test step2!" >> backup.log

EXPORT_MSG=`tail -1

/oracle/dmp/exp_bak/dbbackuplog/dbbackup.log`

tar czf "$DATE".tar.gz dbbackup.dmp

END_DATE=`date`

echo "other message:"$ERR_MSG >>

/oracle/dmp/exp_bak/dbbackuplog/backup.log

echo "export message:"$EXPORT_MSG >>

/oracle/dmp/exp_bak/dbbackuplog/backup.log

echo "*Backup time: "$START_DATE" - "$END_DATE >>

/oracle/dmp/exp_bak/dbbackuplog/backup.log

cp *.gz /oracle/dmp/exp_bak

cd /home/oracle/script

rm put_tar.sh

echo "#!/bin/sh" >> /home/oracle/script/put_tar.sh

echo "#ftp backup file to 10.101.0.6" >>

/home/oracle/script/put_tar.sh

echo "START_DATE=`date`" >>

/home/oracle/script/put_tar.sh

echo "DATE=`date +"%y%m%d"`" >>

/home/oracle/script/put_tar.sh

echo "open 10.101.0.6 21" >>

/home/oracle/script/put_tar.sh

echo "user oracle tiuboracle" >>

/home/oracle/script/put_tar.sh

echo "bin" >> /home/oracle/script/put_tar.sh

echo "prompt" >> /home/oracle/script/put_tar.sh

echo "cd /u01/oraback" >>

/home/oracle/script/put_tar.sh

echo "lcd /oracle/dmp" >>

/home/oracle/script/put_tar.sh

echo "put "$DATE".tar.gz" >>

/home/oracle/script/put_tar.sh

echo "quit" >> /home/oracle/script/put_tar.sh

ftp -n