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%.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