[DB] 오라클 백업 스케쥴러
#### dbfull_back.bat
cmd.exe /k "D:\oracle\product\10.2.0\db_1\BIN\exp.exe userid=SYSTEM/BEKE419 file='D:\Backup\Oracle10g\dbfull_%1.dmp' full=y"
#### dbfull_back.vbs
Dim tmp
tmp = date()
Set WshShell = WScript.CreateObject("WScript.Shell")
WshShell.Run ("dbfull_back.bat " & tmp)
#### howto.txt
dbfull_back.vbs를 예약된 작업에 넣으면 됨
/////////////////////////////////////
#### dbfull_back.bat
@echo off
SET ORACLE_SID=BKENG
for %%a in (%date%) do SET day=%%a
D:\oracle\product\10.2.0\db_1\BIN\exp userid=SYSTEM/BEKE419 file=D:\Backup\Oracle10g\dbfull_%day%.dmp full=y log=D:\Backup\Oracle10g\dbfull_%day%.log
cmd.exe /k "D:\oracle\product\10.2.0\db_1\BIN\exp.exe userid=SYSTEM/BEKE419 file='D:\Backup\Oracle10g\dbfull_%1.dmp' full=y"
#### dbfull_back.vbs
Dim tmp
tmp = date()
Set WshShell = WScript.CreateObject("WScript.Shell")
WshShell.Run ("dbfull_back.bat " & tmp)
#### howto.txt
dbfull_back.vbs를 예약된 작업에 넣으면 됨
/////////////////////////////////////
#### dbfull_back.bat
@echo off
SET ORACLE_SID=BKENG
for %%a in (%date%) do SET day=%%a
D:\oracle\product\10.2.0\db_1\BIN\exp userid=SYSTEM/BEKE419 file=D:\Backup\Oracle10g\dbfull_%day%.dmp full=y log=D:\Backup\Oracle10g\dbfull_%day%.log
댓글