天天看点

Windows下ORACLE EXPDP备份脚本

@echo off  

echo  正在进行备份任务,请稍等......

set ORACLE_SID=testdoc1

set BACKUPDATE=%date:~0,4%-%date:~5,2%-%date:~8,2%

C:\app\Administrator\product\11.2.0\dbhome_1\BIN\expdp system/oracle directory=dp dumpfile=full%BACKUPDATE%.dmp logfile=full%BACKUPDATE%.log compression=all cluster=no full=y

echo 备份完成