oracle自动备份数据库

set BACKUP_DIR=G:\test
set ORACLE_USERNAME=scott
set ORACLE_PASSWORD=tiger
set ORACLE_SERVICE=orcl
set BACK_OPTION="owner=%ORACLE_USERNAME%"
set RAR_PATH="E:\Progra~1\WinRAR\RAR.exe"
set RESERVE_DAY=7


set EXP_TIME=%date:~0,10%_%time:~0,2%%time:~3,2%%time:~6,2%
set BACK_NAME=%ORACLE_SERVICE%_%ORACLE_USERNAME%_%EXP_TIME%

set BACK_FULL_NAME=%BACKUP_DIR%\%BACK_NAME%

echo %BACK_FULL_NAME%

rem 开始备份
exp %ORACLE_USERNAME%/%ORACLE_PASSWORD%@%ORACLE_SERVICE%  %BACK_OPTION% file="%BACK_FULL_NAME%.dmp" log="%BACK_FULL_NAME%.log"

rem 压缩并删除原有文件 
rem RAR a参数添加文件到压缩文件  d删除压缩文件中的文件 f刷新压缩文件中的文件
%RAR_PATH% a -df "%BACK_FULL_NAME%.rar" "%BACK_FULL_NAME%.dmp" "%BACK_FULL_NAME%.log"

rem 删除多少天前的文件 
rem forfiles /p %BACKUP_DIR%  /m %ORACLE_SERVICE%_%ORACLE_USERNAME%_* /d -%RESERVE_DAY% /c "cmd /c del @file /f"