@echo off
@echo ================================================
@echo windows环境下Oracle数据库的自动备份脚本
@echo 1、备份导出文件时自动使用当前日期进行命名。
@echo 2、自动删除7天前的备份
@echo ================================================
set mydate=%date:~,4%%date:~5,2%%date:~8,2%
::设置用户名、密码
set USER=opms
set PASSWORD=opms
set ORACLE=30orcl
::创建备份用目录
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%\opms_%mydate%.dmp log=%LOG_CURDIR%\opms_log_%mydate%.log owner=opms
::删除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
@echo ================================================
@echo windows环境下Oracle数据库的自动备份脚本
@echo 1、备份导出文件时自动使用当前日期进行命名。
@echo 2、自动删除7天前的备份
@echo ================================================
set mydate=%date:~,4%%date:~5,2%%date:~8,2%
::设置用户名、密码
set USER=opms
set PASSWORD=opms
set ORACLE=30orcl
::创建备份用目录
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%\opms_%mydate%.dmp log=%LOG_CURDIR%\opms_log_%mydate%.log owner=opms
::删除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