@echo off
Set OrclSid=orcl
Set ExpUser=demo2
Set ExpPass=demo2
Set FileDir=D:\backupTest\dmp
Set YYYYmmdd=%date:~0,4%%date:~5,2%%date:~8,2%
Set hhmiss=%time:~0,2%%time:~3,2%%time:~6,2%
Set hhmiss=%hhmiss: =0%
Set SysDate=%YYYYmmdd%_%hhmiss%
Set FileName=%ExpUser%_%OrclSid%_%SysDate%
@echo * * * * * * * * * * * * * * * * * * * *
@echo * * * * * * * * * * * * * * * * * * * *
@echo * * * * * ORACLE 数据库备份 * * * * * *
@echo * * * * * * * * * * * * * * * * * * * *
@echo * * * * * * * * * * * * * * * * * * * *
@echo 服务名 = %OrclSid%
@echo 用户名 = %ExpUser%
@echo 密 码 = %ExpPass%
@echo 目 录 = %FileDir%
@echo 时 间 = %SysDate%
@echo 文件名 = %FileName%.rar
@echo 开始备份数据库...
exp %ExpUser%/%ExpPass%@%OrclSid% file=%FileDir%/%FileName%.dmp owner=%ExpUser% log=%FileDir%/%FileName%.log
@echo 数据库备份完成!
forfiles /p %FileDir% /s /m *.* -d -30 /c "cmd /c del /f @path"
@echo 清除备份完成!