在windows下进行Exp或者imp的时候,日志非常重要,但是exp没有提供导出开始和结束时间,经过尝试,先编辑一个bat文件,放入window的计划中,实行自动备份数据库,并且有备份数据库的开始和结束时间,备份数据库的数据文件文件名,日志文件名按照日期格式进行导出。
exp_db.bat
-----------------------------------
@echo cls
@echo off
@echo ------- %date% %time% --------------------------- >>exp_his.out
@echo 开始时间: %date% %time% >>exp_his.out
@echo expfile: gms_zzrq_%date:~0,4%%date:~5,2%%date:~8,2%.dmp >>exp_his.out
@echo logfile: exp_gms_zzrq_%date:~0,4%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%%time:~6,2%.log >>exp_his.out
@echo ====================================
@exp gms_zzrq/gms_zzrq@68 wner=gms_zzrq file=gms_zzrq_%date:~0,4%%date:~5,2%%date:~8,2%.dmp log=exp_gms_zzrq_%date:~0,4%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%%time:~6,2%.log buffer=204800000 >> exp_his.out
@echo ====================================
@echo 结束时间: %date% %time% >>exp_his.out
---exp_his.out
------- 2010-07-15 11:39:45.06 ---------------------------
开始时间: 2010-07-15 11:39:45.06
expfile: gms_zzrq_20100715.dmp
logfile: exp_gms_zzrq_20100715113945.log
结束时间: 2010-07-15 11:39:58.99
------- 2010-07-15 11:42:00.48 ---------------------------
开始时间: 2010-07-15 11:42:00.48
expfile: gms_zzrq_20100715.dmp
logfile: exp_gms_zzrq_2010071511~3,2%time:~6,2.log
结束时间: 2010-07-15 11:42:21.81
------- 2010-07-15 11:44:00.53 ---------------------------
开始时间: 2010-07-15 11:44:00.53
expfile: gms_zzrq_20100715.dmp
logfile: exp_gms_zzrq_20100715114400.log
结束时间: 2010-07-15 11:44:14.74
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/3090/viewspace-668074/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/3090/viewspace-668074/