Oracle性能调优：11gwindows备份脚本

会计考友

Oracle 11g windows expdp备份脚本     SQL语句：创建备份目录
8 B8 w: |( O, W  ?$ J' G* X    CREATE OR REPLACE DIRECTORY backup AS 'e:\tank';
; o. V% u  B- {+ D5 v; F    GRANT READ, WRITE ON DIRECTORY backup TO tank;
" A4 v: z- g7 k! b% S    以下为windows 批处理脚本。
' ?' d1 O% ^$ V    //说明： 备份tank用户下的指为schemas为tank的那所有备，并发通道为4个，保留备份30天。
    @echo off
% `4 g# b2 {# ]# [    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 "e:\tank" /d -30  /c "cmd /c echo deleting @file … && del /f @path"
    cd e:\tank
6 F$ ]. }5 ?- p( s: g+ j+ s  V$ g    rem backup schemas
    set backupfile=tank_%date:~0,4%-%date:~5,2%-%date:~8,2%.dmp
    set logfile=tank_%date:~0,4%-%date:~5,2%-%date:~8,2%.log
    "D:\app\Administrator\product\11.2.0\dbhome_1\BIN\expdp.exe" tank/tank directory=backup  dumpfile=%backupfile%  logfile=%logfile% schemas=tank parallel=4