通过编写dos命令脚本生成批处理命令文件，然后在主机服务器上添加计划任务来实现。
 
备份方法：
 
在任何磁盘上根目录下新建bak文件夹，在bak文件夹中新建week0.dmp，将下面的dos命令复制到新建txt中，把x:修改为实际的路径，然后将*.txt命令为zlautoexp.bat批处理文件。
 
@ECHOOFF
 
 
IFEXIST X:bakWEEK0.DMP X:Oracleproduct10.2.0db_1BINExp.exe userid=sys/hisbuffer=4096 file=X:bakWeekBak0.dmp grants=y full=y
 
IFEXIST X:bakWEEK1.DMP X:oracleproduct10.2.0db_1BINExp.exe userid=sys/hisbuffer=4096 file=X:bakWeekBak1.dmp grants=y full=y
 
IFEXIST X:bakWEEK2.DMP X:oracleproduct10.2.0db_1BINExp.exe userid=sys/hisbuffer=4096 file=X:bakWeekBak2.dmp grants=y full=y
 
IFEXIST X:bakWEEK3.DMP X:oracleproduct10.2.0db_1BINExp.exe userid=sys/hisbuffer=4096 file=X:bakWeekBak3.dmp grants=y full=y
 
IFEXIST X:bakWEEK4.DMP X:oracleproduct10.2.0db_1BINExp.exe userid=sys/hisbuffer=4096 file=X:bakWeekBak4.dmp grants=y full=y
 
IFEXIST X:bakWEEK5.DMP X:oracleproduct10.2.0db_1BINExp.exe userid=sys/hisbuffer=4096 file=X:bakWeekBak5.dmp grants=y full=y
 
IFEXIST X:bakWEEK6.DMP X:oracleproduct10.2.0db_1BINExp.exe userid=sys/hisbuffer=4096 file=X:bakWeekBak6.dmp grants=y full=y
 
 
 
IFEXIST X:bakWEEK6.DMP REN X:bakWEEK6.DMP WEEK7.DMP
 
IFEXIST X:bakWEEK5.DMP REN X:bakWEEK5.DMP WEEK6.DMP
 
IFEXIST X:bakWEEK4.DMP REN X:bakWEEK4.DMP WEEK5.DMP
 
IFEXIST X:bakWEEK3.DMP REN X:bakWEEK3.DMP WEEK4.DMP
 
IFEXIST X:bakWEEK2.DMP REN X:bakWEEK2.DMP WEEK3.DMP
 
IFEXIST X:bakWEEK1.DMP REN X:bakWEEK1.DMP WEEK2.DMP
 
IFEXIST X:bakWEEK0.DMP REN X:bakWEEK0.DMP WEEK1.DMP
 
IFEXIST X:bakWEEK7.DMP REN X:bakWEEK7.DMP WEEK0.DMP
 
@ECHOON
 
 
然后在控制面板的计划任务添加zlautoexp的计划任务执行时间，根据用户的需求来调整备份时间，使用administrator用户必须给该用户添加密码。
 
 
或者在dos命令提示符下输入以下命令可以实现自动备份:
 
at2:00 /every:m,t,w,th,f,s,su "X:bakzlautoexp.bat"
 
时间        每周七天        自动备份文件路径
 
 
同理在zlautoexp中添加主机字符串，同样可以在工作站上实现异地自动逻辑备份。
 
添加自动备份任务：保证服务里Task Scheduler打开，而且在命令提示符中输入的自动备份命令完全是在后台自动执行，前台不会出现任何提示。

您可能感兴趣的文章: