1.创建备份执行脚本(.bat 文件),创建完成后,双击运行检查下指定输出路径有没有对应的文件及文件夹
@echo off
set backup_data_path=D:\tmpdataback
set curdate=%date:~0,4%%date:~5,2%%date:~8,2%
md %backup_data_path%
exp tmp/orcl@ORCL file=%backup_data_path%\my%curdate%.dmp owner=tmp
log=%backup_data_path%\%curdate%.log
2.以Windows中的计划任务程序来触发这个备份脚本(以Win7为例)