ORACLE数据库备份

1、新建一个批处理文件autoBack.bat;

2、右键编辑

 1 @Echo Off
 2 
 3 expdp STARLIMS_DATA/lims@orcl directory=BACKUP  dumpfile=STARLIMS_DATA_%date:~0,4%_%date:~5,2%_%date:~8,2%.DMP logfile = STARLIMS_DATA_%date:~0,4%_%date:~5,2%_%date:~8,2%.log
 4 expdp STARLIMS_DICT/lims@orcl directory=BACKUP  dumpfile=STARLIMS_DICT_%date:~0,4%_%date:~5,2%_%date:~8,2%.DMP logfile = STARLIMS_DICT_%date:~0,4%_%date:~5,2%_%date:~8,2%.log
 5 
 6 
 7 "C:\Program Files\WinRAR\WinRAR.exe"  A "c:\Backup\STARLIMSDATABack_%date:~0,4%_%date:~5,2%_%date:~8,2%.rar" "c:\Backup\STARLIMS_DATA_%date:~0,4%_%date:~5,2%_%date:~8,2%.DMP"  "c:\Backup\STARLIMS_DICT_%date:~0,4%_%date:~5,2%_%date:~8,2%.DMP" "c:\Backup\STARLIMS_DATA_%date:~0,4%_%date:~5,2%_%date:~8,2%.log" "c:\Backup\STARLIMS_DICT_%date:~0,4%_%date:~5,2%_%date:~8,2%.log"
 8 
 9 
10 
11 
12 
13 if exist c:\Backup\STARLIMSDATABack_%date:~0,4%_%date:~5,2%_%date:~8,2%.rar (del c:\backup\STARLIMS_DATA_%date:~0,4%_%date:~5,2%_%date:~8,2%.DMP
14 del c:\backup\STARLIMS_DICT_%date:~0,4%_%date:~5,2%_%date:~8,2%.DMP
15 del c:\backup\STARLIMS_DATA_%date:~0,4%_%date:~5,2%_%date:~8,2%.log
16 del c:\backup\STARLIMS_DICT_%date:~0,4%_%date:~5,2%_%date:~8,2%.log)
17 
18 
19 if exist E:\DataBackUp (copy "c:\Backup\STARLIMSDATABack_%date:~0,4%_%date:~5,2%_%date:~8,2%.rar"  E:\DataBackUp)
20 
21 
22 exit

View Code

*********************** KISPINE ***********************