目標：

定時導出：利用計劃任務

自動壓縮：使用命令行的rar

自動按月存儲：利用cmd

代碼：

Cmd代碼

@echo一定要進入指定路徑,否則運行不正常

@setbk_path=G:/Database_bak

@setrar_path=d:/WinRAR

@setowner=erp_beijing_exp

@setuserid=%owner%/erp_beijing_exp@dbsvr

@echoon

@CLS

@echo歡迎使用自動導庫程序

@echo開始執行

@echo進入目錄:%bk_path%

@%bk_path:~0,2%

@cd%bk_path%

cd

setTHE_MONTH=%DATE:~0,4%-%DATE:~5,2%

setTHE_DATE=%THE_MONTH%-%DATE:~8,2%

echo%THE_DATE%

setMY_HOUR=%time:~0,2%

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

SETMY_DATE=%THE_DATE%_%MY_HOUR%-%TIME:~3,2%-%TIME:~6,2%

@echo當前時間%THE_DATE%

@setfilename=%MY_DATE%_%username%

exp.exeuserid="%userid%"owner=%owner%file=%filename%.dmplog=%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

@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

遇到的問題和解決：

文件名中：小時在10點之前為“ X”有個空格導致文件名出問題，解決set MY_HOUR=%time:~0,2%

Cmd代碼

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

總結

以上是生活随笔為你收集整理的oracle导出库压缩参数,oracle数据库的定时备份：导出 压缩 归类的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。