windows下定时备份oracle数据库

@echo off   
::Windows环境下Oracle数据库的自动备份脚本，如需删除，请先删除windows下相关定时任务
::使用当前日期命名备份文件。  
::以“YYYYMMDD”格式取出当前时间。  
set BACKUPDATE=%date:~0,4%%date:~5,2%%date:~8,2%
::创建备份目录。  
if not exist "D:\dbbackup\data\%BACKUPDATE%" mkdir D:\dbbackup\data\%BACKUPDATE%
if not exist "D:\dbbackup\log\%BACKUPDATE%" mkdir D:\dbbackup\log\%BACKUPDATE%
set DATADIR=D:\dbbackup\data
set LOGDIR=D:\dbbackup\log
set LOGDIR_DETIAL=D:\dbbackup\log\%BACKUPDATE%
set DATADIR_DETIAL=D:\dbbackup\data\%BACKUPDATE%
D:  
cd app\Administrator\product\11.2.0\dbhome_1\BIN
exp dbname/password@ORCL  file='%DATADIR_DETIAL%\dbname.dmp' log='%LOGDIR_DETIAL%\dbname.log'
::备份多个数据库可以继续写
exp dbname1/password@ORCL  file='%DATADIR_DETIAL%\dbname1.dmp' log='%LOGDIR_DETIAL%\dbname1.log'
::删除7天前的备份。  
forfiles /p "%DATADIR%" /s /m * /d -7 /c "cmd /c rd /q /s @path"
forfiles /p "%LOGDIR%" /s /m * /d -7 /c "cmd /c rd /q /s @path"
exit