windows下实现oracle自动备份 bat
来源:互联网 发布:西安淘宝设计代运营 编辑:程序博客网 时间:2024/05/01 18:10
@echo off
setlocal enabledelayedexpansion
title %date% %time:~,8% by LiaoNing Sunray Software Technology
::定义数据库SID
set SID=sryx254
::定义用户名数组(各用户间用空格分隔 例如:user1 user2 user3)
set userArr=user1 user2 user3
set pswdArr=password1 password2 password3
::指定删除天数
set daysAgo=7
::指定备份路径
set filePath=E:\dmp_beifen\
::定义脚本内部变量
set time_=%time: =0%
set fileName=%date:~0,4%%date:~5,2%%date:~8,2%_%time_:~0,2%%time_:~3,2%.dmp
set newDir=%date:~0,10%\
::创建以当天日期命名的文件夹
if not exist %filePath% md %filePath%
if not exist %filePath%%newDir% md %filePath%%newDir%
::导出数据
set/a n=1
call :sub userArr %userArr%
call :sub pswdArr %pswdArr%
set/a arrLength=nuserArr
:loop
exp !userArr%n%!/!pswdArr%n%!@%SID% file=%filePath%%newDir%!userArr%n%!_%fileName%
::echo 测试显示 !userArr%n%!/!pswdArr%n%!
if %n% lss %arrLength% set/a "n+=1"&goto loop
goto next
:sub
set %1%n%=%2
if not "%3"=="" (set/a n+=1
shift /2&goto sub)
set/a "n%1=n,n=1"&goto :eof
:next
::删除N天以前的数据
set d=%date:~0,10%
mshta vbscript:createobject("scripting.filesystemobject").opentextfile("temp.txt",2,true).write(FormatDateTime(dateadd("d",-%daysAgo%+1,"%d%"),vbShortDate))(window.close)
for /f "tokens=1 delims= " %%i in (temp.txt) do set t1=%%i
for /f "delims= " %%i in ('dir /ad/b %filePath%') do (
set t2=%%i
set t3=!t2:~0,10!
if !t3! lss !t1! rd /s/q "%filePath%%%i")
setlocal enabledelayedexpansion
title %date% %time:~,8% by LiaoNing Sunray Software Technology
::定义数据库SID
set SID=sryx254
::定义用户名数组(各用户间用空格分隔 例如:user1 user2 user3)
set userArr=user1 user2 user3
set pswdArr=password1 password2 password3
::指定删除天数
set daysAgo=7
::指定备份路径
set filePath=E:\dmp_beifen\
::定义脚本内部变量
set time_=%time: =0%
set fileName=%date:~0,4%%date:~5,2%%date:~8,2%_%time_:~0,2%%time_:~3,2%.dmp
set newDir=%date:~0,10%\
::创建以当天日期命名的文件夹
if not exist %filePath% md %filePath%
if not exist %filePath%%newDir% md %filePath%%newDir%
::导出数据
set/a n=1
call :sub userArr %userArr%
call :sub pswdArr %pswdArr%
set/a arrLength=nuserArr
:loop
exp !userArr%n%!/!pswdArr%n%!@%SID% file=%filePath%%newDir%!userArr%n%!_%fileName%
::echo 测试显示 !userArr%n%!/!pswdArr%n%!
if %n% lss %arrLength% set/a "n+=1"&goto loop
goto next
:sub
set %1%n%=%2
if not "%3"=="" (set/a n+=1
shift /2&goto sub)
set/a "n%1=n,n=1"&goto :eof
:next
::删除N天以前的数据
set d=%date:~0,10%
mshta vbscript:createobject("scripting.filesystemobject").opentextfile("temp.txt",2,true).write(FormatDateTime(dateadd("d",-%daysAgo%+1,"%d%"),vbShortDate))(window.close)
for /f "tokens=1 delims= " %%i in (temp.txt) do set t1=%%i
for /f "delims= " %%i in ('dir /ad/b %filePath%') do (
set t2=%%i
set t3=!t2:~0,10!
if !t3! lss !t1! rd /s/q "%filePath%%%i")
del /f temp.txt
注意还要在控制面板中设置短日期、长日期格式为“yyyy-mm-dd”,否则最后面删除N天前的数据会出现问题(多删了好几天的备份文件)
- windows下实现oracle自动备份 bat
- windows下实现oracle自动备份 bat
- bat+7z+ftp实现windows下的自动备份
- windows下mysql自动定时备份bat
- windows下oracle自动备份
- windows下oracle自动备份
- Windows平台下Oracle 自动备份的实现
- Windows平台下Oracle 自动备份的实现
- Windows下实现Oracle数据库定时自动备份批处理代码
- Windows下自动备份mongodb的bat脚本
- oracle自动备份bat脚本
- bat命令oracle自动备份
- windows平台下Oracle自动备份脚本
- windows下oracle简单自动备份设置
- WINDOWS 服务器下自动备份oracle数据库
- Windows下自动备份Oracle数据库
- windows下bat备份mysql
- Windows下实现PostgreSQL自动备份
- GCC 中文手册 - 摘自纯C论坛
- 初学 WebView
- Objective-C iPhone起步开发的8条建议和技巧
- poj 2977 Box walking
- sed命令简单使用-D命令-结束本轮循环
- windows下实现oracle自动备份 bat
- AXURE在原型设计中的应用
- Mysql中Profiling之性能分析
- Java中范型的作用
- Struts2访问或者添加request等属性
- 一起来学Objective-C(1)——Window下开发环境安装和Hello World
- poll, select & poll—wait底层数据结构
- 一起来学Objective-C(2)——Hello World深入
- Bootargs使用