Oracle备份可执行文件（.bat）

windows使用定时任务，每天凌晨1点执行此文件

@echo off
echo Starting bakup oracledata.........
set dd=%date%
set tt=%time%
set tt1=%dd:~0,4%%dd:~5,2%%dd:~8,2%%tt:~0,2%%tt:~3,2%%tt:~6,2%
set tt2=%tt1: =0%
echo %tt2%

exp userName/passWord@192.168.0.1:1521/orcl file=F:/oracleDBBack/oracledata%tt2%.dmp log=F:/oracleDBBack/oracledata%tt2%.txt
echo Bakup completed.
echo ------