Windows下设置oracle数据库定时备份

1编写备份脚本

echo backup oracle database......
echo %~dp0
set file_dir=%~dp0

echo backup time......
set "year=%date:~0,4%"
set "month=%date:~5,2%"
set "day=%date:~8,2%"
set "hour_ten=%time:~0,1%"
set "hour_one=%time:~1,1%"
set "minute=%time:~3,2%"
set "second=%time:~6,2%"

set mydate

if "%hour_ten%" == " " (
    mydate=%year%%month%%day%0%hour_one%%minute%%second%
) else (
    mydate=%year%%month%%day%%hour_ten%%hour_one%%minute%%second%
)

exp USER/PWD@SID file=file_dir\yr_database_backup_%mydate%.dmp owner=OWNER

2设置windows定时任务

打开 控制面板-》管理工具-》任务计划程序-》创建基本任务

选择任务的执行时间和相应的脚本