使用批处理备份oracle数据库
来源:互联网 发布:2016美工电脑配置 编辑:程序博客网 时间:2024/06/11 15:06
@ECHO ON
SET BACKPATH=d:
SET FILENAME=%date:~0,4%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%%time:~6,2%
SET USERNAME=WAS
SET PASSWORD=WASUSER
SET DBNAME=WAS
ECHO 准备备份数据库
IF NOT EXIST %BACKPATH% GOTO NOPATH
IF NOT EXIST %BACKPATH%/DMP GOTO NODMPPATH
IF NOT EXIST %BACKPATH%/LOG GOTO NOLOGPATH
GOTO STARTWORK
:NOPATH
ECHO NOPATH
PAUSE
MKDIR %BACKPATH%
MKDIR %BACKPATH%/DMP
MKDIR %BACKPATH%/LOG
GOTO STARTWORK
:NODMPPATH
ECHO NODMPPATH
PAUSE
MKDIR %BACKPATH%/DMP
IF NOT EXIST %BACKPATH%/LOG GOTO NOLOGPATH
GOTO STARTWORK
:NOLOGPATH
ECHO NOLOGPATH
PAUSE
MKDIR %BACKPATH%/LOG
GOTO STARTWORK
:STARTWORK
ECHO STARTWORK
PAUSE
IMP %USERNAME%/%PASSWORD%@%DBNAME% FILE=%BACKPATH%/DMP/%FILENAME%.DMP LOG=%BACKPATH%/LOG/%FILENAME%.LOG
EXIT
SET BACKPATH=d:
SET FILENAME=%date:~0,4%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%%time:~6,2%
SET USERNAME=WAS
SET PASSWORD=WASUSER
SET DBNAME=WAS
ECHO 准备备份数据库
IF NOT EXIST %BACKPATH% GOTO NOPATH
IF NOT EXIST %BACKPATH%/DMP GOTO NODMPPATH
IF NOT EXIST %BACKPATH%/LOG GOTO NOLOGPATH
GOTO STARTWORK
:NOPATH
ECHO NOPATH
PAUSE
MKDIR %BACKPATH%
MKDIR %BACKPATH%/DMP
MKDIR %BACKPATH%/LOG
GOTO STARTWORK
:NODMPPATH
ECHO NODMPPATH
PAUSE
MKDIR %BACKPATH%/DMP
IF NOT EXIST %BACKPATH%/LOG GOTO NOLOGPATH
GOTO STARTWORK
:NOLOGPATH
ECHO NOLOGPATH
PAUSE
MKDIR %BACKPATH%/LOG
GOTO STARTWORK
:STARTWORK
ECHO STARTWORK
PAUSE
IMP %USERNAME%/%PASSWORD%@%DBNAME% FILE=%BACKPATH%/DMP/%FILENAME%.DMP LOG=%BACKPATH%/LOG/%FILENAME%.LOG
EXIT
- 使用批处理备份oracle数据库
- 使用批处理定时备份Oracle数据库(转)
- oracle数据库备份批处理
- 使用批处理备份mysql数据库
- 使用批处理(定时备份数据库)-
- 使用批处理(定时备份数据库)
- ORACLE采用批处理命令简单备份数据库
- windows下通过批处理备份oracle数据库
- 使用批处理命令+windows计划任务实现oracle数据库自动备份
- Oracle批处理备份
- 批处理备份oracle
- Oracle数据库定时自动备份批处理代码(Windows)
- Windows 下 Oracle数据库自动备份批处理脚本
- Windows下实现Oracle数据库定时自动备份批处理代码
- Windows Server 2003下Oracle数据库自动备份批处理脚本
- Oracle数据库定时自动备份批处理代码(Windows)
- Oracle 10g数据库自动备份[批处理.bat]
- oracle 备份数据库备份命令使用
- Spring XML配置十二个最佳实践
- VIEW_MAINTENANCE_CALL
- 大学4年应是这样度过
- 一个程序员的奋斗历程
- 怎样成为优秀的软件模型设计者?
- 使用批处理备份oracle数据库
- 励志篇:重新捡起JAVA
- 学习笔记(一)
- 学习笔记(二)
- Thinking in Java --- Chapter 1 (Notes)
- Windows Live Writer里对CSDN BLOG的配置
- connect to Gmail Imap using javamail
- 实例化函数
- 关于上传组件的配置