oracle11g+window2008数据库服务器数据本地和异地备份
1、oracle11g 数据库数据本地备份
数据库备份bat 脚本
@echo 准备导出数据
@mkdir D:\数据库备份\%date:~0,4%%date:~5,2%%date:~8,2%
@set oracle_sid=orcl1
@expdp user/123456 dumpfile=project-56-%date:~0,4%%date:~5,2%%date:~8,2%.dmp
@move E:\app\Administrator\product\11.2.0\dbhome_1\RDBMS\log\project-56-%date:~0,4%%date:~5,2%%date:~8,2%.dmp D:\数据库备份\%date:~0,4%%date:~5,2%%date:~8,2%
@echo 备份完毕
在数据库服务器操作系统中添加定时任务执行bat命令。

2、oracle11g 数据异地备份
在另外一台服务器上搭建ftp服务
window2008 搭建ftp服务 参见http://yveming.blog.51cto.com/2038161/769624
数据库备份bat脚本
@echo 准备导出数据
@mkdir D:\数据库备份\%date:~0,4%%date:~5,2%%date:~8,2%
@set oracle_sid=orcl1
@expdp project2/123456 dumpfile=project-56-%date:~0,4%%date:~5,2%%date:~8,2%.dmp
@move E:\app\Administrator\product\11.2.0\dbhome_1\RDBMS\log\project-56-%date:~0,4%%date:~5,2%%date:~8,2%.dmp D:\数据库备份\%date:~0,4%%date:~5,2%%date:~8,2%
@echo 备份完毕

@echo FTP上传到 应用服务器
echo open 192.16.1.1 >>temp.txt???????
echo user administrator>>temp.txt
echo 123>>temp.txt
echo put D:\数据库备份\%date:~0,4%%date:~5,2%%date:~8,2%\project-56-%date:~0,4%%date:~5,2%%date:~8,2%.dmp >>temp.txt
echo bye >>temp.txt
ftp -n -s:temp.txt
del? /q temp.txt
在数据库服务器操作系统中添加定时任务执行bat命令。