window下的Oracle数据库定时备份

1、创建备份脚本：oracle_backup.bat

@echo off

forfiles /p "E:\backup_db" /d -30 /c "cmd /c echo deleting @file ... && del /f @path" 
echo 执行完成！

set SIDDISCRIBE=IP:1521/orcl
set DIRECTIONPATH=E:\backup_db

set hour=%time:~,2%
if "%time:~,1%"==" " set hour=0%time:~1,1%
set TIMESTYLE=%date:~0,4%-%date:~5,2%-%date:~8,2%
echo ============================================
echo 创建文件夹
echo ============================================
md E:\backup_db\%TIMESTYLE%


echo ============================================
echo 设置数据库参数
echo ============================================
set USERNAME=pdbds
set PASSWORD=pdbds
set CONDETION=%USERNAME%/%PASSWORD%@%SIDDISCRIBE%

echo ============================================
echo 设置数据库导出文件、日志文件、压缩文件路径属性名称
echo ============================================
set FILEPATH=%DIRECTIONPATH%/%TIMESTYLE%/%USERNAME%.dmp
set LOGPATH=%DIRECTIONPATH%/%TIMESTYLE%/%USERNAME%.log

echo ============================================
echo 按照日期备份Oracle数据库，请稍等......
echo ============================================

exp userid=%CONDETION% file=%FILEPATH% log=%LOGPATH%

echo 备份完成！

2、windows任务计划程序设置程序定时任务

请参考：https://jingyan.baidu.com/article/154b463130041128ca8f41c7.html