Oracle 创建定时计划备份数据库脚本。

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