@echo off
set /a days = 0
set /a ok = 0
set /a error = 0
:Again
if "17:58:00" == "%time:~0,8%" (
echo "begin......" >> abslog%ok%.txt
echo "导出测试数据库......" >> abslog%ok%.txt
exp absbank/absbank@192.168.70.166:1521/orcl OWNER=absbank file=F:\20151125\absbank.dmp log=oradbexp.log >> abslog%ok%.txt
echo "删除目标库所有表......" >> abslog%ok%.txt
sqlplus absbank/absbank @absbank.sql >> abslog%ok%.txt
echo "开始删除目标库所有表......" >> abslog%ok%.txt
sqlplus absbank/absbank @abs.sql >>abslog"%time:~0,8%".txt >> abslog%ok%.txt
imp absbank/absbank@localhost:1521/orcl FROMUSER=absbank TOUSER=absbank file=F:\20151125\absbank.dmp log=oradbimp.log >> abslog%ok%.txt
set /a days+=1
set /a ok+=1
echo END
goto Again
) else (
echo 一共%days%天,成功%ok%次;
echo 现在时间:%date:~0,10% %time:~0,8%
ping /n 2 127.1>nul
cls
goto Again
)