脚本如下: echo off e: cd \ cd backup if exist myback5.dmp del myback5.dmp if exist myback4.dmp rename myback4.dmp myback5.dmp if exist myback3.dmp rename myback3.dmp myback4.dmp if exist myback2.dmp rename myback2.dmp myback3.dmp if exist myback1.dmp rename myback1.dmp myback2.dmp if exist myback5.log del myback5.log if exist myback4.log rename myback4.log myback5.log if exist myback3.log rename myback3.log myback4.log if exist myback2.log rename myback2.log myback3.log if exist myback1.log rename myback1.log myback2.log exp username/password@sid file = e:\backup\myback1.dmp log=e:\backup\myback1.log consistent=y buffer=4096000 RECORDLENGTH=65535 echo on
exp username/password 盘符:\文件名.dmp .........然后用计划任务定时运行此BAT
脚本如下:
echo off
e:
cd \
cd backup
if exist myback5.dmp del myback5.dmp
if exist myback4.dmp rename myback4.dmp myback5.dmp
if exist myback3.dmp rename myback3.dmp myback4.dmp
if exist myback2.dmp rename myback2.dmp myback3.dmp
if exist myback1.dmp rename myback1.dmp myback2.dmp
if exist myback5.log del myback5.log
if exist myback4.log rename myback4.log myback5.log
if exist myback3.log rename myback3.log myback4.log
if exist myback2.log rename myback2.log myback3.log
if exist myback1.log rename myback1.log myback2.log
exp username/password@sid file = e:\backup\myback1.dmp log=e:\backup\myback1.log consistent=y buffer=4096000 RECORDLENGTH=65535
echo on