本文共 1322 字，大约阅读时间需要 4 分钟。

?????Oracle??????????????????Windows?????
   
	
    
????
	
    		@echo off		@echo ================================================		@echo  windows Oracle ????		@echo 		@echo 1. BACKUP_DIR         - ????????		@echo 2. ORACLE_USERNAME   - ??Oracle???		@echo 3. ORACLE_PASSWORD   - ??Oracle??		@echo 4. ORACLE_DB         - ???????????		@echo 5. BACK_OPTION        - ????????????		@echo 6. RAR_CMD           - ??WinRAR????		
    
?????????????????
	
    		rem ??????		set BACKUP_DIR=D:\jboss-dljy\database_bak				rem ??Oracle??????		set ORACLE_USERNAME=ccpgjyzx		set ORACLE_PASSWORD=jyzx1hdkj				rem ???????????		set ORACLE_DB=ccpgyx_10.224.15.139				rem ??????????		set BACK_OPTION=owner=ccpgjyzx				rem ??WinRAR??		set RAR_CMD="C:\Progra~1\WinRAR\Rar.exe"		
    
?????????
	
    		for /f "tokens=1,2" %%a in ('date/t') do set TODAY=%%a		set BACK_NAME=%ORACLE_DB%_%TODAY%_%time:~0,2%_%time:~3,2%		set BACK_FULL_NAME=%BACKUP_DIR%/%BACK_NAME%		
    
???????
	
    		rem ??Oracle????		rem ??????		exp %BACK_OPTION% file="%BACK_FULL_NAME%.dmp" log="%BACK_FULL_NAME%exp.log"				rem ??WinRAR??????		%RAR_CMD% a -df "%BACK_FULL_NAME%back.rar" "%BACK_FULL_NAME%.dmp" "%BACK_FULL_NAME%exp.log"		
    
???????
	
    		rem ????????		forfiles /p D:\jboss-dljy\database_bak /s /m *.rar /d -7 /c "cmd /c del @file"	
   
[????]: Oracle???????????