转载:本地每天定时备份数据库
转载: 本地每天定时备份数据库
http://relic6.iteye.com/blog/1172380
将以下保存为.bat文件就行了

    @echo off       set txt1=%date:~0,4%       ::当前年       set txt2=%date:~5,2%       ::当前月       set txt3=%date:~8,2%       ::当前日       set txt4=%time:~0,2%       ::当前小时       set txt5=%time:~3,2%       ::当前分钟       set txt6=%time:~6,2%       set day=%txt3: =%    set date=%txt1%%txt2%%day%      set time=%txt4%%txt5%%txt6%      set name=%date: =-%      echo --------------------------------------------------       echo -------------正在执行oracle数据库备份--------------       echo --------------------------------------------------       echo ...       echo ...       echo 导出oracle数据...       if exist %name%.dmp del %name%.dmp       D:\Oracle\product\10.1.0\Client_1\BIN\exp xxx/xxx@xxx file=F:\backup\%name%.dmp    echo ...       echo ...       echo 备份完成!       exit  

注意你只要修改一段设置代码就行了,换成你自己的配置!
D:\Oracle\product\10.1.0\Client_1\BIN\exp xxx/xxx@xxx file=F:\backup\%name%.dmp
注意事项:F盘的backup文件夹必须存在,否则报错,不能执行
另外你可参见http://relic6.iteye.com/blog/1172380做成Windows的计划任务!