oracle数据库的定时备份：导出 压缩 归类

http://skzr-org.javaeye.com/blog/811491

目标：

1. 定时导出：利用计划任务
2. 自动压缩：使用命令行的rar
3. 自动按月存储：利用cmd

代码：

Cmd代码

1. @echo一定要进入指定路径,否则运行不正常
2. @setbk_path=G:/Database_bak
3. @setrar_path=d:/WinRAR
4. @setowner=erp_beijing_exp
5. @setuserid=%owner%/erp_beijing_exp@dbsvr
6. @echoon
7. @CLS
8. @echo欢迎使用自动导库程序
9. @echo开始执行
10. @echo进入目录:%bk_path%
11. @%bk_path:~0,2%
12. @cd%bk_path%
13. cd
14. setTHE_MONTH=%DATE:~0,4%-%DATE:~5,2%
15. setTHE_DATE=%THE_MONTH%-%DATE:~8,2%
16. echo%THE_DATE%
17. setMY_HOUR=%time:~0,2%
18. if"%time:~0,1%"==""setMY_HOUR=0%time:~1,1%
20. SETMY_DATE=%THE_DATE%_%MY_HOUR%-%TIME:~3,2%-%TIME:~6,2%
21. @echo当前时间%THE_DATE%
22. @setfilename=%MY_DATE%_%username%
23. exp.exeuserid="%userid%"owner=%owner%file=%filename%.dmplog=%filename%-exp.log
24. "%rar_path%/rar"a-k-t-s-m5-mc63:128t+-mdg-df%filename%.rar%filename%*.*
25. MKDIR%bk_path%/%THE_MONTH%
26. MOVE%bk_path%/*%THE_DATE%*.*%bk_path%/%THE_MONTH%
27. exit

@echo 一定要进入指定路径,否则运行不正常
@set bk_path=G:/Database_bak
@set rar_path=d:/WinRAR
@set owner=erp_beijing_exp
@set userid=%owner%/erp_beijing_exp@dbsvr
@echo on
@CLS
@echo 欢迎使用自动导库程序
@echo 开始执行
@echo 进入目录: %bk_path%
@%bk_path:~0,2%
@cd %bk_path%
cd
set THE_MONTH=%DATE:~0,4%-%DATE:~5,2%
set THE_DATE=%THE_MONTH%-%DATE:~8,2%
echo %THE_DATE%
set MY_HOUR=%time:~0,2%
if "%time:~0,1%"==" " set MY_HOUR=0%time:~1,1%

SET MY_DATE=%THE_DATE%_%MY_HOUR%-%TIME:~3,2%-%TIME:~6,2%
@echo 当前时间%THE_DATE%
@set filename=%MY_DATE%_%username%
exp.exe userid="%userid%" owner=%owner% file=%filename%.dmp log=%filename%-exp.log
"%rar_path%/rar" a -k -t -s -m5 -mc63:128t+ -mdg -df %filename%.rar %filename%*.*
MKDIR %bk_path%/%THE_MONTH%
MOVE %bk_path%/*%THE_DATE%*.* %bk_path%/%THE_MONTH%
exit

遇到的问题和解决：

1. 文件名中：小时在10点之前为“ X”有个空格导致文件名出问题，解决set MY_HOUR=%time:~0,2%
   Cmd代码

   1. if"%time:~0,1%"==""setMY_HOUR=0%time:~1,1%

   if "%time:~0,1%"==" " set MY_HOUR=0%time:~1,1%