Oracle计划自动备份数据库bat

 

@echo off

set dt=%date:~0,4%%date:~5,2%%date:~8,2%

set h=%time:~0,2%

if /i %h% LSS 10 (set h=0%time:~1,1%)

set t=%h%%time:~3,2%%time:~6,2%

exp orcluser/123456 owner=orcluser file=E:/orclbak/%dt%%t%.dmp log=D:/orclbaklog/%dt%%t%.log

"C:\Program Files\WinRAR\WinRAR.exe" a -ep E:/orclbakrar/%dt%%t%.rar "E:/orclbak/%dt%%t%.dmp"