level 1
mdshuo
楼主
环境:LINUX+11203+RAC
节点1出现报错并HANG住
ORA-16038: log 32 sequence# 32719 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 32 thread 1: '+DATA/netdb/onlinelog/group32_1'
ORA-00312: online log 32 thread 1: '+BAK/netdb/onlinelog/group32_2'
经排查,圈为ASM问题
ASM1日志出现:
Dumping diagnostic data in directory=[cdmp_20161008180834], requested by (instance=2, osid=5118 (LMD0)), summary=[incident=272140].
然后在ASM2日志中找到
ORA-04031: unable to allocate 3768 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","ges enqueues")
最终定位MEMORY_TARGET默认设置大小不足导致问题。
但是,节点ASM2实例问题,为什么会导致问题发生在节点1上?
不了解RDBMS实例与ASM实例的关联机制,是否有相关方面资料可查,麻烦推荐一二,先行谢过。
2016年10月11日 08点10分
1
节点1出现报错并HANG住
ORA-16038: log 32 sequence# 32719 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 32 thread 1: '+DATA/netdb/onlinelog/group32_1'
ORA-00312: online log 32 thread 1: '+BAK/netdb/onlinelog/group32_2'
经排查,圈为ASM问题
ASM1日志出现:
Dumping diagnostic data in directory=[cdmp_20161008180834], requested by (instance=2, osid=5118 (LMD0)), summary=[incident=272140].
然后在ASM2日志中找到
ORA-04031: unable to allocate 3768 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","ges enqueues")
最终定位MEMORY_TARGET默认设置大小不足导致问题。
但是,节点ASM2实例问题,为什么会导致问题发生在节点1上?
不了解RDBMS实例与ASM实例的关联机制,是否有相关方面资料可查,麻烦推荐一二,先行谢过。