rem ===============================
rem 自动上传oracle备份
rem
rem $AUTHOR SONGRH
rem
rem
rem ===============================
set FTPIP=210.82.176.84
set FTPUSR=srh
set FTPPASSWD=welcome
set LOGFILE=ftplog.txt
set CONFFILE=config.ini
rem ================================
set BAKDIR=temp
set DATEDIR=%date:~4%
rem =============================
rem set BAKFILE=abc.dmp
rem =============================
set DMPDIR=D:\oraclebak
set DMPBAKDIR=%date:~4%
set DMPLOG=exp%date:~4%.log
set DMPFILE=zjadmain%date:~4%.dmp
set DMPUSER=abc
set DMPPASS=abc
set TNSNAME=clt
rem =======================
echo open %FTPIP% > %CONFFILE%
echo user %FTPUSR% >> %CONFFILE%
echo %FTPPASSWD% >> %CONFFILE%
echo mkdir %BAKDIR% >> %CONFFILE%
echo cd %BAKDIR% >> %CONFFILE%
echo mkdir %DATEDIR% >> %CONFFILE%
echo cd %DATEDIR% >> %CONFFILE%
echo bi >> %CONFFILE%
echo mput %DMPDIR%\%DMPBAKDIR%\* >> %CONFFILE%
echo bye >> %CONFFILE%
rem ================================
echo #================================#
echo # 该脚本自动将自动备份 #
echo # oracle到指定目录,并 #
echo # 将备份上传到FTP服务器 #
echo # 可以将该脚本加入计划 #
echo # 任务,加入时删除此说明 #
echo #================================#
mkdir %DMPDIR%\%DMPBAKDIR%
ftp -d -i -n -s:%CONFFILE% > %LOGFILE%
rem ==================================