Create directory scott as 'D:\';

Grant read,write on directory scott to scott;

写个.bat的程序，内容为

set backupfile=scott_%date:~0,4%-%date:~5,2%-%date:~8,2%.dmp

set logfile=scott_%date:~0,4%-%date:~5,2%-%date:~8,2%.log

D:\app\Administrator\product\11.2.0\dbhome_1\BIN\expdp scott/tiger@192.168.56.11/prod directory=scott dumpfile=%backupfile% logfile=%logfile%

rem delete 10days files

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

备份出来的是：scott_2014-10-27.dmp

set backupfile=full_%date:~0,4%-%date:~5,2%-%date:~8,2%.dmp

set logfile=full_%date:~0,4%-%date:~5,2%-%date:~8,2%.log

D:\app\Administrator\product\11.2.0\dbhome_1\BIN\expdp system/oracle@192.168.56.11/prod directory=full full=y dumpfile=%backupfile% logfile=%logfile%

导整个数据库

删掉十天前的备份，执行下面的命令，就会把10天前d:\bak\的所有文件都给删除了。所以这个文件下只能放备份

把这个命令也放到.bat里

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

ITPub博客

windowns系统，oracle数据库expdp自动备份