windows下expdp自动备份脚本

第一种方式：我自己用的脚本

set BACKUP_DIR=backup

set ORACLE_USERNAME=masicong

set ORACLE_PASSWORD=masicong

set ORACLE_DB=orcl

set BACK_OPTION=SCHEMAS=masicong

set RAR_CMD="C:\Program Files\WinRAR\Rar.exe"

set DUMPDIR=DIRECTORY=dump_dir

for /f "tokens=1,2" %%a in ('date/t') do set TODAY=%%a

set BACK_NAME=%ORACLE_DB%%TODAY%

set BACK_FULL_NAME=%BACK_NAME%

rem 开始备份

expdp %ORACLE_USERNAME%/%ORACLE_PASSWORD% %DUMPDIR%  %BACK_OPTION% dumpfile=%BACK_FULL_NAME%.dmp logfile=%BACK_FULL_NAME%exp.log

rem 压缩并剔除原有资料

%RAR_CMD% a -df "%BACK_FULL_NAME%back.rar" "%BACK_FULL_NAME%.dmp" "%BACK_FULL_NAME%exp.log"

PAUSE

第二种方式：

@echo off

@echo ======