Windows下設定oracle資料庫定時備份

標籤：col   Owner   tab   執行   log   min   data   user   ...   

1編寫備份指令碼

  1 echo backup oracle database......  2 echo %~dp0  3 set file_dir=%~dp0  4   5 echo backup time......  6 set "year=%date:~0,4%"  7 set "month=%date:~5,2%"  8 set "day=%date:~8,2%"  9 set "hour_ten=%time:~0,1%" 10 set "hour_one=%time:~1,1%" 11 set "minute=%time:~3,2%" 12 set "second=%time:~6,2%" 13  14 set mydate 15  16 if "%hour_ten%" == " " ( 17     mydate=%year%%month%%day%0%hour_one%%minute%%second% 18 ) else ( 19     mydate=%year%%month%%day%%hour_ten%%hour_one%%minute%%second% 20 ) 21  22 exp USER/[email protected] file=file_dir\yr_database_backup_%mydate%.dmp owner=OWNER 23 

2設定windows定時任務

開啟 控制台-》管理工具-》工作排程器-》建立基本任務

選擇任務的執行時間和相應的指令碼

Windows下設定oracle資料庫定時備份