oracle数据库备份脚本问题

[小白619]

想备份一个oracle数据库，备份脚本如下：

@echo off
setlocal
set sid=ORCL
set username=XXXX
set password=XXXX
set bakdir=K:\database-bak\database-bak
set bakdate=%date:~0,4%%date:~5,2%%date:~8,2%
set connect=%username%/%password%@%sid%
exp %connect% file=%bakdir%/%bakdate%%username%.dmp log=%bakdir%/%bakdate%%username%.log
endlocal

这种情况是，dmp备份文件和log文件共存在同一个文件夹中，如果我们想把这两个文件分开存放，这个脚本怎么编辑呢？求大神！

[卖水果的net]

set bakdir=K:\database-bak\database-bak 下面加一句，并且要建立这个目录 set logdir=K:\database-bak\database-log 把 exp 改成 exp %connect% file=%bakdir%/%bakdate%%username%.dmp log=%baklog%/%bakdate%%username%.log

[sych888]

增加变量 @echo off setlocal set sid=ORCL set username=scott set password=tiger set bakdir=E:\kankan\dmp set logdir=E:\kankan\log set bakdate=%date:~0,4%%date:~5,2%%date:~8,2% set connect=%username%/%password%@%sid% exp %connect% file=%bakdir%/%bakdate%%username%.dmp log=%logdir%/%bakdate%%username%.log endlocal