echo 设置数据服务名
set dcibkdatasource=orcl
echo 设置要导出的数据库用户名
set dcibkuser=**mis
echo 设置要导出的数据库用户密码
set dcibkpwd=**mis
set dcibkpath=%~sdp0备份数据
set dcizipname=%dcibkpath%\%dcibkuser%%date:~0,4%-%date:~5,2%-%date:~8,2%-%time:~0,2%:%time:~3,2%:%time:~6,2%.zip
echo 删除10天前的备分文件和日志
forfiles /p %dcibkpath% /m *.zip /d -10 /c "cmd /c del @path"
md %dcibkpath%
exp %dcibkuser%/%dcibkpwd%@%dcibkdatasource% file=%dcibkpath%\%dcibkuser%.dmp log=%dcibkpath%\%dcibkuser%.log
zip %dcizipname% %dcibkpath%\*.dmp %dcibkpath%\*.log
