2015年11月18日 星期三

批次 備份Oracle

@ECHO OFF

for /F "tokens=1-4 delims=/ " %%i in ('date /t') do (
set DayOfWeek=%%l
set Month=%%j
set Day=%%k
set Year=%%i

set Date=%%i %%j/%%k/%%l
)

for /F "tokens=1-2 delims=: " %%m in ('time /t') do (
set Hour=%%m%%n
set Minute=%%o

)

ECHO Date is %Date%
ECHO Day of the week is "%DayOfWeek%", Month is "%Month%"
ECHO Day is "%Day%", Year is "%Year%"
ECHO Hour is "%Hour%", Minute is "%Minutes%"

REM ========= export test database =========================================================

exp MF2000/MF2000 file=Y:\DB_Data\%Year%%Month%%Day%_mf2000.dmp  log=Y:\DB_Data\%Year%%Month%%Day%_mf2000.log
exp MF2000/MF2000 file=Y:\DB_Data\%Year%%Month%%Day%_mf2005.dmp  log=Y:\DB_Data\%Year%%Month%%Day%_mf2005.log
exp MF2000/MF2000 file=Y:\DB_Data\%Year%%Month%%Day%_mf20051.dmp  log=Y:\DB_Data\%Year%%Month%%Day%_mf20051.log
exp MF2000/MF2000 file=Y:\DB_Data\%Year%%Month%%Day%_mf20061.dmp  log=Y:\DB_Data\%Year%%Month%%Day%_mf20061.log
exp MF2000/MF2000 file=Y:\DB_Data\%Year%%Month%%Day%_mf20062.dmp  log=Y:\DB_Data\%Year%%Month%%Day%_mf20062.log
exp MFTEST/MF2000 file=Y:\DB_Data\%Year%%Month%%Day%_mftest.dmp  log=Y:\DB_Data\%Year%%Month%%Day%_mftest.log
exp MFTEST/MF2000 file=Y:\DB_Data\%Year%%Month%%Day%_mftest2.dmp  log=Y:\DB_Data\%Year%%Month%%Day%_mftest2.log

沒有留言:

張貼留言