[其他] 调用rman命令备份数据库的批处理日期选择为何进行不下去？

ksly1227

日期选择进行不下去，下面变量CTL好像没有被赋值，请高手指导
@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 BACKUPTYPE=incremental level 0 database
set NAME=full05_%%d_%%T_%%U
set 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%'

ksly1227

高手请指导，自己up下

find

在第49行查看一下变量的值：

echo,%DAY%
echo,%CTL%
复制代码

ksly1227

3楼不行啊，加上你那2句之后  我有加啦pause
显示 echo ，
变量没显示出来啊
中间去掉逗号，说echo已经打开

echo , %CTL%
pause
命令输出结果：
D:\Program Files\UltraEdit>set BACKUPTYPE=incremental level 0 database  

D:\Program Files\UltraEdit>set NAME=full05_%d_%T_%U

D:\Program Files\UltraEdit>set ARCHIVE=arch_%d_%T_%U  

D:\Program Files\UltraEdit>echo ,  
,

D:\Program Files\UltraEdit>pause
请按任意键继续. . .

find

回复 4# ksly1227


你这哥们眼神咋还不好使了呢，49不是19啊

ksly1227

就是49行
@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 BACKUPTYPE=incremental level 0 database
set NAME=full05_%%d_%%T_%%U
set 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 , %CTL%
pause

@(
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

ksly1227

ediplus行号我没选择上

find

回复 6# ksly1227


不是吧，3楼明明是两行，到你这里怎么就变成一行？

ksly1227

有区别吗？？显示2个变量值和显示一个变量值一样，关键是现在显示不出来，我后面有加拉pause  自己看下结果在说

ksly1227

还有echo有那样用法吗？？   echo ，+变量？？？

find

回复 9# ksly1227


这个可以有
你最好自己试试再说
不能乱猜的

find

回复 10# ksly1227


这个必须有
只是你抄多了两个空格而已

find

echo,%CTL%看不到内容就说明你那一大堆if没搞对
这就是为啥它上面还要有一个echo,%DAY%来检查了

ksly1227

我现在把你哪2行加上，输出结果一样啊
下面是命令输出结果
D:\bk>set BACKUPTYPE=incremental level 0 database  

D:\bk>set NAME=full05_%d_%T_%U

D:\bk>set ARCHIVE=arch_%d_%T_%U  

D:\bk>echo,


D:\bk>echo ,  
,
RMAN> 2> 3> 4> 5> RMAN>

ksly1227

echo,%DAY%
echo,%CTL%
上面就是按照你的要求改的
输出结果还是步行
D:\bk>set BACKUPTYPE=incremental level 0 database  

D:\bk>set NAME=full05_%d_%T_%U

D:\bk>set ARCHIVE=arch_%d_%T_%U  

D:\bk>echo,


D:\bk>echo,

RMAN> 2> 3> 4> 5> RMAN>