-- TNS 別名配置 (tnsnames.ora)
JMYBJS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 129.1.9.90)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = jmybjs))
)
D:\backup\dmp\ -- 存放 .dmp 匯出檔
D:\backup\log\ -- 存放匯出日誌
' Nightly full export using exp
Dim outfile, aa, bb, stroption1, strsql, ws
Set ws = WScript.CreateObject("WScript.Shell")
' 日期格式 YYYYMMDD
A = CInt(Month(DateAdd("d", 0, Date())))
B = CInt(Day(DateAdd("d", 0, Date())))
C = CInt(Year(DateAdd("d", 0, Date())))
If A < 10 Then aa = "0" & A Else aa = CStr(A)
If B < 10 Then bb = "0" & B Else bb = CStr(B)
outfile = CStr(C) & aa & bb
' exp 完整參數:system/密碼@tns_別名 full=y buffer=900000
stroption1 = "D:\oracle_bf\product\10.1.0\Db_1\BIN\exp system/******@jmybjs full=y buffer=900000 file=D:\backup\dmp\jmybjs" & outfile & " log=D:\backup\log\jmybjs" & outfile & ".log"
strsql = stroption1
ws.Run strsql
' Delete dumps older than 30 days
Dim outfile, aa, bb, stroption1, strsql, ws
Set ws = WScript.CreateObject("WScript.Shell")
A = CInt(Month(DateAdd("d", -30, Date())))
B = CInt(Day(DateAdd("d", -30, Date())))
C = CInt(Year(DateAdd("d", -30, Date())))
If A < 10 Then aa = "0" & A Else aa = CStr(A)
If B < 10 Then bb = "0" & B Else bb = CStr(B)
outfile = CStr(C) & aa & bb
' 系統內建 delete.exe (XP/2003 需從其他機複製至 System32)
stroption1 = "C:\WINDOWS\system32\delete.exe D:\backup\dmp\jmybjs" & outfile & ".dmp"
strsql = stroption1
ws.Run strsql
坑點:Windows Server 2003 System32 預設無 delete.exe,需從 Windows XP/2000 複製一份過來。
exp_backup.vbs (完整匯出)exp_delete.vbs (刪除過期),時間錯開 (如 02:30)D:\backup\log\ 下 .log 檔案,確認 Export terminated successfully without warningsimp 匯入演練,驗證備份可用性