Oracle备份脚本(数据泵)-Windows平台
将以下内容根据自己想要备份的库修改后保存为expdp.bat,加入到计划任务中
set NLS_LANG=AMERICAN_AMERICA.AL32UTF8
set filename=%date:~0,4%-%date:~5,2%-%date:~8,2%
set workpath=D:\orabak
set zippath=D:\app\Administrator\product\11.2.0\dbhome_1\BIN
set username=test
set password=123456
set sid=orcl
cd %workpath%
echo "TestDBbackup begin..." >> %filename%.log 2<&1
echo expdp %username%/%password%@%sid% dumpfile=%filename%.dmp directory=dumpdir2 >> %filename%.log 2<&1
D:\app\Administrator\product\11.2.0\dbhome_1\BIN\expdp %username%/%password% parallel=4 dumpfile=%filename%.dmp directory=DBBAK >> %filename%.log 2<&1
echo "begin zip file..." >> %filename%.log 2<&1
echo %zippath%\zip.exe -q -9 %filename%.zip %filename%.dmp %filename%.log >> %filename%.log 2<&1
%zippath%\zip.exe -q -9 %filename%.zip %filename%.dmp >> %filename%.log 2<&1
echo "begin delete file..." >> %filename%.log 2<&1
echo del %filename%.dmp export.log >> %filename%.log 2<&1
del %filename%.dmp export.log >> %filename%.log 2<&1
echo "TestDBbackup end" >> %filename%.log 2<&1
最新文章
- TODO:macOS上ThinkPHP5和Semantic-UI集成
- Start with connect by prior 递归查询
- JDBC学习2:为什么要写Class.forName(";XXX";)?
- 18位身份证验证--java实现,正则表达式
- 过滤字符串的Html标记 c#函数 .
- 三层ViewPager嵌套 的事件处理
- Qt之多线程
- Springmvc @CookieValue实用
- 使用sublime text3 连接sftp/ftp(远程服务器)
- RDO Stack: Failed connect to server
- CocoaLumberjack——带颜色的Log
- Linux &; Windows 环境下 Redis 安装与基本配置
- docker遇到的问题以及docker 操作镜像的基本操作
- 9.Django Admin编写
- [转]Redis内部数据结构详解-sds
- JVM 字节码(一)字节码规范
- django基础(一)
- .Net ASP.NET 打开指定文件夹
- Numeric Type Attributes
- Docker修改默认存储位置(转)