windows系统oracle备份bat脚本

@echo off
::以“YYYYMMDD”格式取出当前时间。
set BACKUPDATE=%date:~0,4%%date:~5,2%%date:~8,2%
::设置用户名、密码和要备份的数据库。
set USER=system
set PASSWORD=root
set DATABASE=dzjg
set USER_USE=mr
::创建备份目录.
if not exist "D:\app\DZJG_Backup\%USER_USE%"       mkdir D:\app\DZJG_Backup\%USER_USE%
if not exist "D:\app\DZJG_Backup\%USER_USE%\log"        mkdir D:\app\DZJG_Backup\%USER_USE%\log
set DATADIR=D:\app\DZJG_Backup\%USER_USE%
set LOGDIR=D:\app\DZJG_Backup\%USER_USE%\log

expdp %USER%/%PASSWORD%@%DATABASE% directory=DZJG_Backup dumpfile=%USER_USE%_%BACKUPDATE%.dmp log=%USER_USE%_%BACKUPDATE%.log schemas=%USER_USE%

del "D:\app\DZJG_Backup\.dmp"
move "D:\app\DZJG_Backup\%USER_USE%_%BACKUPDATE%.dmp" "D:\app\DZJG_Backup\%USER_USE%\"
move "D:\app\DZJG_Backup\%USER_USE%_%BACKUPDATE%.log" "D:\app\DZJG_Backup\%USER_USE%\log\"

::删除14天前的备份.
forfiles /p "%DATADIR%" /s /m *.* /d -14 /c "cmd /c del @path"
forfiles /p "%LOGDIR%" /s /m *.* /d -14 /c "cmd /c del @path"
exit