数据库自动备份.bat

时间:2012-09-18 05:28:53
【文件属性】:

文件名称:数据库自动备份.bat

文件大小:1007B

文件格式:BAT

更新时间:2012-09-18 05:28:53

数据库自动备份.bat

oracle 数据库自动备份: if not exist d:\数据库备份 md d:\数据库备份 if not exist d:\数据库备份\OLD md d:\数据库备份\OLd if not exist d:\数据库备份\log md d:\数据库备份\log if exist D:\数据库备份\new_ylqfs%Date:~0,4%%Date:~5,2%%Date:~8,2%.dmp goto new goto export :export echo export oracle Database start,please wait........ ! exp new_ylqfs/new_ylqfs@ylcz file=d:\数据库备份\new_ylqfs%Date:~0,4%%Date:~5,2%%Date:~8,2%.dmp log=d:\数据库备份\log\backup.log goto end :new echo REname and move NewFIle as Oldfile.......! move d:\数据库备份\new_ylqfs%Date:~0,4%%Date:~5,2%%Date:~8,2%.dmp d:\数据库备份\Old ren d:\数据库备份\Old\new_ylqfs%Date:~0,4%%Date:~5,2%%Date:~8,2%.dmp old_new_ylqfs%Date:~0,4%%Date:~5,2%%Date:~8,2%.dmp goto export :end C:\Progra~1\WinRAR\winrar a -r d:\数据库备份\new_ylqfs%Date:~0,4%%Date:~5,2%%Date:~8,2%.rar d:\数据库备份\new_ylqfs%Date:~0,4%%Date:~5,2%%Date:~8,2%.dmp del d:\数据库备份\new_ylqfs%Date:~0,4%%Date:~5,2%%Date:~8,2%.dmp echo export oracle Database ok ! exit


网友评论

  • 蛮好的,正在用,效果不错。