oracle备份压缩删除上传脚本
来源:互联网 发布:linux 桌面 命令 编辑:程序博客网 时间:2024/06/16 01:55
+++++++++++++++++++++++++++++++++++++++数据库备份压缩删除脚本++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
set vcoodate=%date:~0,4%%date:~5,2%%date:~8,2%
set ORACLE_SID=orcl
rem set NLS_LANG=SIMPLIFIED CHINESE_CHINA.AL32UTF8
expdp expuser/expuser schemas=goods directory=dpdata1 dumpfile=goods_%vcoodate%.dmp logfile=goods_%vcoodate%.log
expdp expuser/expuser schemas=trans directory=dpdata1 dumpfile=trans_%vcoodate%.dmp logfile=trans_%vcoodate%.log
rem --设置指定路径为D:\dbback
set "pt=D:\dbback"
rem --获取指定路径下所有文件和文件夹的名称
for /f %%i in ('dir /b D:\dbback') do (
rem --这里做为显示的命令参数
"C:\Program Files\WinRAR\rar.exe" a -df D:\dbback\%%i.rar D:\dbback\%%i
)
echo 压缩完成!
copy D:\dbback\*%vcoodate%*.rar z:\
forfiles /p "D:\dbback" /s /m *.rar /d -5 /c "cmd /c del /f @path"
+++++++++++++++++++++++++++++++++++++++创建导出用户的SQL++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
create directory dpdata1 as 'D:\dbback';
create user expuser identified by expuser
default tablespace users
temporary tablespace temp
account unlock;
grant connect,resource to expuser;
grant exp_full_database to expuser;
grant read,write on directory dpdata1 to expuser;
++++++++++++++++++++++++++++++++++++++++应用服务器自动删除脚本+++++++++++++++++++++++++++++++++++++++++++++++++++++++
forfiles /p "D:\dbback" /s /m *.rar /d -30 /c "cmd /c del /f @path"
set vcoodate=%date:~0,4%%date:~5,2%%date:~8,2%
set ORACLE_SID=orcl
rem set NLS_LANG=SIMPLIFIED CHINESE_CHINA.AL32UTF8
expdp expuser/expuser schemas=goods directory=dpdata1 dumpfile=goods_%vcoodate%.dmp logfile=goods_%vcoodate%.log
expdp expuser/expuser schemas=trans directory=dpdata1 dumpfile=trans_%vcoodate%.dmp logfile=trans_%vcoodate%.log
rem --设置指定路径为D:\dbback
set "pt=D:\dbback"
rem --获取指定路径下所有文件和文件夹的名称
for /f %%i in ('dir /b D:\dbback') do (
rem --这里做为显示的命令参数
"C:\Program Files\WinRAR\rar.exe" a -df D:\dbback\%%i.rar D:\dbback\%%i
)
echo 压缩完成!
copy D:\dbback\*%vcoodate%*.rar z:\
forfiles /p "D:\dbback" /s /m *.rar /d -5 /c "cmd /c del /f @path"
+++++++++++++++++++++++++++++++++++++++创建导出用户的SQL++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
create directory dpdata1 as 'D:\dbback';
create user expuser identified by expuser
default tablespace users
temporary tablespace temp
account unlock;
grant connect,resource to expuser;
grant exp_full_database to expuser;
grant read,write on directory dpdata1 to expuser;
++++++++++++++++++++++++++++++++++++++++应用服务器自动删除脚本+++++++++++++++++++++++++++++++++++++++++++++++++++++++
forfiles /p "D:\dbback" /s /m *.rar /d -30 /c "cmd /c del /f @path"
0 0
- oracle备份压缩删除上传脚本
- WINDOWS ORACLE备份脚本并且压缩为RAR格式
- Linux oracle数据库自动备份自动压缩脚本代码
- 备份,FTP上传脚本
- shell备份上传脚本
- Oracle Rman备份脚本与自动删除重复备份文件
- ORACLE备份中的压缩
- oracle定时备份压缩
- 用python脚本对svn库进行备份,压缩,加密,ftp上传
- 逻辑备份案例:windows平台oracle导数据的逻辑备份脚本,备份后自动压缩 rar
- linux自动备份oracle数据库并上传到备份服务器 脚本实现
- oracle 备份脚本
- oracle日常备份脚本
- Oracle备份脚本
- oracle 增量备份脚本
- oracle备份、还原脚本
- oracle 增量备份脚本
- Oracle自动备份脚本
- MySQL数据的主从复制、半同步复制和主主复制详解
- 欢迎使用CSDN-markdown编辑器
- Unity3d插件PlayMaker经验
- bzoj1132: [POI2008]Tro (第二次做)
- kafka 运行问题:ERROR Uncaught error in kafka producer I/O thread 的处理
- oracle备份压缩删除上传脚本
- MyBatis六运行原理
- 让你的分享飞起来——极光推出社会化分享组件
- 二叉树的深度优先遍历与广度优先遍历
- 移动端页面字体单位rem
- mac操作技巧(持续更新)
- 5-53 Consecutive Factors (20分)
- JavaScript HTML DOM 基础
- 基于okhttp的网络请求