oracle设置自动备份打包

exp username/password@tnsname file=d:\oa_db_bak\oauser%date:~0,10%.dmp owner=username log=d:\oa_db_bak\oauser%date:~0,10%.log
::将rar的可执行文件rar.exe的路径添加到系统的path里
Rar.exe a d:\oa_db_bak\oauser%date:~0,10%.rar d:\oa_db_bak\oauser%date:~0,10%.dmp
del d:\oa_db_bak\*%date:~0,10%.dmp

 新建一个bat文件，根据自己的环境修改上面的内容。在windows的建立定时任务定时备份

注意：在部分系统上时间格式是2013/xx/xx，导致脚本不能正确运行，故修改成如下：

exp username/password@tnsname file=E:\oa_db_bak\oauser%date:~0,4%%date:~5,2%%date:~8,2%.dmp owner=username log=E:\oa_db_bak\oauser%date:~0,4%%date:~5,2%%date:~8,2%.log
::将rar的可执行文件rar.exe的路径添加到系统的path里
Rar.exe a E:\oa_db_bak\oauser%date:~0,4%%date:~5,2%%date:~8,2%.rar E:\oa_db_bak\oauser%date:~0,4%%date:~5,2%%date:~8,2%.dmp
del E:\oa_db_bak\*%date:~0,4%%date:~5,2%%date:~8,2%.dmp