萬盛學電腦網

您现在的位置: 萬盛學電腦網 >> 程式設計 >  >> 資料庫 >> Oracle 教學

Windows 批次腳本自動化 Oracle expdp 備份與壓縮郵件通知

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
copyright © 萬盛學電腦網 all rights reserved