备份数据库BAT脚本

set expdate=%date:~0,4%%date:~5,2%%date:~8,2%
exp GDCAPP/GDCAPP file=e:\backup\db\report_%expdate%.dmp owner=report
exp GDCAPP/GDCAPP file=e:\backup\db\engine_%expdate%.dmp owner=engine
exp GDCAPP/GDCAPP file=e:\backup\db\gdcpermission_%expdate%.dmp owner=gdcpermission
exp GDCAPP/GDCAPP file=e:\backup\db\gdcapp_%expdate%.dmp owner=gdcapp
exp GDCAPP/GDCAPP file=e:\backup\db\processplatform_%expdate%.dmp owner=processplatform
exp GDCAPP/GDCAPP file=e:\backup\db\commonapp_%expdate%.dmp owner=commonapp
exp GDCAPP/GDCAPP file=e:\backup\db\ismart_%expdate%.dmp owner=ismart
exp GDCAPP/GDCAPP file=e:\backup\db\commonframework_%expdate%.dmp owner=commonframework
exp GDCAPP/GDCAPP file=e:\backup\db\usermgr_%expdate%.dmp owner=usermgr
exp GDCAPP/GDCAPP file=e:\backup\db\appmgr_%expdate%.dmp owner=appmgr
@echo 数据库备份完成，数据日期是%expdate%，请检查日志是否备份成功
pause


md "E:\数据备份\%ymd%" 
使用变量 %Ymd% 的值建立一个空的文件夹。

set expdate=%date:~0,4%%date:~5,2%%date:~8,2%
通过 %date% 这个系统变量得到日期，%date:~,4% 表示取日期的前面4个字符就是年份，%%date:~5,2% 表示取日期第5个字符开始的2个字符就是月份，%date:~8,2% 这个就是日期号数，如 2009-06-20 这个日期最后得到的结果是 20090620