- 论坛徽章:
- 0
|
ORACLE 数据远程备份,此乃转贴
本机IP:192.168.0.1
远程IP:192.168.0.111
备份脚本
ora_bak.sh
-------------------------------
rq=`date +%m%d_%H%M`
exp examusr01/exampwd01 file=/opt/ora9/backup/temp/examusr01_$rq.dmp log=/opt/ora9/backup/logs/bkplog_$rq
tar -cvzf /opt/ora9/backup/tmep/examusr01_$rq.tar.gz /opt/ora9/backup/temp/examusr01_$rq.dmp&&rm -f /opt/ora9/backup/temp/examusr01_$rq.dmp&&echo "Congratulations,your dmp file has been compressed correctly at $rq!" >>/opt/ora9/backup/logs/bkplog_$rq.log
移动脚本
move.sh
-----------------------------
mv /opt/ora9/backup/temp/* /opt/ora9/backup/
首先将数据库数据导出并压缩在/opt/ora9/backup/temp/目录下,当通过ftp上传到远程服务器后,移动到/opt/ora9/backup/目录下,这样oracle数据就在本机和远程2台服务器上有备份
FTP脚本
.netrc
-------------------------------------
machine 192.168.0.111
login oracle
passwd oracle
macdef init
binary
lcd /opt/ora9/backup/temp
cd /opt/ora9/racexambkp
put *
prompt
bye
将/opt/ora9/backup/temp的备份文件上传到111服务器的/opt/ora9/racexambkp目录中
编辑crontab
----------------------------------
$ crontab –e
0 2 * * * /opt/ora9/ora-backup.sh
15 2 * * * /usr/bin/ftp –i 192.168.0.20
25 2 * * * /opt/ora9/move.sh
30 12 * * * /opt/ora9/ora-backup.sh
45 12 * * * /usr/bin/ftp –i 192.168.0.20
55 12 * * * /opt/ora9/move.sh |
|