@echo off
Set OrclSid=10.112.4.3/ORCL
Set ExpUser=LY_IS
Set ExpPass=LY_IS
Set FileDir=C:\Users\Administrator\Desktop\ISMP_BAK\BACK_UP
Set SysDate=%date:~0,4%-%date:~5,2%-%date:~8,2%
Set FileName=%ExpUser%_%SysDate%
@echo * * * * * * * * * * * * * * * * * * * *
@echo * * * * * * * * * * * * * * * * * * * *
@echo * * * * * ORACLE 数据库备份 * * * * * *
@echo * * * * * * * * * * * * * * * * * * * *
@echo * * * * * * * * * * * * * * * * * * * *
@echo 服务名 = %OrclSid%
@echo 用户名 = %ExpUser%
@echo 密 码 = %ExpPass%
@echo 目 录 = %FileDir%
@echo 时 间 = %SysDate%
@echo 文件名 = %FileName%
@echo 开始备份数据库...
exp %ExpUser%/%ExpPass%@%OrclSid% file=%FileDir%/%FileName%.dmp log=%FileDir%/%FileName%.log
@echo 数据库备份完成!
@echo 开始删除7天以上的数据
forfiles /p %FileDir% /m *.log -d -7 /c "cmd /c del /f @path"
forfiles /p %FileDir% /m *.dmp -d -7 /c "cmd /c del /f @path"