1 把如下代码加入到一记事本文件中,把文件的名字改成:数据库备份.bat
cd C:/Program Files/WinRAR
rem 备份CBCS 表空间
set DataBaseFile=E:/backup/database/CBCS%date:~4,10%
exp username1/password@orcl,owner=user1,file=%DataBaseFile%.dmp,log=%
DataBaseFile%.log,buffer=4096000,feedback=10000
rar a %DataBaseFile%.rar %DataBaseFile%.dmp %DataBaseFile%.log
del %DataBaseFile%.dmp
del %DataBaseFile%.log
rem 备份DB002 表空间
set DataBaseFile=E:/backup/database/DB002%date:~4,10%
exp username2/password@orcl,owner=user2_owner',file=%DataBaseFile%.dmp,log=%
DataBaseFile%.log,buffer=4096000,feedback=10000
rar a %DataBaseFile%.rar %DataBaseFile%.dmp %DataBaseFile%.log
del %DataBaseFile%.dmp
del %DataBaseFile%.log
2 在windows的控制面板中的任务计划中加入这一文件设置好时间等即可
备份后的文件名字形式如下:
DB0022009-12-13.rar