文件名称:数据库自动备份.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