1. 建立一个文件oracledbbackup.bat,内容如下:
@echo offecho 正在备份Oracle数据库,请稍等......
exp userid='username/password@oracledbname as sysdba' file=d:/oracledbbackup/mbd%date:~0,4%%date:~5,2%%date:~8,2%.dmp log=d:/oracledbbackup/mbd%date:~0,4%%date:~5,2%%date:~8,2%.log full=yecho 任务完成!
参数说明:
username ---------------------> 数据库的用户名;
password --------------------->数据库密码;
oracledbname --------------------->数据库名字;
d:/oracledbbackup --------------------->服务器本地备份的目录;
mbd%date:~0,4%%date:~5,2%%date:~8,2%.dmp ------>备份的文件;
mbd%date:~0,4%%date:~5,2%%date:~8,2%.log -------->备份的日志;
2. 在本地建立备份的目录(d:/oracledbbackup)
3. 计划任务新建一个任务 .......略
4. 执行后,查看备份日志 log文件: