Set up an Oracle database scheduled backup under Windows

1 Writing Backup scripts

1echo Backup Oracle Database ...2Echo%~dp03Set File_dir=%~dp04 5Echo Backup time ...6Set "year=%date:~0,4%"7Set "month=%date:~5,2%"8Set "day=%date:~8,2%"9Set "hour_ten=%time:~0,1%"TenSet "hour_one=%time:~1,1%" OneSet "minute=%time:~3,2%" ASet "second=%time:~6,2%" -  -Set MyDate the  - if"%hour_ten%" == " " ( -mydate=%year%%month%%day%0%hour_one%%minute%%second% -)Else( +mydate=%year%%month%%day%%hour_ten%%hour_one%%minute%%second% -) +  AExp User/[email protected] file=file_dir\yr_database_backup_%mydate%.dmp Owner=owner at 

2 Setting up Windows timer tasks

Open Control Panel-"Administrative Tools-" Task Scheduler-"Create basic tasks

Select the execution time of the task and the corresponding script

Set up an Oracle database scheduled backup under Windows