Oracle 创建自动执行的exp任务

Oracle 创建自动执行的exp任务

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