# Windows Oracle自动备份脚本
set backupfile=crm%date:~0,4%-%date:~5,2%-%date:~8,2%.dmp
--数据文件名
set logfile=crm%date:~0,4%-%date:~5,2%-%date:~8,2%.log
--日志文件名
D:\app\Administrator\product\11.2.0\dbhome_1\BIN\expdp coremail2016/123456@orcl directory=WSCDIR schemas=coremail2016 dumpfile=%backupfile% logfile=%logfile%
--备份命令
forfiles /p "D:\databack" /d -10 /c "cmd /c echo deleting @file ... && del /f @path"
--删除10天前备份