windows下通過批處理備份oracle資料庫

@echo off
rem Author:jwl
rem Time:2015-03-03


echo 開始備份資料庫
if not exist C:\db_bak\files md C:\db_bak\files
if not exist C:\db_bak\logs md C:\db_bak\logs
if not exist Z:\db_bak\files md Z:\db_bak\files
if not exist Z:\db_bak\logs md Z:\db_bak\logs


echo 設定時間變數
set var=%date:~0,4%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%%time:~6,2%


echo  匯出備份檔案和日誌檔案
exp cloude/cloude@ORCLTEST file=C:\db_bak\files\backup_%var%.dmp log=C:\db_bak\logs\backup_%var%.log 


echo 開始移動檔案
xcopy C:\db_bak\files\backup_%var%.dmp Z:\db_bak\files\
xcopy C:\db_bak\logs\backup_%var%.log Z:\db_bak\logs\ 


echo 刪除過久的備份記錄
forfiles /p "C:\db_bak" /s /m *.dmp /d -60 /c "cmd/c del @path"
forfiles /p "C:\db_bak" /s /m *.log /d -60 /c "cmd/c del @path"


echo 備份已於:%DATE% %time% 完成!


exit
pause