
調用rman命令備份數據庫的批處理日期選擇為何進行不下去日期選擇進行不下去,下面變量CTL好像沒有被賦值,請高手指導@set ORACLE_HOME=G:oracleproduct10.2.0db_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%binrman.exe@set date=%date:~0,10%@set BACKUP_DIR=D:bkfull%date%@IF NOT EXIST %BACKUP_DIR% (mkdir %BACKUP_DIR%)@set RQ=%date:~4,10%@set RMAN_LOG_FILE=%BACKUP_DIR%rman_%RQ%.logset BACKUPTYPE=incremental level 0 database set NAME=full05_%%d_%%T_%%Uset ARCHIVE=arch_%%d_%%T_%%U @set DAY=%date:~13,14%@if %DAY% EQU 一 (set CTL=ctl1_%%d_%%T_%%U )@if %DAY% EQU 二 (set CTL=ctl2_%%d_%%T_%%U)@if %DAY% EQU 三 (set CTL=ctl3_%%d_%%T_%%U)@if %DAY% EQU 四 (set CTL=ctl4_%%d_%%T_%%U)@if %DAY% EQU 五 (set CTL=ctl5_%%d_%%T_%%U)@if %DAY% EQU 六 (set CTL=ctl6_%%d_%%T_%%U )@if %DAY% EQU 日 (set CTL=ctl0_%%d_%%T_%%U)@(echo run { echo allocate channel c1 type disk;echo backup current controlfile format '%BACKUP_DIR%%CTL%';echo release channel c1;echo } ) | %RMAN% target / msglog '%RMAN_LOG_FILE%'

