oracle的导出并自动压缩为rar文件

最新推荐文章于 2022-10-15 12:00:46 发布

原创最新推荐文章于 2022-10-15 12:00:46 发布 · 855 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #开发工具 #操作系统

ORACLE 专栏收录该内容

18 篇文章

订阅专栏

本文介绍了使用批处理脚本实现数据库的定时备份，并通过WinRAR进行压缩加密，最后利用FTP上传到远程服务器的全过程。



rem DOS get current time yyyy-mm-dd hhmiss week
rem =======================
rem get yyyy/mm/dd
set mydate=%DATE:~0,10%
echo %mydate%
rem =======================
rem get yyyy
set yyyy=%DATE:~0,4%
echo %yyyy%
rem =======================
rem get mm
set mm=%DATE:~5,2%
echo %mm%
rem =======================
rem get dd
set dd=%DATE:~8,2%
echo %dd%

rem =======================
rem get week ,display CN
set week=%DATE:~11,2%
echo %week%

rem =======================
rem get hour
set hh=%TIME:~0,2%
echo %hh%

rem =======================
rem get min
set mi=%TIME:~3,2%
echo %mi%

rem =======================
rem get ss
set ss=%TIME:~6,2%
echo %ss%

rem =======================
rem get yyyy-mm-dd
set curdate=%yyyy%-%mm%-%dd%_%hh%%mi%%ss%(%week%)
echo %curdate%

exp dev/dev@orcl file='D:/数据库备份/dev_%curdate%.dmp'

rem "C:\Program Files\WinRAR\WinRAR.exe" a -V4k -V4k D:/数据库备份/dev_%curdate%.rar  D:/数据库备份/dev_%curdate%.dmp

rem 后台模式压缩 并设置解压密码
cd D:/数据库备份
"C:\Program Files\WinRAR\WinRAR.exe" a -ibck -p123456 dev_%curdate%.rar dev_%curdate%.dmp

rem ftp -s:ftp.ini

del dev_%curdate%.dmp