oracle数据库备份、windows设置定时任务步骤
1、数据库备份文件,命名为xx.bat保存
@echo 删除7天前的备份记录
forfiles /p "E:\app\Administrator\admin\orcl\dpdump" /m *.log -d -7 /c "cmd /c del /f @path"
forfiles /p "E:\app\Administrator\admin\orcl\dpdump" /m *.dmp -d -7 /c "cmd /c del /f @path"
@echo 备份
expdp username/password@orcl schemas=schema directory=DATA_PUMP_DIR DUMPFILE=wc%date:~0,4%%date:~5,2%%date:~8,2%0%time:~1,1%%time:~3,2%%time:~6,2%.dmp logfile=wc%date:~0,4%%date:~5,2%%date:~8,2%0%time:~1,1%%time:~3,2%%time:~6,2%explog.log
2、创建定时任务
参考链接: