Oracle自动备份批处理
/* 定义日期变量 */
set rq=%date:~0,10%
/* 备份数据库 */
rem exp dlsjzs/dlsjzs@orcl file=d:\dbbak\dlsjzs%date:~0,4%%date:~5,2%%date:~8,2%.dmp
expdp dlsjzs/dlsjzs@orcl logfile=log.log directory=expdp_dmp dumpfile=dlsjzs%date:~0,4%%date:~5,2%%date:~8,2%.dmp
go
评论已关闭