1.新健backup.bat文
rem ***********备份数据**************
echo开始数据库备份时间: %date% %time%>> backup.log
rem备份督办回告1
exp dbhg/dbhg@orcl file=d:\backup\dbbak\dbhg_%date:~0,10%.dmp log=d:\backup\dbbak\dbhg_%date:~0,10%.log compress=n buffer=8092 consistent=y direct=n constraints=y feedback=10000grants=y record=y indexes=y triggers=y rows=y
rem备份OA数据库2
exp oa/oa@orcl file=d:\backup\dbbak\oa_%date:~0,10%.dmp log=d:\backup\dbbak\oa_%date:~0,10%.log compress=n buffer=8092 consistent=y direct=n constraints=y feedback=10000grants=y record=y indexes=y triggers=y rows=y
rem ********压缩 数据库备份*************
rem压缩 督办回告数据库备份
C:\progra~1\winrar\winrar.exe ad:\backup\rarbak\dbhg_%date:~0,10%.rar d:\backup\dbbak\dbhg_%date:~0,10%.dmp d:\backup\dbbak\dbhg_%date:~0,10%.log>> backup.log
rem压缩OA数据库备份
C:\progra~1\winrar\winrar.exe ad:\backup\rarbak\oa_%date:~0,10%.rar d:\backup\dbbak\oa_%date:~0,10%.dmp d:\backup\dbbak\oa_%date:~0,10%.log>> backup.log
rem *********删除 数据临时备份文件*************
del /f d:\backup\dbbak\dbhg_%date:~0,10%.dmp
del /f d:\backup\dbbak\dbhg_%date:~0,10%.log
del /f d:\backup\dbbak\oa_%date:~0,10%.dmp
del /f d:\backup\dbbak\oa_%date:~0,10%.log
echo结束工程备份时间: %date% %time%>> backup.log
rem得到前7天的日期
echo wscript.echo dateadd("d",-7,date) >%tmp%\tmp.vbs
for /f "tokens=1,2,3 delims=/- " %%i in ('cscript /nologo %tmp%\tmp.vbs') do set y=%%i
for /f "tokens=1,2,3 delims=/- " %%i in ('cscript /nologo %tmp%\tmp.vbs') do set m=%%j
for /f "tokens=1,2,3 delims=/- " %%i in ('cscript /nologo %tmp%\tmp.vbs') do set d=%%k
if %m% LSS 9 set m=0%m%
if %d% LSS 9 set d=0%d%
set deldate=%y%-%m%-%d%
rem删除7天前程序备份
echo start del d:\backup\rarbak\*_%deldate%.rar at : %date% %time%>> backup.log
del /f d:\backup\rarbak\dbhg_%deldate%.rar
del /f d:\backup\rarbak\oa_%deldate%.rar
echo end del d:\backup\rarbak\*_%deldate%.rar at : %date% %time%>> backup.log
rem构建临时ftp连接脚本
echo open 59.208.8.4 >> ftp.tmp
echo user ycoa bester@2010 >> ftp.tmp
echo cd server3 >> ftp.tmp
echo bin >> ftp.tmp
echo prompt off >> ftp.tmp
echo send d:\backup\rarbak\dbhg_%date:~0,10%.rar >> ftp.tmp
echo del dbhg_%deldate%.rar >> ftp.tmp
echo send d:\backup\rarbak\oa_%date:~0,10%.rar >> ftp.tmp
echo del oa_%deldate%.rar >> ftp.tmp
echo bye >> ftp.tmp
rem开始使用ftp客户端连接,并执行脚本
ftp -n -s:ftp.tmp
rem删除临时文件
del /f ftp.tmp