oracle自动备份

1.

@echo off
set curdate=%date:~0,4%%date:~5,2%%date:~8,2%
set backuppath=E:\oracle\databak\%curdate%
md %backuppath%
exp fnfloa/fnfloauser@orcl file=%backuppath%\fnfloa%curdate%.dmp log=%backuppath%\fnfloa%curdate%.log

%date:~0,4%:取得年份

%date:~5,2%:取得月份

%date:~8,2%:取得日

md %backuppath% 建立目录
设置好bat文件后，就可以在计划任务中使用了，选择好备份时间，那么系统将自动备份了。