分享更有价值
被信任是一种快乐

ORACLE RAC 11.2.0.4 ASM加盘导致集群重启之ASM sga设置过小怎么处理

文章页正文上

小编给大家分享一下ORACLE RAC 11.2.0.4 ASM加盘导致集群重启之ASM sga设置过小怎么处理,相信大部分人都还不怎么了解,因此分享这篇文章给大家参考一下,希望大家阅读完这篇文章后大有收获,下面让我们一起去了解一下吧! 一同事为一2节点的ORACLE RAC 11.2.0.4集群ASM加盘,没有注意到ASM的sga设置过小,加盘reblance时导致集群重启。详细描述如下:1、问题描述
ORACLE RAC 11.2.0.4集群ASM加盘,没有注意到ASM的sga设置过小,加盘reblance时导致集群重启。2、问题分析
2.1 首先,接到运维监控告警,某某平台发生严重告警
2.2 登陆相关平台查看数据库和集群ASM日志,发现节点1集群发生重启,相关报错日志如下:Wed Dec 26 17:20:29 2018ARB0 started with pid=43, OS id=22557NOTE: assigning ARB0 to group 2/0x6b4139d2 (ORADATA) with 1 parallel I/ONOTE: Attempting voting file refres免费主机域名h on diskgroup ORADATAWed Dec 26 17:22:37 2018Errors in file /u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_arb0_22557.trc (incident=208353):ORA-04031: unable to allocate 7072 bytes of shared memory (“shared pool”,”unknown object”,”sga heap(1,1)”,”ges resource “)Incident details in: /u01/app/grid/diag/asm/+asm/+ASM1/incident/incdir_208353/+ASM1_arb0_22557_i208353.trcUse ADRCI or Support Workbench to package the incident.See Note 411.1 at My Oracle Support for error and packaging details.Wed Dec 26 17:22:39 2018Dumping diagnostic data in directory=[cdmp_20181226172239], requested by (instance=1, osid=22557 (ARB0)), summary=[incident=208353].Wed Dec 26 17:22:46 2018Errors in file /u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_m000_22771.trc (incident=208345):ORA-04031: unable to allocate 12312 bytes of shared memory (“shared pool”,”unknown object”,”KKSSP^1232″,”kglseshtTable”)Incident details in: /u01/app/grid/diag/asm/+asm/+ASM1/incident/incdir_208345/+ASM1_m000_22771_i208345.trcUse ADRCI or Support Workbench to package the incident.See Note 411.1 at My Oracle Support for error and packaging details.Errors in file /u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_m000_22771.trc:ORA-04031: unable to allocate 12312 bytes of shared memory (“shared pool”,”unknown object”,”KKSSP^1232″,”kglseshtTable”)2.3 数据库运维人员注意到,此前的主要操作主要就是给磁盘组加盘,观察ASM告警日志,相关操作记录如下:
Wed Dec 26 17:20:16 2018SQL> ALTER DISKGROUP ORADATA ADD DISK ‘/dev/rdisk/VD-DATA21′ SIZE 182272M ,’/dev/rdisk/VD-DATA22’ SIZE 182272M /* ASMCA */NOTE: GroupBlock outside rolling migration privileged regionNOTE: Assigning number (2,20) to disk (/dev/rdisk/VD-DATA21)NOTE: Assigning number (2,21) to disk (/dev/rdisk/VD-DATA22)NOTE: requesting all-instance membership refresh for group=2NOTE: initializing header on grp 2 disk ORADATA_0020NOTE: initializing header on grp 2 disk ORADATA_0021NOTE: requesting all-instance disk validation for group=2Wed Dec 26 17:20:19 2018NOTE: skipping rediscovery for group 2/0x6b4139d2 (ORADATA) on local instance.NOTE: requesting all-instance disk validation for group=2NOTE: skipping rediscovery for group 2/0x6b4139d2 (ORADATA) on local instance.NOTE: initiating PST update: grp = 2Wed Dec 26 17:20:25 2018GMON updating group 2 at 7 for pid 42, osid 22238NOTE: PST update grp = 2 completed successfullyNOTE: membership refresh pending for group 2/0x6b4139d2 (ORADATA)GMON querying group 2 at 8 for pid 18, osid 5128NOTE: cache opening disk 20 of grp 2: ORADATA_0020 path:/dev/rdisk/VD-DATA21NOTE: cache openin免费主机域名g disk 21 of grp 2: ORADATA_0021 path:/dev/rdisk/VD-DATA22Wed Dec 26 17:20:29 2018NOTE: Attempting voting file refresh on diskgroup ORADATAGMON querying group 2 at 9 for pid 18, osid 5128SUCCESS: refreshed membership for 2/0x6b4139d2 (ORADATA)Wed Dec 26 17:20:29 2018SUCCESS: ALTER DISKGROUP ORADATA ADD DISK ‘/dev/rdisk/VD-DATA21′ SIZE 182272M ,’/dev/rdisk/VD-DATA22′ SIZE 182272M /* ASMCA */NOTE: starting rebalance of group 2/0x6b4139d2 (ORADATA) at power 1Starting background process ARB0Wed Dec 26 17:20:29 2018ARB0 started with pid=43, OS id=22557NOTE: assigning ARB0 to group 2/0x6b4139d2 (ORADATA) with 1 parallel I/ONOTE: Attempting voting file refresh on diskgroup ORADATA2.4 到此,基本上可以确定是ASM加盘,ASM在进行reblance的时候,由于ASM的SGA设置过小导致的集群重启3、问题处理调整相关集群的ASM的SGA大小到2G,重新启动集群,ASM开始正常的reblance:Wed Dec 26 17:56:32 2018NOTE: client SYXPTDB1:SYXPTDB registered, osid 1074, mbr 0x1Wed Dec 26 18:35:33 2018ALTER SYSTEM SET memory_max_target=’2G’ SCOPE=SPFILE SID=’*’;ALTER SYSTEM SET memory_target=’2G’ SCOPE=SPFILE SID=’*’;ALTER SYSTEM SET sga_max_size=’2G’ SCOPE=SPFILE SID=’*’;Wed Dec 26 20:50:11 2018NOTE: GroupBlock outside rolling migration privileged regionNOTE: requesting all-instance membership refresh for group=2Wed Dec 26 20:50:14 2018NOTE: membership refresh pending for group 2/0x1edaa5d7 (ORADATA)Wed Dec 26 20:50:17 2018GMON querying group 2 at 7 for pid 18, osid 26306SUCCESS: refreshed membership for 2/0x1edaa5d7 (ORADATA)NOTE: Attempting voting file refresh on diskgroup ORADATA以上是“ORACLE RAC 11.2.0.4 ASM加盘导致集群重启之ASM sga设置过小怎么处理”这篇文章的所有内容,感谢各位的阅读!相信大家都有了一定的了解,希望分享的内容对大家有所帮助,如果还想学习更多知识,欢迎关注云技术行业资讯频道!

相关推荐: MySQL 5.6中timestamp和datetime区别有哪些

小编给大家分享一下MySQL 5.6中timestamp和datetime区别有哪些,相信大部分人都还不怎么了解,因此分享这篇文章给大家参考一下,希望大家阅读完这篇文章后大有收获,下面让我们一起去了解一下吧! MySQL会根据当前时区转化TIMESTAMP值,…

文章页内容下
赞(0) 打赏
版权声明:本站采用知识共享、学习交流,不允许用于商业用途;文章由发布者自行承担一切责任,与本站无关。
文章页正文下
文章页评论上

云服务器、web空间可免费试用

宝塔面板主机、支持php,mysql等,SSL部署;安全高速企业专供99.999%稳定,另有高防主机、不限制内容等类型,具体可咨询QQ:360163164,Tel同微信:18905205712

主机选购导航云服务器试用

登录

找回密码

注册