玛卡枸杞酒的功效:oracle 自动备份批处理文件
来源:百度文库 编辑:偶看新闻 时间:2024/04/30 08:16:52
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
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
windows环境下oracle自动备份
AIX+ORACLE如何实现数据自动备份?
如何编写自动批处理文件
我对我系统做了个ghost备份并生成了一个批处理文件,刻到光盘中怎样让批处理文件自动执行
Oracle数据远程备份与远程恢复
初学者,Oracle中怎么备份数据表,谢谢!
如何修改自动批处理文件AUTOEXEC.BAT?
自动创建用户的批处理文件命令?
DOS自动批处理文件的全名是什么?
自动输密码批处理文件的问题
批处理文件
批处理文件
自动批处理文件要怎么样才不会开机自动运行呢?
自动批处理文件要怎么样才不会开机自动运行呢
自动备份软件
自动备份文件夹问题???
sql server2000自动备份
自动备份工具
硬盘数据为何自动备份
在oracle中怎样用光盘做增量备份
oracle 备份的命令提示符是什么? (加急)
Oracle新手诚心请教,数据库机器间备份问题??
doc系统中,自动执行的批处理文件的文件名是什么.
如何使用批处理文件自动将文件生成桌面快捷键?