Oracle数据库自动备份

1.bat脚本格式为ANSI格式

set CURDATE=%date:~0,4%%date:~5,2%%date:~8,2%
set CURMON=%date:~0,4%%date:~5,2%
set CURTIME=%time:~0,2%
if "%CURTIME%"==" 0" set CURTIME=00
if "%CURTIME%"==" 1" set CURTIME=01
if "%CURTIME%"==" 2" set CURTIME=02
if "%CURTIME%"==" 3" set CURTIME=03
if "%CURTIME%"==" 4" set CURTIME=04
if "%CURTIME%"==" 5" set CURTIME=05
if "%CURTIME%"==" 6" set CURTIME=06
if "%CURTIME%"==" 7" set CURTIME=07
if "%CURTIME%"==" 8" set CURTIME=08
if "%CURTIME%"==" 9" set CURTIME=09
set CURTIME=%CURTIME%%time:~3,2%%time:~6,2%
set OWNER=数据库名称
set USER=用户名
set PASSWORD=密码
set RAR_CMD="C:\Program Files\WinRAR\WinRAR.exe"
for /f "tokens=1,2" %%a in ('date/t') do set TODAY=%%a

if not exist "DATABACK_DIR" mkdir DATABACK_DIR
cd DATABACK_DIR
if not exist "%CURMON%" mkdir %CURMON%
set FILENAME=%CURMON%/%OWNER%_%CURDATE%_%CURTIME%
set EXPLOG=%CURMON%/%OWNER%_%CURDATE%_%CURTIME%
exp %USER%/%PASSWORD%@%OWNER% file=%FILENAME%.dmp log=%FILENAME%exp.log owner=%USER% grants=n
%RAR_CMD% a -df "%FILENAME%back.rar" "%FILENAME%.dmp" "%FILENAME%exp.log"
exit

脚本可以直接复制修改使用