backup.bat

    1. set RAR_CMD="C:\Program Files\WinRAR\WinRAR.exe"
    3. set USERNAME=SYSTEM
    5. set PASSWORD=SYSTEM
    7. set SIDDISCRIBE=ZHLIS
    8. set CONDETION1=%USERNAME%/%PASSWORD%@%SIDDISCRIBE%
    10. set DIRECTIONPATH=F:/BAK/I-BAK/MSSQL/bsrun/LIS_backup/LIS
    12. set FILENAME=LIS
    14. set hour=%time:~,2%
    17. if "%time:~,1%"==" " set hour=0%time:~1,1%
    19. set TIMESTYLE=%date:~0,4%-%date:~5,2%-%date:~8,2%-%hour%-%time:~3,2%-%time:~6,2%
    21. set FILEPATH=%DIRECTIONPATH%/%FILENAME%_%TIMESTYLE%.dmp
    23. set LOGPATH=%DIRECTIONPATH%/%FILENAME%_%TIMESTYLE%.log
    25. set RARPATH=%DIRECTIONPATH%/%FILENAME%_%TIMESTYLE%.rar
    27. echo ============================================
    29. echo 正在备份Oracle数据库，请稍等......
    31. echo ============================================
    33. exp userid=%CONDETION1% file=%FILEPATH% log=%LOGPATH% full=y
    35. echo 备份完成！
    37. echo ============================================
    39. echo 压缩备份文件，请稍等......
    41. echo ============================================
    43. %RAR_CMD% a -df "%RARPATH%" "%FILEPATH%" "%LOGPATH%"
    45. echo 压缩完成！
    48. echo ============================================
    50. echo 正在计算压缩文件数量.....
    52. set DirName=F:/BAK/I-BAK/MSSQL/bsrun/LIS_backup/LIS
    53. pushd "%DirName%"
    54. set  f=rar
    56. for /f %%i in ('dir /b /s /a-d *.%f% ^| find "." /c') do set s=%%i
    58. echo %f% 文件数量有：%s%
    60. if %s% equ 61 (
    62. set p=F:/BAK/I-BAK/MSSQL/bsrun/LIS_backup/LIS
    63. for /f %%i in ('dir %p% /a-d *.%f% ^/b /od /tc') do del %%i /a /f &goto x 
    64. :x
    65. echo 删除成功！
    66. )