oracle在windows下的自动备份
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文件后，就可以在计划任务中使用了，选择好备份时间，那么系统将自动备份了。
页:
[1]