Oracle 備份並刪除以前一定時間的備份

@echo off 

echo 正在備份資料庫檔案，請稍等...... 

exp.exe report/ok@report file=d:/reportBack/report%date%.dmp log=d:/reportBack/report%date:~0,10%.log 

 

echo 正在刪除備份檔案，請稍等...... 

rem 需要Win2003/Vista/Win7系統內建的forfiles命令的支援

rem forfiles /p "d:/reportBack" /d -2 /c "cmd /c del /f @path"

 

rem 指定待刪除檔案的存放路徑

set SrcDir=d:/reportBack

rem 指定天數

set DaysAgo=2

for /f "skip=2 delims=" %%a in ('reg query "HKEY_CURRENT_USER/Control Panel/International" /v sShortDate') do (

  set "RegDateOld=%%a"

)

set RegDateOld=%RegDateOld:~-8%

reg add "HKEY_CURRENT_USER/Control Panel/International" /v sShortDate /t REG_SZ /d yyyy-M-d /f>nul

>"%temp%/DstDate.vbs" echo LastDate=date()-%DaysAgo%

>>"%temp%/DstDate.vbs" echo FmtDate=right(year(LastDate),4) ^& right("0" ^& month(LastDate),2) ^& right("0" ^& day(LastDate),2)

>>"%temp%/DstDate.vbs" echo wscript.echo FmtDate

for /f %%a in ('cscript /nologo "%temp%/DstDate.vbs"') do (

  set "DstDate=%%a"

)

set DstDate=%DstDate:~0,4%-%DstDate:~4,2%-%DstDate:~6,2%

for /r "%SrcDir%" %%a in (*.*) do (

  if "%%~ta" leq "%DstDate%" (

  if exist "%%a" (

  del /f /q "%%a"

  )

  )

)

 

reg add "HKEY_CURRENT_USER/Control Panel/International" /v sShortDate /t REG_SZ /d %RegDateOld% /f>nul

 

@echo 刪除成功！

@echo 備份成功！