oracle备份

在使用exp备份库时,通常会在导出的文件名上加上具体时间,现在可以用下面的方式来实现

file=F:\backup\%date:~0,4%%date:~5,2%%date:~8,2%.dmp

 

还可以写成bat文件,放在计划任务里定时备份

backup.bat

 

@echo off
exp username/password file=E:\pcms_data_Backup\EXPDAT%date:~2,2%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%%time:~6,2%.dmp log=E:\pcms_data_Backup\EXPDAT%date:~2,2%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%%time:~6,2%.log
exit