使用时删除注解//
echo 开始备份数据库
if not exist D:\db_bak\files md D:\db_bak\files //创建目录
if not exist D:\db_bak\logs md D:\db_bak\logs //创建日志目录
set var=%Date:~0,4%%Date:~5,2%%Date:~8,2%_%time:~0,2%%time:~3,2%%time:~6,2% //设置文件日期格式
exp esdkj/esdkj@127.0.0.1/ORCL file=D:\db_bak\files\nemo_%var%.dmp log=D:\db_bak\logs\nemo_%var%.log //执行导出
echo 删除过久的备份记录 28天前
forfiles /p "D:\db_bak\files" /s /m *.dmp /d -10 /c "cmd /c del @path"
forfiles /p "D:\db_bak\logs" /s /m *.log /d -10 /c "cmd /c del @path"
exit
参考:https://blog.csdn.net/iteye_16140/article/details/82675990