Oracle数据泵自动备份压缩复制bat工具

@echo off 
set Ymd=%date:~,4%%date:~5,2%%date:~8,2% 
 
set backuppath="D:\app\Administrator\admin\orcl\dpdump\"

expdp 用户名/用户名密码@实例名 schemas=用户名 directory=data_pump_dir dumpfile=%date:~,4%%date:~5,2%%date:~8,2%.dmp logfile=%date:~,4%%date:~5,2%%date:~8,2%.log

"C:\Program Files\WinRAR\rar.exe"  a  D:\app\Administrator\admin\orcl\dpdump\%date:~,4%%date:~5,2%%date:~8,2%.rar D:\app\Administrator\admin\orcl\dpdump

DEL %backuppath%*.DMP
DEL %backuppath%*.log

xcopy "D:\app\Administrator\admin\orcl\dpdump\%date:~,4%%date:~5,2%%date:~8,2%.rar" "D:\ftpfile\NC6.5_backup\"

GOTO END
:END
echo on

以上中文部分根据实际情况修改，路径可以自定义添加或者使用Oracle的自带的路径

expdp命令参考地址:

oracle数据泵备份（Expdp命令） - 大地爱老虎油 - 博客园