windowns系统下oracle数据库exp自动备份

写个.bat的程序，内容为

 

 

exp  scott/tiger@192.168.56.11/prod file=D:\scott%date:~0,4%%date:~5,2%%date:~8,2%.dmp log=D:\scott%date:~0,4%%date:~5,2%%date:~8,2%.txt

 

rem delete 10days files

forfiles /p "d:\bak" /d -10  /c "cmd /c echo deleting @file ... && del /f @path"

 

 

 

 

 

备份出来的是 scott20141027.dmp

 

 

 

exp  system/oracle@192.168.56.11/prod full=y file=D:\full%date:~0,4%%date:~5,2%%date:~8,2%.dmp log=D:\full%date:~0,4%%date:~5,2%%date:~8,2%.txt

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29893219/viewspace-1340563/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29893219/viewspace-1340563/