oracle 备份在windows中使用批处理文件

@echo off

echo 设置备份文件存放文件夹...

set "tbuf=D:\Backup_Oracle_ORCL"
set mdate=%date%

set mtime=%time%

set mdate=%mdate:~0,10%

set mtime=%mtime:~0,2%_%mtime:~3,2%_%mtime:~6,2%

set name=ORCL_backup_%mdate%_%mtime%

echo 是否存在同名文件，若存在则删除同名文件...

if exist %tbuf%\%name%.dmp del %tbuf%\%name%.dmp

if exist %tbuf%\%name%.log del %tbuf%\%name%.log

echo 开始备份(备份整个数据库)....

exp jhtest/jhtest full=y file=%tbuf%\%name%.dmp log=%tbuf%\%name%.log

echo 备份完毕!