echo off
path=%path%;D:\oracle\product\10.2.0\client_1\bin
Exp fm_sc/emoss74@EMOSSDB1_10.206.4.74 Owner=fm_sc,File=E:\Data_Backup\EMOSSDB%date:0,4%%date:5,2%%date:8,2%%time:0,2%%time:3,2%%time:6,2%.dmp Log=E:\Data_Backup\LOGS\EMOSSDB%date:0,4%%date:5,2%%date:8,2%.log
Exp fm_scflow/1@EMOSSDB1_10.206.4.74 Owner=fm_scFLOW,File=E:\Data_Backup\EMOSSFLOWDB%date:0,4%%date:5,2%%date:8,2%%time:0,2%%time:3,2%%time:6,2%.dmp Log=E:\Data_Backup\LOGS\EMOSSFLOWDB%date:0,4%%date:5,2%%date:8,2%.log
Exp pmsi/1@EMOSSDB1_10.206.4.74 Owner=pmsi,File=E:\Data_Backup\EMOSSPMSIDB%date:0,4%%date:5,2%%date:8,2%%time:0,2%%time:3,2%%time:6,2%.dmp Log=E:\Data_Backup\LOGS\EMOSSFLOWDB%date:0,4%%date:5,2%%date:8,2%.log
rem 指定壓縮程序的安裝路徑,以便備份后進(jìn)行壓縮,以節(jié)省磁盤空間方便遠(yuǎn)程傳輸；
path=%path%;C:\Program Files (x86)\winrar
rem 備份數(shù)據(jù)
rem 壓縮備份后的文件,壓縮比在1:10左右
rar a E:\Data_Backup\EMOSSDB%date:0,4%%date:5,2%%date:8,2%.rar E:\Data_Backup\EMOSSDB%date:0,4%%date:5,2%%date:8,2%*.dmp
rar a E:\Data_Backup\EMOSSFLOWDB%date:0,4%%date:5,2%%date:8,2%.rar E:\Data_Backup\EMOSSFLOWDB%date:0,4%%date:5,2%%date:8,2%*.dmp
rar a E:\Data_Backup\EMOSSPMIS%date:0,4%%date:5,2%%date:8,2%.rar E:\Data_Backup\EMOSSPMSIDB%date:0,4%%date:5,2%%date:8,2%*.dmp
rem 將打包后的備份文件拷貝到遠(yuǎn)程災(zāi)備服務(wù)器上
rem copy e:\backup\ccsbi_%date:0,10%.rar \\遠(yuǎn)程備份機\e:\backup\
rem 刪除未壓縮的備份文件,減少磁盤空間的占用
rem del e:\backup\ccsbi_%date:0,10%.*
echo on