ORACLE 备份文件 格式为数据文件 oracle20220622.DAT 和备份的数据文件的日志oracle20220622.LOG
@echo off
::ftp user
set ftpuser=账号
::ftp password
set ftpPass=输入密码
::ftp ip 
set ftpIP=192.168.1.1
::FTP文件目录
set ftpFolder=D:/backup
::本地文件保存地址
set LocalFolder=D:/backup1
 
set ftpFile=%temp%/TempFTP.txt
>"%ftpFile%" (
     echo,%ftpUser%
     echo,%ftpPass%
     echo cd "%ftpFolder%"
     echo lcd "%LocalFolder%"
     echo bin
     echo.
     echo mget oracle%date:~0,4%%date:~5,2%%date:~8,2%.LOG oracle%date:~0,4%%date:~5,2%%date:~8,2%.DAT
     echo.
)
start ftp -i -s:"%ftpFile%" %ftpIP%
::打开本地备份文件夹
start explorer "D:\backup\"

也可以添加判断文件是否下载完成返回 ok 或者 不存在返回not found

if exist "D:\backup1\oracle%date:~0,4%%date:~5,2%%date:~8,2%.DAT" (echo datafile is ok) else (echo datafile is not found)
if exist "D:\backup1\oracle%date:~0,4%%date:~5,2%%date:~8,2%.LOG" (echo lgofile is ok) else (echo logfile is not found)
最后修改:2022 年 06 月 24 日
如果觉得我的文章对你有用,请随意赞赏