Oracle数据库自动备份脚本.txt

1页

5次

2024-02-24

免费下载

@echo off

REM 请设置备份参数

Set OrclSid=docare

Set ExpUser=medemr

Set ExpPass=medemr

Set FileDir=D:\OraBAK\MEDEMR

Set WinRarDir=C:\Program Files (x86)\WinRAR

Set SysDate=%date:~0,4%-%date:~5,2%-%date:~8,2%

Set DataFileName=BAK_%SysDate%.dmp

Set LogFileName=BAK_%SysDate%.log

Set ZipFileName=BAK_%SysDate%.rar

@echo * * * * * * * * * * * * * * * * * * * *

@echo * * * * * ORACLE 数据库备份 * * * * * *

@echo * * * * * * * * * * * * * * * * * * * *

@echo 服务名 = %OrclSid%

@echo 用户名 = %ExpUser%

@echo 密码 = %ExpPass%

@echo 目录 = %FileDir%

@echo 时间 = %SysDate%

@echo 文件名 = %ZipFileName%

@echo 建立备份目录

if not exist "%FileDir%" mkdir %FileDir%

@echo 开始备份数据库...

echo 数据文件：echo %FileDir%\%DataFileName%

echo 日志文件：%FileDir%\%LogFileName%

exp %ExpUser%/%ExpPass%@%OrclSid% file=%FileDir%\%DataFileName% log=%FileDir%\

%LogFileName%

@echo 数据库备份完成!

@echo 开始压缩数据库备份...

if exist %FileDir%\%ZipFileName% del %FileDir%\%ZipFileName%

"%WinRarDir%\Rar.exe" a %FileDir%\%ZipFileName% %FileDir%\%DataFileName%

"%WinRarDir%\Rar.exe" a %FileDir%\%ZipFileName% %FileDir%\%LogFileName%

@echo 数据库备份压缩完成!

@echo 开始删除数据库备份文件...

del %FileDir%\%DataFileName%;%FileDir%\%LogFileName%

@echo 数据库备份文件删除完成!

rem 自动删除 7 天前的备份文件

forfiles /p "%FileDir%" /s /m *.rar /d -7 /c "cmd /c del @path"

of 1

免费下载

关注