Daily.bat - 匯出、壓縮、清理、通知
@echo off
REM =====================================================
REM Daily Oracle Schema Export & Backup
REM Author: Frank.Fan
REM Created: 2012-05-07
REM =====================================================
REM 取得日期時間 (YYYYMMDD_HHMM)
for /F "tokens=1-3 delims=/ " %%i in ('date /t') do set FILENAMEDT=%%i%%j%%k
for /F "tokens=1,2 delims=: " %%i in ('time /t') do set FILENAMETM=%%i%%j
SET USERNAME=SYSTEM
SET USERPASSWD=123456
SET SERVICENAME=QEWAY
SET SCHEMASNAME=ISCOP
SET RARTOOL="C:\Program Files\WinRAR\winrar.exe"
SET DBBACKUPPATH=D:\DBBAK
SET DBADIRECTORIES=DBBAK
SET DBBACKUPFILENAME=QEWAY_%FILENAMEDT%-%FILENAMETM%
:main
ECHO Exporting schemas.......
expdp %USERNAME%/%USERPASSWD%@%SERVICENAME% ^
DUMPFILE=%DBADIRECTORIES%:%DBBACKUPFILENAME%.dmp ^
SCHEMAS=%SCHEMASNAME% ^
LOGFILE=%DBADIRECTORIES%:%DBBACKUPFILENAME%.log
ECHO Done exporting schemas.
ECHO =======================================================
REM 壓縮並刪除原始 dmp
if exist %DBBACKUPPATH%\%DBBACKUPFILENAME%.RAR del %DBBACKUPPATH%\%DBBACKUPFILENAME%.RAR
%RARTOOL% a -ep %DBBACKUPPATH%\%DBBACKUPFILENAME%.RAR %DBBACKUPPATH%\%DBBACKUPFILENAME%.dmp
del %DBBACKUPPATH%\%DBBACKUPFILENAME%.dmp
Echo ...Compression complete
REM 刪除 30 天前的 .rar
forfiles /p "%DBBACKUPPATH%" /m *.rar -d -30 /c "cmd /c del /f @path"
REM 發送郵件通知
start D:\DBBAK\Batch_notification_Daily.vbs
EXIT
Batch_notification_Daily.vbs - 郵件通知
NameSpace = "https://schemas.microsoft.com/cdo/configuration/"
Set Email = CreateObject("CDO.Message")
Email.From = "XXXX@Exchange.com"
Email.To = "XXXX@163.com"
Email.Subject = "Gongxtpt Batch Daily Task"
Email.Textbody = "Gongxtpt Batch Daily Task was done!! Starting at 00:00AM"
With Email.Configuration.Fields
.Item(NameSpace & "sendusing") = 2
.Item(NameSpace & "smtpserver") = "10.0.0.12"
.Item(NameSpace & "smtpserverport") = 25
.Item(NameSpace & "smtpauthenticate") = 0
.Item(NameSpace & "sendusername") = ""
.Item(NameSpace & "sendpassword") = ""
.Update
End With
Email.Send
Set Email = Nothing