转载:本地每天定时备份数据库
转载: 本地每天定时备份数据库
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
