LOFTER for ipad —— 让兴趣,更有趣

点击下载 关闭
利用windows任务计划程序运行脚本备份oracle数据库
中华 2024-08-06

backup.bat内容如下:

exp his/skhis168@skhisnew file=d:\dbbak\skhisnew_%date:~0,4%%date:~5,2%%date:~8,2%.dmp log=d:\dbbak\skhisnew_%date:~0,4%%date:~5,2%%date:~8,2%.log compress=n buffer=8092 consistent=y direct=n constraints=y feedback=10000 grants=y record=y indexes=y triggers=y rows=y


d:\winrar\winrar.exe A -ibck d:\dbbak\skhisnew_%date:~0,4%%date:~5,2%%date:~8,2%.rar d:\dbbak\skhisnew_%date:~0,4%%date:~5,2%%date:~8,2%.dmp d:\dbbak\skhisnew_%date:~0,4%%date:~5,2%%date:~8,2%.log


del /f d:\dbbak\skhisnew_%date:~0,4%%date:~5,2%%date:~8,2%.dmp

del /f d:\dbbak\skhisnew_%date:~0,4%%date:~5,2%%date:~8,2%.log


 @ 

推荐文章
评论(0)
分享到
转载我的主页