本文最后更新于2018年6月26日，已超过 1 年没有更新，如果文章内容或图片资源失效，请留言反馈，我们会及时处理，谢谢！
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
@ECHO OFF set ora_path=G:\oracle\product\10.2.0\db_1\BIN set ORACLE_SID=orcl set bakfile_path=G:\backup\oradmp del G:\backup\myfile.txt del G:\backup\myfile1.txt date /t >>G:\backup\myfile.txt time /t >>G:\backup\myfile1.txt for /F "eol=; tokens=1 delims=/ " %%i in (G:\backup\myfile.txt) do set outp1=%%i for /F "eol=; tokens=2 delims=/ " %%i in (G:\backup\myfile.txt) do set outp2=%%i for /F "eol=; tokens=3 delims=/ " %%i in (G:\backup\myfile.txt) do set outp3=%%i for /F "eol=; tokens=1 delims=: " %%i in (G:\backup\myfile1.txt) do set outp4=%%i for /F "eol=; tokens=2 delims=: " %%i in (G:\backup\myfile1.txt) do set outp5=%%i set outp6=20_full_%outp1%-%outp2%-%outp3%_%outp4%_%outp5% set DaysAgo=2 forfiles /p %bakfile_path% /s /m *.dmp /d -%DaysAgo% /c "cmd /c del @path" forfiles /p %bakfile_path% /s /m *.log /d -%DaysAgo% /c "cmd /c del @path" %ora_path%\expdp.exe system/****** directory=expdp_dir2 dumpfile=%outp6%_%%U.dmp filesize=8192M logfile=%outp6%.log parallel=1 full=y copy %bakfile_path%\%outp6%.log G:\backup\log |
- 微信小程序
- 关注微信小程序
-
- 微信公众号
- 关注微信公众号
-
