oracle自动备份脚本

@echo off 
@echo ================================================ 
@echo  windows环境下Oracle数据库的自动备份脚本 
@echo  1、备份导出文件时自动使用当前日期进行命名。
@echo  2、自动删除7天前的备份
@echo ================================================
set mydate=%DATE:~0,10%
::设置用户名、密码
set USER=oa
set PASSWORD=123
set ORACLE=orcl
::创建备份用目录
if not exist "backup\data\" 		mkdir backup\data\
if not exist "backup\log\" 		mkdir backup\log\
set DATA_CURDIR=backup/data
set LOG_CURDIR=backup/log
exp %USER%/%PASSWORD%@%ORACLE%  file=%DATA_CURDIR%\gb_%date%.dmp log=%LOG_CURDIR%\gb_log_%mydate%.log
::删除7天前备份
forfiles /p "%DATA_CURDIR%" /s /m *.* /d -7 /c "cmd /c del @path"
forfiles /p "%LOG_CURDIR%" /s /m *.* /d -7 /c "cmd /c del @path"
exit

 

转载于:https://www.cnblogs.com/solooo/archive/2013/06/09/3128130.html