WINDOWS ORACLE备份脚本并且压缩为RAR格式

WINDOWS ORACLE备份脚本并且压缩为RAR格式

 

echo %date%
echo %date:~4,10%
set dir=E:/databak
set name=%dir%/%date:~4,10%
set filename=%dir%/%date:~4,10%.dmp
set logname=%dir%/%date:~4,10%.log

exp USERNAME/PASSWORD@PID  owner=USERNAME file=%filename% log=%logname% buffer=409600000 feedback=100000 direct=y consistent=n compress=n;
PATH=%PATH%;C:/Program Files/WinRAR
WinRAR a %name%.rar %name%.*
del %filename% %logname%

 

本脚本运行此需要安装oracle客户端和WinRAR.