windows的oracle备份（加日期＆时间）配合任务划可以做到每天定时备份。

windows的oracle备份（加日期＆时间）配合任务划可以做到每天定时备份。

@echo off
title 每周五下午6点定时备份正式库程序
color 0F
set dmpname=szsdh-%date:~0,10%-%time:~0,5%
set dmpname=%dmpname::=-%

set dmpname=%dmpname: =0%
echo %dmpname%
set NLS_LANG=AMERICAN_AMERICA.ZHS16CGB231280
exp user/pass@sid file=E:/dmp/%dmpname%.dmp log=E:/dmp/%dmpname%.log
"C:/Program Files/WinRAR/rar.exe" a E:/dmp/%dmpname%.rar E:/dmp/%dmpname%.*
rem "D:/Program Files/7-Zip/7z.exe" a -tzip E:/dmp/%dmpname%.7z E:/dmp/%dmpname%.*
exit