Windows平台下Oracle数据库exp全备脚本，根据时间保留备份数及自动上备份至FTP

flyingknife

expfullbak_win_oracle.bat

1. @echo off
   
2. 
   
3. SET ORACLE_SID=orcl
   
4. SET NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
   
5. SET Year=%date:~0,4%
   
6. SET Month=%date:~5,2%
   
7. SET Day=%date:~8,2%
   
8. SET Hour=%time:~0,2%
   
9. SET Minute=%time:~3,2%
   
10. SET Second=%time:~6,2%
    
11. SET NOWDATE=%Year%_%Month%_%Day%
    
12. SET NOWTIME=%Year%%Month%%Day%%Hour%%Minute%%Second%
    
13. 
    
14. SET BACKUPDIR=d:\Bak
    
15. IF NOT EXIST %BACKUPDIR% (
    
16.     MD %BACKUPDIR%
    
17. )
    
18. IF NOT EXIST %BACKUPDIR%\%NOWDATE% (
    
19.     MD %BACKUPDIR%\%NOWDATE%
    
20. )
    
21. 
    
22. SET USERNAME=system
    
23. SET PASSWORD=system
    
24. 
    
25. exp %USERNAME%/%PASSWORD%@%ORACLE_SID% file=%BACKUPDIR%\%NOWDATE%\%COMPUTERNAME%-%ORACLE_SID%-fullbackup_%NOWTIME%.dmp log=%BACKUPDIR%\%NOWDATE%\%COMPUTERNAME%-%ORACLE_SID%-fullbackup_%NOWTIME%.log full=y direct=y consistent=y buffer=102400
    
26. 
    
27. SET HOST=1.1.1.1
    
28. SET FTP_USERNAME=backup
    
29. SET FTP_PASSWORD=backup
    
30. 
    
31. cd /d %BACKUPDIR%
    
32. 
    
33. echo open %HOST% >> %BACKUPDIR%\ftp.cfg
    
34. echo user %FTP_USERNAME% %FTP_PASSWORD% >> %BACKUPDIR%\ftp.cfg
    
35. echo bin >> %BACKUPDIR%\ftp.cfg
    
36. echo mkdir oradmp >> %BACKUPDIR%\ftp.cfg
    
37. echo cd oradmp >> %BACKUPDIR%\ftp.cfg
    
38. echo mkdir %COMPUTERNAME% >> %BACKUPDIR%\ftp.cfg
    
39. echo cd %COMPUTERNAME% >> %BACKUPDIR%\ftp.cfg
    
40. echo mkdir %NOWDATE% >> %BACKUPDIR%\ftp.cfg
    
41. echo cd %NOWDATE% >> %BACKUPDIR%\ftp.cfg
    
42. echo lcd %NOWDATE% >> %BACKUPDIR%\ftp.cfg
    
43. echo mput * >> %BACKUPDIR%\ftp.cfg
    
44. echo bye >> %BACKUPDIR%\ftp.cfg
    
45. ftp -i -n -v -s:%BACKUPDIR%\ftp.cfg
    
46. del /f /s /q %BACKUPDIR%\ftp.cfg 2>&1 >nul
    
47. 
    
48. forfiles /P %BACKUPDIR% /S /C "cmd /c del /f /s /q @file" /D -1 2>&1 >nul
    
49. for /f "usebackq" %%d in (`"dir /ad/b/s | sort /R"`) do rd "%%d" 2>&1 >nul
    
50. for /f "tokens=*" %%a in ('dir /b /ad /s "%BACKUPDIR%"^|sort /r') do rd "%%a" 2>&1 >nul
    

复制代码

Shell_HAT

SET Year=%date:~0,4%
这样的用法要注意可移植性，每个系统的日期格式可能不一样。