1、创建一个bat后缀文件。
2、文件内容编辑如下:
@echo off
rem set backupfile=f_database_%date:~0,4%-%date:~5,2%-%date:~8,2%.dmp
rem set logfile=f_database_%date:~0,4%-%date:~5,2%-%date:~8,2%.log
rem delete 30days files
forfiles /p "D:\oracleback\dpdata"" /d -30 /c "cmd /c echo deleting @file ... && del /f @path"
cd D:\oracleback\dpdata
rem backup schemas
set backupfile=ecology_%date:~0,4%-%date:~5,2%-%date:~8,2%.dmp
set logfile=ecology_%date:~0,4%-%date:~5,2%-%date:~8,2%.log
expdp ecology/ecology@orcl directory=dpdata dumpfile=%backupfile% logfile=%logfile% parallel=4