丢失的ASM磁盘组新选.docx
- 文档编号:16627642
- 上传时间:2023-07-15
- 格式:DOCX
- 页数:15
- 大小:19.66KB
丢失的ASM磁盘组新选.docx
《丢失的ASM磁盘组新选.docx》由会员分享,可在线阅读,更多相关《丢失的ASM磁盘组新选.docx(15页珍藏版)》请在冰点文库上搜索。
丢失的ASM磁盘组新选
近日遇到一个问题,ASM的磁盘组无法挂载,之前是正常的,由于一些其他的操作,数据库启动失败,当问题排除时候,发现在数据库整体启动时,挂载磁盘组的环节出现问题。
环境介绍
#########################################
硬件:
VmwareESX虚拟机
OS:
Redhatlinux5
Oracleversion:
11.2.0.2
ASMdisk是通过asmlib挂载的
这个磁盘组只有一个虚拟出的硬盘,是/dev/sdb1.
#########################################
下面是我整个分析的过程
1.首先通过ASMalert.log,发现如下错误,磁盘挂载失败,无法找到磁盘组
1.SQL> alter diskgroup DATA mount
2.NOTE:
cache registered group DATA number=1 incarn=0xc28a1e2d
3.NOTE:
cache began mount (first) of group DATA number=1 incarn=0xc28a1e2d
4.Tue Dec 11 18:
06:
55 2012
5.ERROR:
no PST quorum in group:
required 2, found 0 <<<<<<<<<<<
6.NOTE:
cache dismounting (clean) group 1/0xC28A1E2D (DATA)
7.NOTE:
dbwr not being msg'd to dismount
8.NOTE:
lgwr not being msg'd to dismount
9.NOTE:
cache dismounted group 1/0xC28A1E2D (DATA)
10.NOTE:
cache ending mount (fail) of group DATA number=1 incarn=0xc28a1e2d
11.NOTE:
cache deleting context for group DATA 1/0xc28a1e2d
12.GMON dismounting group 1 at 8 for pid 17, osid 32163
13.ERROR:
diskgroup DATA was not mounted
14.ORA-15032:
not all alterations performed
15.ORA-15017:
diskgroup "DATA" cannot be mounted
16.ORA-15063:
ASM discovered an insufficient number of disks for diskgroup "DATA"
17.ERROR:
alter diskgroup DATA mount
2.首先检查ASMpfile文件,未发现异常
1.asm_diskgroups='DATA'
2.instance_type='asm'
3.large_pool_size=12M
4.remote_login_passwordfile='EXCLUSIVE'
3.尝试通过以下命令检查磁盘是否物理存在,是如何对应物理设备的,发现查询不到ASM磁盘
1.[grid@lgto_test ~]$ kfod disks=all
2.
3.----Non output----
4.
5.
6.
7.[grid@lgto_test peer]$ cd /dev/oracleasm/disks/
8.[grid@lgto_test disks]$ ls
9.
10.----Non output----
11.
12.
13.[grid@lgto_test disks]$ /etc/init.d/oracleasm listdisks
14.
15.----Non output----
4. 但是直接检查物理设备,/dev/sdb1是存在的,说明OS已经识别该硬盘设备,只是ASMlib无法正常识别:
1.查询对应的物理硬盘
2.[oracle@OEL~]$/etc/init.d/oracleasmquerydisk-ddisk1Disk"DISK1"isavalidASMdiskondevice[8,17]
3.[oracle@OEL~]$ls-l/dev/|grep8|grep17brw-r-----1rootdisk8,17Oct1614:
01sdb1
4.
5.[root@lgto_test ~]# ls -lst /dev/sd*
6.0 brw-r----- 1 root disk 8, 0 Dec 11 19:
29 /dev/sda
7.0 brw-r----- 1 root disk 8, 2 Dec 11 19:
29 /dev/sda2
8.0 brw-r----- 1 root disk 8, 16 Dec 11 19:
29 /dev/sdb
9.0 brw-r----- 1 root disk 8, 17 Dec 11 19:
29 /dev/sdb1 <<<<<< 10.0 brw-r----- 1 root disk 8, 1 Dec 11 11: 29 /dev/sda1 5. 起先是考虑是否是磁盘头损害,导致无法ASMlib识别该磁盘,dump磁盘头发现没有问题. 1.#od -c /dev/sdb1 2.…… 3.0000040 O R C L D I S K D A T A D G 0 1 4.…… 5.7760040 O R C L D I S K D A T A D G 0 1 这里补充下,如果磁盘头信息丢失,将会显示如下 1.0000040 O R C L D I S K \0 \0 \0 \0 \0 \0 \0 \0 如果显示这个结果,需要通过以下方式renamedisk,具体可以参考文档OracleasmListdisksCannotSeeDisks(DocID392527.1) 1.Use the "oracleasm renamedisk" utility to add an asmlib label to the disk: 2./etc/init.d/oracleasm renamedisk /dev/ 3.If it fails, use the "-f" switch: 4./etc/init.d/oracleasm renamedisk -f /dev/ 6. 重启ASMLib,检查是否是ASMLib问题 1.[root@lgto_test ~]# /etc/init.d/oracleasm restart 2.Dropping Oracle ASMLib disks: 3.[ OK ] 4.Shutting down the Oracle ASMLib driver: [FAILED] 检查文件系统oracleasm文件系统已经成功挂载 1.[root@lgto_test ~]# df -ha 2.Filesystem Size Used Avail Use% Mounted on 3.…… 4.oracleasmfs 0 0 0 - /dev/oracleasm 7. 检查/dev/sdb1状态,查看是否已经marked为ASMdisk,显示已经标记成功 1.[root@lgto_test ~]# oracleasm querydisk /dev/sdb1 2.Device "/dev/sdb1" is marked an ASM disk with the label "DATADG01" 3. 4.[root@lgto_test ~]# /sbin/service oracleasm scandisks 5.Scanning the system for Oracle ASMLib disks: 6.[ OK ] 7. 8.[root@lgto_test ~]# /etc/init.d/oracleasm listdisks 9.----Non output--- 8. 检查rpmpackage也没有问题 1.[grid@lgto_test ~]$ rpm -qa|grep oracleasm 2.oracleasmlib-2.0.4-1.el5 3.oracleasm-support-2.1.7-1.el5 4.oracleasm-2.6.18-308.el5-2.0.5-1.el5 9.收集Kfedlogs,没有检查到异常新信息。 1.[root@lgto_test ~]# /oracle/ora11g/product/app/grid/bin/kfed read /dev/sdb1 2. 3.kfbh.endian: 1 ; 0x000: 0x01 4. 5.kfbh.hard: 130 ; 0x001: 0x82 6. 7.kfbh.type: 1 ; 0x002: KFBTYP_DISKHEAD 8. 9.kfbh.datfmt: 1 ; 0x003: 0x01 10. 11.kfbh.block.blk: 0 ; 0x004: T=0 NUMB=0x0 12. 13.kfbh.block.obj: 2147483648 ; 0x008: TYPE=0x8 NUMB=0x0 14. 15.kfbh.check: 3351358462 ; 0x00c: 0xc7c1abfe 16. 17.kfbh.fcn.base: 0 ; 0x010: 0x00000000 18. 19.kfbh.fcn.wrap: 0 ; 0x014: 0x00000000 20. 21.kfbh.spare1: 0 ; 0x018: 0x00000000 22. 23.kfbh.spare2: 0 ; 0x01c: 0x00000000 24. 25.kfdhdb.driver.provstr: ORCLDISKDATADG01 ; 0x000: length=16 26. 27.kfdhdb.driver.reserved[0]: 1096040772 ; 0x008: 0x41544144 28. 29.kfdhdb.driver.reserved[1]: 825247556 ; 0x00c: 0x31304744 30. 31.kfdhdb.driver.reserved[2]: 0 ; 0x010: 0x00000000 32. 33.kfdhdb.driver.reserved[3]: 0 ; 0x014: 0x00000000 34. 35.kfdhdb.driver.reserved[4]: 0 ; 0x018: 0x00000000 36. 37.kfdhdb.driver.reserved[5]: 0 ; 0x01c: 0x00000000 38. 39.pat: 186646528 ; 0x020: 0x0b200000 40. 41.kfdhdb.dsknum: 0 ; 0x024: 0x0000 42. 43.kfdhdb.grptyp: 1 ; 0x026: KFDGTP_EXTERNAL 44. 45.kfdhdb.hdrsts: 3 ; 0x027: KFDHDR_MEMBER 46. 47.kfdhdb.dskname: DATADG01 ; 0x028: length=8 48. 49.kfdhdb.grpname: DATA ; 0x048: length=4 50. 51.kfdhdb.fgname: DATADG01 ; 0x068: length=8 52. 53.kfdhdb.capname: ; 0x088: length=0 54. 55.kfdhdb.crestmp.hi: 32977140 ; 0x0a8: HOUR=0x14 DAYS=0x7 MNTH=0xc YEAR=0x7dc 56. 57.kfdhdb.crestmp.lo: 1642529792 ; 0x0ac: USEC=0x0 MSEC=0x1c1 SECS=0x1e MINS=0x18 58. 59.kfdhdb.mntstmp.hi: 32977140 ; 0x0b0: HOUR=0x14 DAYS=0x7 MNTH=0xc YEAR=0x7dc 60. 61.kfdhdb.mntstmp.lo: 1664549888 ; 0x0b4: USEC=0x0 MSEC=0x1c1 SECS=0x33 MINS=0x18 62. 63.kfdhdb.secsize: 512 ; 0x0b8: 0x0200 64. 65.kfdhdb.blksize: 4096 ; 0x0ba: 0x1000 66. 67.kfdhdb.ausize: 1048576 ; 0x0bc: 0x00100000 68. 69.kfdhdb.mfact: 113792 ; 0x0c0: 0x0001bc80 70. 71.kfdhdb.dsksize: 204797 ; 0x0c4: 0x00031ffd 72. 73.kfdhdb.pmcnt: 3 ; 0x0c8: 0x00000003 74. 75.kfdhdb.fstlocn: 1 ; 0x0cc: 0x00000001 76. 77.kfdhdb.altlocn: 2 ; 0x0d0: 0x00000002 78. 79.kfdhdb.f1b1locn: 2 ; 0x0d4: 0x00000002 80. 81.kfdhdb.redomirrors[0]: 0 ; 0x0d8: 0x0000 82. 83.kfdhdb.redomirrors[1]: 0 ; 0x0da: 0x0000 84. 85.kfdhdb.redomirrors[2]: 0 ; 0x0dc: 0x0000 86. 87.kfdhdb.redomirrors[3]: 0 ; 0x0de: 0x0000 88. 89.kfdhdb.dbcompat: 168820736 ; 0x0e0: 0x0a100000 90. 91.kfdhdb.grpstmp.hi: 32977140 ; 0x0e4: HOUR=0x14 DAYS=0x7 MNTH=0xc YEAR=0x7dc 92. 93.kfdhdb.grpstmp.lo: 1642390528 ; 0x0e8: USEC=0x0 MSEC=0x139 SECS=0x1e MINS=0x18 94. 95.kfdhdb.vfstart: 0 ; 0x0ec: 0x00000000 96. 97.kfdhdb.vfend: 0 ; 0x0f0: 0x00000000 98. 99.kfdhdb.spfile: 58 ; 0x0f4: 0x0000003a 100. 101.kfdhdb.spfflg: 1 ; 0x0f8: 0x00000001 102. 103.kfdhdb.ub4spare[0]: 0 ; 0x0fc: 0x00000000 104. 105.kfdhdb.ub4spare[1]: 0 ; 0x100: 0x00000000 106. 107.kfdhdb.ub4spare[2]: 0 ; 0x104: 0x00000000 108. 109.kfdhdb.ub4spare[3]: 0 ; 0x108: 0x00000000 110. 111.kfdhdb.ub4spare[4]: 0 ; 0x10c: 0x00000000 112. 113.kfdhdb.ub4spare[5]: 0 ; 0x110: 0x00000000 114. 115.kfdhdb.ub4spare[6]: 0 ; 0x114: 0x00000000 116. 117.kfdhdb.ub4spare[7]: 0 ; 0x118: 0x00000000 118. 119.kfdhdb.ub4spare[8]: 0 ; 0x11c: 0x00000000 120. 121.kfdhdb.ub4spare[9]: 0 ; 0x120: 0x00000000 122. 123.kfdhdb.ub4spare[10]: 0 ; 0x124: 0x00000000 124. 125.kfdhdb.ub4spare[11]: 0 ; 0x128: 0x00000000 126. 127.kfdhdb.ub4spare[12]: 0 ; 0x12c: 0x00000000 128. 129.kfdhdb.ub4spare[13]: 0 ; 0x130: 0x00000000 130. 131.kfdhdb.ub4spare[14]: 0 ; 0x134: 0x00000000 132. 133.kfdhdb.ub4spare[15]: 0 ; 0x138: 0x00000000 134. 135.kfdhdb.ub4spare[16]: 0 ; 0x13c: 0x00000000 136. 137.kfdhdb.ub4spare[17]: 0 ; 0x140: 0x00000000 138. 139.kfdhdb.ub4spare[18]: 0 ; 0x144: 0x00000000 140. 141.kfdhdb.ub4spare[19]: 0 ; 0x148: 0x00000000 142. 143.kfdhdb.ub4spare[20]: 0 ; 0x14c: 0x00000000 144. 145.kfdhdb.ub4spare[21]: 0 ; 0x150: 0x00000000 146. 147.kfdhdb.ub4spare[22]: 0 ; 0x154: 0x00000000 148. 149.kfdhdb.ub4spare[23]: 0 ; 0x158: 0x00000000 150. 151.kfdhdb.ub4spare[24]: 0 ; 0x15c: 0x00000000 152. 153.kfdhdb.ub4spare[25]: 0 ; 0x1
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 丢失 ASM 磁盘 组新选
![提示](https://static.bingdoc.com/images/bang_tan.gif)