定时备份ORACLE数据库

1.写一back.bat

 

内容如下

 

e:
cd/
cd dbback
set abc=backup%date:~0,10%_%time:~1,2%_%time:~3,2%
md %abc%
cd %abc%
E:/oracle/product/10.1.0/db_1/BIN/exp user/password file=mydb.dmp full=y
pause

 

 

2.用windows的任务计划功能定时调用此BAT