客户一dataguard为10.2.0.1 rac,数据文件部署在asm上,今天发生一错误记录如下:
[quote]Thu Dec 16 01:50:34 2010
RFS[3]: Successfully opened standby log 9: '+ASM_DATADG/standby/onlinelog/group_9.479.700959429'
Thu Dec 16 01:50:35 2010
Recovery of Online Redo Log: Thread 1 Group 9 Seq 28671 Reading mem 0
Mem# 0 errs 0: +ASM_DATADG/standby/onlinelog/group_9.479.700959429
Mem# 1 errs 0: +ASM_DATADG/standby/onlinelog/group_9.480.700959429
Thu Dec 16 01:50:35 2010
Errors in file /oracle/admin/standby/bdump/standby1_asmb_1548398.trc:
ORA-04031: unable to allocate 3912 bytes of shared memory ("shared pool","unknown object","sga heap(1,1)","ASM extent pointer array")
Thu Dec 16 01:50:35 2010
ASMB: terminating instance due to error 4031
Thu Dec 16 01:50:36 2010
System state dump is made for local instance
System State dumped to trace file /oracle/admin/standby/bdump/standby1_diag_1622170.trc
Thu Dec 16 01:50:36 2010
Trace dumping is performing id=[cdmp_20101216015036]
Thu Dec 16 01:50:40 2010
Instance terminated by ASMB, pid = 1548398
Thu Dec 16 08:06:28 2010 [/quote]
经查又是bug引起,bug号为5232574
[quote]Thu Dec 16 01:50:34 2010
RFS[3]: Successfully opened standby log 9: '+ASM_DATADG/standby/onlinelog/group_9.479.700959429'
Thu Dec 16 01:50:35 2010
Recovery of Online Redo Log: Thread 1 Group 9 Seq 28671 Reading mem 0
Mem# 0 errs 0: +ASM_DATADG/standby/onlinelog/group_9.479.700959429
Mem# 1 errs 0: +ASM_DATADG/standby/onlinelog/group_9.480.700959429
Thu Dec 16 01:50:35 2010
Errors in file /oracle/admin/standby/bdump/standby1_asmb_1548398.trc:
ORA-04031: unable to allocate 3912 bytes of shared memory ("shared pool","unknown object","sga heap(1,1)","ASM extent pointer array")
Thu Dec 16 01:50:35 2010
ASMB: terminating instance due to error 4031
Thu Dec 16 01:50:36 2010
System state dump is made for local instance
System State dumped to trace file /oracle/admin/standby/bdump/standby1_diag_1622170.trc
Thu Dec 16 01:50:36 2010
Trace dumping is performing id=[cdmp_20101216015036]
Thu Dec 16 01:50:40 2010
Instance terminated by ASMB, pid = 1548398
Thu Dec 16 08:06:28 2010 [/quote]
经查又是bug引起,bug号为5232574