Oracle11g物理STANDBY打开模式应用归档时无法执行备份

这个标题又够长的，可是不这么长无法将意思表达清楚。11.1.0.6上的bug，导致11g的物理STANDBY只读打开且应用日志的时候是无法进行备份的。

ITPUB个人空间!ck1P9a/M~1y7Q!V

STANDBY数据库的两种工作状态：应用日志状态和只读打开状态，都是可以进行备份的，而只读打开且同时应用日志状态备份报错：

[oracle@yangtk2 ~]$ sqlplus "/ as sysdba"

SQL*Plus: Release 11.1.0.6.0 - Production on Wed Dec 19 08:44:50 2007

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup mount ORACLE instance started.

Total System Global Area 267825152 bytesITPUB个人空间A.r!wZ]&{#Z
Fixed Size 1299316 bytesITPUB个人空间~"cUP,Xg4h,\
qb
Variable Size 167775372 bytesITPUB个人空间$kc8^ o5X'y5g*?b
Database Buffers 96468992 bytesITPUB个人空间.pJt j}G8s1Fd
Redo Buffers 2281472 bytesITPUB个人空间+@\ v#eq~ O
Database mounted.ITPUB个人空间.Z+{H,E9Y#l
SQL> alter database recover managed standby database disconnect from session;

Database altered.

SQL> hostITPUB个人空间9R#gw!{/d3D,y5^ x
[oracle@yangtk2 ~]$ rman target /

Recovery Manager: Release 11.1.0.6.0 - Production on Wed Dec 19 08:45:33 2007

Copyright (c) 1982, 2007, Oracle. All rights reserved.

connected to target database: ORA11G (DBID=4026820313, not open)

RMAN> backup tablespace users;

Starting backup at 19-DEC-07
Ias1|5J-XQ
{0using target database control file instead of recovery catalogITPUB个人空间@BKim4sH
allocated channel: ORA_DISK_1ITPUB个人空间:|:bK8_$YUYF
channel ORA_DISK_1: SID=140 device type=DISKITPUB个人空间~1Q7YQ1_s
channel ORA_DISK_1: starting full datafile backup set
R'q;VCL9_.m0channel ORA_DISK_1: specifying datafile(s) in backup set
0X2u }:A4tD3F~2w
X0input datafile file number=00004 name=/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_users_3d37bq45_.dbf
e*Kw-INrXXn0channel ORA_DISK_1: starting piece 1 at 19-DEC-07ITPUB个人空间T-^ u
J"T
v%Ip| E
channel ORA_DISK_1: finished piece 1 at 19-DEC-07
X;bet\`uoM9L"v0piece handle=/data1/backup/1sj3vru6_1_1 tag=TAG20071219T084558 comment=NONE
.H!_#N5P y"z ~0channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03ITPUB个人空间6c`Ecuu$n#c
Finished backup at 19-DEC-07

RMAN> exit

3{Zz3cUn(]$L0Recovery Manager complete.ITPUB个人空间(s3|'}c3I O1l Tc
[oracle@yangtk2 ~]$ exitITPUB个人空间{f,G0X8S
exit

SQL> alter database recover managed standby database cancel;

Database altered.

SQL> alter database open;

Database altered.

SQL> host
5sx{ h'y%DU
X0[oracle@yangtk2 ~]$ rman target /

Recovery Manager: Release 11.1.0.6.0 - Production on Wed Dec 19 08:47:10 2007

Copyright (c) 1982, 2007, Oracle. All rights reserved.

connected to target database: ORA11G (DBID=4026820313)

RMAN> backup tablespace users;

Starting backup at 19-DEC-07
m$] Q(P L0using target database control file instead of recovery catalogITPUB个人空间*O*I F`z5j
allocated channel: ORA_DISK_1ITPUB个人空间;U$l2\-D:P.Y
channel ORA_DISK_1: SID=145 device type=DISKITPUB个人空间/]4t.ROhm4[}H
channel ORA_DISK_1: starting full datafile backup setITPUB个人空间5v o8w'wre
channel ORA_DISK_1: specifying datafile(s) in backup set
,b7gLoiQ^+nY0input datafile file number=00004 name=/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_users_3d37bq45_.dbf
6PW2dRJs0channel ORA_DISK_1: starting piece 1 at 19-DEC-07ITPUB个人空间2i{^9w8M GI P*q
channel ORA_DISK_1: finished piece 1 at 19-DEC-07ITPUB个人空间}3plN fU
piece handle=/data1/backup/1tj3vs0m_1_1 tag=TAG20071219T084717 comment=NONE
gnrFMD*`0channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01ITPUB个人空间;| H;~H`$i3eY]"r
Finished backup at 19-DEC-07

RMAN> exit

}.h"j,\
faX l0Recovery Manager complete.
&a)y,As\*G&Nw"}0[oracle@yangtk2 ~]$ exitITPUB个人空间5Pr
dhNL
exit

SQL> alter database recover managed standby database disconnect from session;

Database altered.

SQL> host;
jAq7EG0[oracle@yangtk2 ~]$ rman target /

Recovery Manager: Release 11.1.0.6.0 - Production on Wed Dec 19 08:47:42 2007

Copyright (c) 1982, 2007, Oracle. All rights reserved.

connected to target database: ORA11G (DBID=4026820313)

RMAN> backup tablespace users;

Starting backup at 19-DEC-07
E%m&A5Jj Ov0using target database control file instead of recovery catalog
iWSv#KmdV0allocated channel: ORA_DISK_1
WG i%Qc"[!b,?S0channel ORA_DISK_1: SID=137 device type=DISK
)N/tD2}8e,n,MC&T0RMAN-00571: ===========================================================
%@!Y&CC/j+N
x Tt8d0RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
!Pr7F([ E2lI0RMAN-00571: ===========================================================ITPUB个人空间f(@iaGr"M,r`,a+n
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 12/19/2007 08:47:47
r)q{z7O0ORA-01153: an incompatible media recovery is active

从原理上考虑，只读打开状态不会对备份产生影响，既然应用日志的时候可以进行备份，那么只读打开状态下应用日志应该也是可以进行备份。

怀疑是Oracle的bug，查询Metalink，发现果然是bug：Bug No. 6454190，Oracle计划在11.1.0.7fixed这个bug。