教学效果评价指标体系:oracle 自动备份批处理文件

来源:百度文库 编辑:中财网 时间:2024/04/29 05:44:33
oracle 自动备份批处理文件 2007-02-13 10:55:06标签:Oracle 备份 批处理 原创作品,允许转载,转载时请务必以超链接形式标明文章 原始出处 、作者信息和本声明。否则将追究法律责任。http://sam2080.blog.51cto.com/25153/17695 以下为ORACLE 自动备份批处理文件内容,请配合任务计划实现   @ECHO OFF
SET BACKPATH=d:\ ECHO 准备备份数据库
REM 7天一个循环 IF EXIST %BACKPATH%\ONE GOTO ONE
IF EXIST %BACKPATH%\TWO GOTO TWO
IF EXIST %BACKPATH%\THREE GOTO THREE
IF EXIST %BACKPATH%\FOUR GOTO FOUR
IF EXIST %BACKPATH%\FIVE GOTO FIVE
IF EXIST %BACKPATH%\SIX GOTO SIX
IF EXIST %BACKPATH%\SEVEN GOTO SEVEN ECHO E > %BACKPATH%\ONE
:ONE
SET BACKPATH_FULL=%BACKPATH%\ONE
REN %BACKPATH%\ONE TWO
GOTO BACK:TWO
SET BACKPATH_FULL=%BACKPATH%\TWO
REN %BACKPATH%\TWO THREE
GOTO BACK :THREE
SET BACKPATH_FULL=%BACKPATH%\THREE
REN %BACKPATH%\THREE  FOUR
GOTO BACK :FOUR
SET BACKPATH_FULL=%BACKPATH%\FOUR
REN %BACKPATH%\FOUR FIVE
GOTO BACK :FIVE
SET BACKPATH_FULL=%BACKPATH%\FIVE
REN %BACKPATH%\FIVE SIX
GOTO BACK :SIX
SET BACKPATH_FULL=%BACKPATH%\SIX
REN %BACKPATH%\SIX SEVEN
GOTO BACK :SEVEN
SET BACKPATH_FULL=%BACKPATH%\SEVEN
REN %BACKPATH%\SEVEN ONE
GOTO BACK :BACK
EXP TESTUSER/TEST FILE=%BACKPATH_FULL%.DMP SET BACKPATH=
SET BACKPATH_FULL= EXIT
 

本文出自 “沉默的蚂蚁” 博客,请务必保留此出处http://sam2080.blog.51cto.com/25153/17695