Oralce 备份

每天12点运行D盘的go.bat

at 12:00 /every:M,T,W,Th,F,S,Su d:/go.bat

每个月12号的12点运行D盘的go.bat

at 12:00 /next:12 d:/go.bat

@echo off rem set backupfile=TS_%date:~0,4%-%date:~5,2%-%date:~8,2%.dmp rem set logfile=TS_%date:~0,4%-%date:~5,2%-%date:~8,2%.log rem delete 3 days files forfiles /p “D:/backup1” /m *.log /d -3 /c “cmd /c echo deleting @file … && del /f @path” forfiles /p “D:/backup1” /m *.dmp /d -3 /c “cmd /c echo deleting @file … && del /f @path” cd /d D:/backup1 rem backup schemas set backupfile=TS_%date:~0,4%-%date:~5,2%-%date:~8,2%%time:~0,2%.dmp  set logfile=TS_%date:~0,4%-%date:~5,2%-%date:~8,2%$%time:~0,2%.dmp set logfile=TS_%date:~0,4%-%date:~5,2%-%date:~8,2%$%time:~0,2%.log expdp system/nky full=y directory=TS_DB dumpfile=%backupfile% logfile=%logfile%

另一种 exp ljxq/ljxq@orcl file = d:/ljxqdb/ljxq_%date%.dmp log = d:/ljxqdb/ljxq.log