level 1
花浅笑溪长流
楼主
@echo RAR_CMD 指定RAR命令行压缩工具所在目录
set RAR_CMD="D:/工具箱/WinRAR.exe"
set oracle_name=yzoa
set oracle_password=a123
set oracle_db=orcl
set back_full_name=yzoa
set back_option=owner=yzoa
set backup_dir=D:/oraclebackup
set weekday=%date:~11,3%
@echo off
echo %weekday%==周三
echo "%date%"
echo 删除1天前的备份文件和日志
rem 调用函数,当周二、三、四、五时执行删除命令
if %weekday%==周二(call :function)
else(if %weekday%==周三(call :function))
else(if %weekday%==周四(call :function))
else(if %weekday%==周五(call :function))
rem 定义函数
:function
forfiles /p "%backup_dir%"/s/m %back_full_name%*.rar /d -1 /c "cmd /c del @PATH"
forfiles /p "%backup_dir%"/s/m %back_full_name%*.log /d -1 /c "cmd /c del @PATH"
rem del "%backup_dir%"/%back_full_name%*.rar
exit /b
echo 正在备份 Oracle 数据库,请稍等……
exp %oracle_name%/%oracle_password%@%oracle_db% %back_option% file="%backup_dir%/%back_full_name%%date:~0,4%%date:~5,2%%date:~8,2%.dmp"
rem log=D:/oraclebackup/yzoa%date:~0,4%%date:~5,2%%date:~8,2%.log full=y buffer=65535
log=D:/oraclebackup/mdb%date:~0,4%%date:~5,2%%date:~8,2%.log full=y buffer=65535
echo 备份完成!
echo 正在压缩,请稍等……
%RAR_CMD% a -df "%BACK_FULL_NAME%%date:~0,4%%date:~5,2%%date:~8,2%.rar" "%BACK_FULL_NAME%%date:~0,4%%date:~5,2%%date:~8,2%.dmp"
echo 压缩完成!
pause
2017年09月06日 10点09分
1
set RAR_CMD="D:/工具箱/WinRAR.exe"
set oracle_name=yzoa
set oracle_password=a123
set oracle_db=orcl
set back_full_name=yzoa
set back_option=owner=yzoa
set backup_dir=D:/oraclebackup
set weekday=%date:~11,3%
@echo off
echo %weekday%==周三
echo "%date%"
echo 删除1天前的备份文件和日志
rem 调用函数,当周二、三、四、五时执行删除命令
if %weekday%==周二(call :function)
else(if %weekday%==周三(call :function))
else(if %weekday%==周四(call :function))
else(if %weekday%==周五(call :function))
rem 定义函数
:function
forfiles /p "%backup_dir%"/s/m %back_full_name%*.rar /d -1 /c "cmd /c del @PATH"
forfiles /p "%backup_dir%"/s/m %back_full_name%*.log /d -1 /c "cmd /c del @PATH"
rem del "%backup_dir%"/%back_full_name%*.rar
exit /b
echo 正在备份 Oracle 数据库,请稍等……
exp %oracle_name%/%oracle_password%@%oracle_db% %back_option% file="%backup_dir%/%back_full_name%%date:~0,4%%date:~5,2%%date:~8,2%.dmp"
rem log=D:/oraclebackup/yzoa%date:~0,4%%date:~5,2%%date:~8,2%.log full=y buffer=65535
log=D:/oraclebackup/mdb%date:~0,4%%date:~5,2%%date:~8,2%.log full=y buffer=65535
echo 备份完成!
echo 正在压缩,请稍等……
%RAR_CMD% a -df "%BACK_FULL_NAME%%date:~0,4%%date:~5,2%%date:~8,2%.rar" "%BACK_FULL_NAME%%date:~0,4%%date:~5,2%%date:~8,2%.dmp"
echo 压缩完成!
pause