RMAN CROSSCHECK命令小bug

问题不是发生在命令本身，而是发生在中文翻译上。

T]#c}(vze'm;_0

看下面的例子：

E:>SET ORACLE_HOME=E:ORACLEORACLE920

E:>%ORACLE_HOME%binrman target /@ytk92

恢复管理器: 版本9.2.0.4.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

连接到目标数据库: YTK92 (DBID=1285986946)

RMAN> crosscheck archivelog all;

正在使用目标数据库控制文件替代恢复目录分配的通道: ORA_DISK_1通道 ORA_DISK_1: sid=16 devtype=DISK对归档日志的验证成功存档日志文件名 =E:ORACLEORADATAYTK92ARCHIVE1_9.DBF 记录 ID=1 时间戳 =630202142对归档日志的验证成功存档日志文件名 =E:ORACLEORADATAYTK92ARCHIVE1_10.DBF 记录 ID=2 时间戳 =631117292对归档日志的验证成功存档日志文件名 =E:ORACLEORADATAYTK92ARCHIVE1_11.DBF 记录 ID=3 时间戳 =631459376对归档日志的验证成功存档日志文件名 =E:ORACLEORADATAYTK92ARCHIVE1_12.DBF 记录 ID=4 时间戳 =634003780对归档日志的验证成功存档日志文件名 =E:ORACLEORADATAYTK92ARCHIVE1_13.DBF 记录 ID=5 时间戳 =635334356对归档日志的验证失败存档日志文件名 =E:ORACLEORADATAYTK92ARCHIVE1_14.DBF 记录 ID=6 时间戳 =636374339对归档日志的验证失败存档日志文件名 =E:ORACLEORADATAYTK92ARCHIVE1_15.DBF 记录 ID=7 时间戳 =636636080对归档日志的验证失败存档日志文件名 =E:ORACLEORADATAYTK92ARCHIVE1_16.DBF 记录 ID=8 时间戳 =637149058对归档日志的验证失败存档日志文件名 =E:ORACLEORADATAYTK92ARCHIVE1_17.DBF 记录 ID=9 时间戳 =638414429对归档日志的验证失败存档日志文件名 =E:ORACLEORADATAYTK92ARCHIVE1_18.DBF 记录 ID=10 时间戳 =640227158已交叉检验的 10 对象

$m&V
RX3hS?$i0RMAN> exit

恢复管理器完成。

E:>SET NLS_LANG=AMERICAN

E:>%ORACLE_HOME%binrman target /@ytk92

Recovery Manager: Release 9.2.0.4.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

connected to target database: YTK92 (DBID=1285986946)

RMAN> crosscheck archivelog all;

using target database controlfile instead of recovery catalog
k2i$vmr0allocated channel: ORA_DISK_1ITPUB个人空间%l;]/wd7gR4}
Z*r{
channel ORA_DISK_1: sid=15 devtype=DISK
Lh9V S%T W%f\-VT0validation failed for archived log
#q*A y`Vm;L6\0archive log filename=E:ORACLEORADATAYTK92ARCHIVE1_9.DBF recid=1 stamp=630202142ITPUB个人空间R O'kBBex^
validation failed for archived log
3l o({^2WP*C;@0archive log filename=E:ORACLEORADATAYTK92ARCHIVE1_10.DBF recid=2 stamp=631117292
Vy b@-s"qSSo%l]0validation failed for archived logITPUB个人空间AE:a6P'u]W,Odn#{G
archive log filename=E:ORACLEORADATAYTK92ARCHIVE1_11.DBF recid=3 stamp=631459376
$Y.Z"@*zw [-rF o0validation failed for archived log
Ux*uH `0archive log filename=E:ORACLEORADATAYTK92ARCHIVE1_12.DBF recid=4 stamp=634003780ITPUB个人空间}1gt&X4b%X?,g k&p(z
validation failed for archived logITPUB个人空间!Xq3D#eE'M
archive log filename=E:ORACLEORADATAYTK92ARCHIVE1_13.DBF recid=5 stamp=635334356ITPUB个人空间XYqw:QP_
validation succeeded for archived log
Rs%D7A-U*C-g0archive log filename=E:ORACLEORADATAYTK92ARCHIVE1_14.DBF recid=6 stamp=636374339ITPUB个人空间!GT(|0],};wO!}
validation succeeded for archived log
}a,p-KS`-s'UT(Y0archive log filename=E:ORACLEORADATAYTK92ARCHIVE1_15.DBF recid=7 stamp=636636080ITPUB个人空间gc^M%N8z2sfL
validation succeeded for archived logITPUB个人空间6fB7w.Kpwv
archive log filename=E:ORACLEORADATAYTK92ARCHIVE1_16.DBF recid=8 stamp=637149058ITPUB个人空间u3ow5N"J Ec2g
validation succeeded for archived logITPUB个人空间vG+{6_G wcP? K'}
archive log filename=E:ORACLEORADATAYTK92ARCHIVE1_17.DBF recid=9 stamp=638414429ITPUB个人空间a1@KYw"D
validation succeeded for archived logITPUB个人空间)u rU)Q$K^p2xG7q
archive log filename=E:ORACLEORADATAYTK92ARCHIVE1_18.DBF recid=10 stamp=640227158
`3_ [*L$D!|Se0Crosschecked 10 objects

很明显中文翻译和英文的原文是反着的。英文的failed被翻译为成功，英文的succeeded被翻译为失败。

检查实际情况：

E:>DIR E:ORACLEORADATAYTK92ARCHIVE
d/?1la;t&C!kj+t9Xu0 驱动器 E 中的卷没有标签。ITPUB个人空间(rsI(G"_"CP
卷的序列号是 9037-19E7

E:ORACLEORADATAYTK92ARCHIVE 的目录

2007-12-02 00:52 <DIR> .
3r0IS3_|02007-12-02 00:52 <DIR> ..ITPUB个人空间3\3J0|z;KF5b
2007-10-19 10:38 49,586,176 1_14.DBFITPUB个人空间8y;q~%gl ur
2007-10-22 11:21 104,857,088 1_15.DBFITPUB个人空间Z#^:~[._!\n)Z+?v
2007-10-28 09:50 104,857,088 1_16.DBF
a6m/ex/L'@
C#y02007-11-12 01:20 64,443,392 1_17.DBFITPUB个人空间jQEUp~$V8X
2007-12-02 00:52 7,100,928 1_18.DBF
$t2rl#Y Z0 5 个文件 330,844,672 字节ITPUB个人空间'H[%B^vZ.Q3[
2 个目录 10,308,681,728 可用字节

看来英文原文并没有错误，是翻译为中文的时候出的问题。这个问题说小就小，几乎可以忽略；说大也大，如果被这个提示误导，手工把存在的归档日志当作丢失的删除掉，那么问题就比较严重了。总之，这个问题是个很低级的错误。

在10g中问题仍然存在，Oracle在11g中改正了这个问题。