2017/2/10工作记录
今天学会了写一个cmd命令,自动备份数据库数据(并自动根据时间命名)
命令如下:
del F:\abc\temp\abc.dmp
del F:\abc\user\abc%date:~0,4%%date:~5,2%%date:~8,2%.dmp
exp ysb/pact@ORCL file=F:\abc\temp\abc.dmp owner=ysb
copy F:\abc\temp\abc.dmp F:\abc\user\abc%date:~0,4%%date:~5,2%%date:~8,2%.dmp
@rem copy F:\abc\db_temp\abc.dmp f:\abc%date:~0,4%%date:~5,2%%date:~8,2%.dmp
exit