[文本处理] 批处理怎样调用rman命令备份到自动生成的目录？

rem script:fulbk
rem author:sun
rem date:2012-2-16
cd D:\bk\full
if not exist  %date:~0,10%  mkdir %date:~0,10%
set days=%date:~0,10%
set oracle_sid=test
set bkpath=D:\bk\full\%days%
cd %bkpath%
rman target /  cmdfile='d:\bk\fulbk.rcv' log='d:\bk\fullbk.log'
exit
复制代码

run {
allocate channel c1 device type disk format='%bkpath%\full_%U';
backup  incremental level 0 database include current controlfile plus archivelog delete input;
delete noprompt obsolete;
release channel c1;
}
复制代码

@set ORACLE_HOME=G:\oracle\product\10.2.0\db_1
@rem echo %ORACLE_HOME%
@set ORACLE_SID=test
@rem echo %ORACLE_SID%
@set NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK
@rem echo %NLS_LANG%
@set PATH=%ORACLE_HOME%\bin
@rem echo %PATH%
@set RMAN=%ORACLE_HOME%\bin\rman.exe
@set date=%date:~0,10%
@set BACKUP_DIR=D:\bk\full\%date%
@IF NOT EXIST %BACKUP_DIR% (
mkdir %BACKUP_DIR%
)
@set RQ=%date:~4,10%
@set RMAN_LOG_FILE=%BACKUP_DIR%\rman_%RQ%.log
@set DAY=%date:~13,14%
复制代码

@if "%DAY%" EQU "五" (
set BACKUPTYPE=incremental level 1 database 

set NAME=L1_%%d_%%T_%%s
set ARCHIVE=L1_%%d_%%T
)
复制代码

set BACKUPTYPE=incremental level 0 database   
set NAME=full05_%%d_%%T_%%U
set ARCHIVE=arch_%%d_%%T_%%U 
set CTL=ctl_%%d_%%T_%%U
@(
echo run { 
echo allocate channel c1 type disk;
echo sql "ALTER SYSTEM ARCHIVE LOG CURRENT";
echo backup %BACKUPTYPE%  format '%BACKUP_DIR%\%NAME%';
echo backup format '%BACKUP_DIR%\%ARCHIVE%' archivelog all delete all input;
echo backup current controlfile format '%BACKUP_DIR%\%CTL%';
echo crosscheck backup;
echo delete noprompt obsolete;
echo release channel c1; 
echo } 
) | %RMAN% target / msglog '%RMAN_LOG_FILE%'
复制代码