我们的文章会在微信公众号IT民工的龙马人生和博客网站( www.htz.pw )同步更新 ,欢迎关注收藏,也欢迎大家转载,但是请在文章开始地方标注文章出处,谢谢!
由于博客中有大量代码,通过页面浏览效果更佳。
Oracle故障处理:ASM手动修复磁盘头
1,磁盘组中,其中一个磁盘头损坏
[oracle@asm10g ~]$ dd if=/dev/zero of=/dev/mapper/asm6 bs=1024 count=11+0 records in1+0 records out1024 bytes (1.0 kB) copied, 1.6e-05 seconds, 64 MB/s
欢迎大家加入ORACLE超级群:17115662 免费解决各种ORACLE问题,以后BLOG将迁移到http://www.htz.pw
SQL> alter diskgroup test mount;alter diskgroup test mount*ERROR at line 1:ORA-15032: not all alterations performedORA-15040: diskgroup is incompleteORA-15042: ASM disk "2" is missingSQL> l1* select a.disk_number,a.path,a.name,a.state,b.name from v$asm_disk a ,v$asm_diskgroup b where a.group_number=b.group_numberSQL> /DISK_NUMBER PATH NAME STATE NAME———– ——————– —————————— ——– ——————————0 /dev/mapper/asm4 NORMAL TEST1 /dev/mapper/asm5 NORMAL TEST2 /dev/mapper/asm6 NORMAL TEST0 /dev/mapper/asm3 ARCH_0000 NORMAL ARCH1 /dev/mapper/asm2 DATA_0001 NORMAL DATA0 /dev/mapper/asm1 DATA_0000 NORMAL DATA[oracle@asm10g ~]$ ./test.sh 1 0 1000 /dev/mapper/asm4 KFBTYP_DISKDIR[oracle@asm10g ~]$ ./test.sh 1 0 1000 /dev/mapper/asm5 KFBTYP_DISKDIR[oracle@asm10g ~]$ ./test.sh 1 0 1000 /dev/mapper/asm6 KFBTYP_DISKDIRKFBTYP_DISKDIR–blocks number–512–extent number—2—-block number—0——KFBTYP_DISKDIR–blocks number–513–extent number—2—-block number—1——KFBTYP_DISKDIR–blocks number–514–extent number—2—-block number—2——KFBTYP_DISKDIR–blocks number–515–extent number—2—-block number—3——KFBTYP_DISKDIR–blocks number–516–extent number—2—-block number—4——KFBTYP_DISKDIR–blocks number–517–extent number—2—-block number—5——KFBTYP_DISKDIR–blocks number–518–extent number—2—-block number—6——KFBTYP_DISKDIR–blocks number–519–extent number—2—-block number—7——KFBTYP_DISKDIR–blocks number–520–extent number—2—-block number—8——KFBTYP_DISKDIR–blocks number–521–extent number—2—-block number—9——KFBTYP_DISKDIR–blocks number–522–extent number—2—-block number—10——KFBTYP_DISKDIR–blocks number–523–extent number—2—-block number—11——KFBTYP_DISKDIR–blocks number–524–extent number—2—-block number—12——KFBTYP_DISKDIR–blocks number–525–extent number—2—-block number—13——KFBTYP_DISKDIR–blocks number–526–extent number—2—-block number—14——KFBTYP_DISKDIR–blocks number–527–extent number—2—-block number—15——KFBTYP_DISKDIR–blocks number–528–extent number—2—-block number—16——KFBTYP_DISKDIR–blocks number–529–extent number—2—-block number—17——KFBTYP_DISKDIR–blocks number–530–extent number—2—-block number—18——[oracle@asm10g ~]$ kfed read /dev/mapper/asm6 aunum=2 blknum=0|morekfddde[0].entry.refer.incarn: 0 ; 0x030: A=0 NUMM=0x0kfddde[0].dsknum: 0 ; 0x034: 0x0000kfddde[0].state: 2 ; 0x036: KFDSTA_NORMALkfddde[0].ub1spare: 0 ; 0x037: 0x00kfddde[0].dskname: TEST_0000 ; 0x038: length=9kfddde[0].fgname: TEST_0000 ; 0x058: length=9kfddde[0].crestmp.hi: 32991061 ; 0x078: HOUR=0x15 DAYS=0x1a MNTH=0x9 YEAR=0x7ddkfddde[0].crestmp.lo: 2138126336 ; 0x07c: USEC=0x0 MSEC=0x4e SECS=0x37 MINS=0x1fkfddde[0].failstmp.hi: 0 ; 0x080: HOUR=0x0 DAYS=0x0 MNTH=0x0 YEAR=0x0kfddde[0].failstmp.lo: 0 ; 0x084: USEC=0x0 MSEC=0x0 SECS=0x0 MINS=0x0kfddde[0].timer: 0 ; 0x088: 0x00000000kfddde[0].size: 1024 ; 0x08c: 0x00000400kfddde[0].spare[0]: 0 ; 0x090: 0x00000000kfddde[0].spare[1]: 0 ; 0x094: 0x00000000…………………………kfddde[1].dsknum: 1 ; 0x1f4: 0x0001kfddde[1].state: 2 ; 0x1f6: KFDSTA_NORMALkfddde[1].ub1spare: 0 ; 0x1f7: 0x00kfddde[1].dskname: TEST_0001 ; 0x1f8: length=9kfddde[1].fgname: TEST_0001 ; 0x218: length=9kfddde[1].crestmp.hi: 32991061 ; 0x238: HOUR=0x15 DAYS=0x1a MNTH=0x9 YEAR=0x7ddkfddde[1].crestmp.lo: 2138126336 ; 0x23c: USEC=0x0 MSEC=0x4e SECS=0x37 MINS=0x1fkfddde[1].failstmp.hi: 0 ; 0x240: HOUR=0x0 DAYS=0x0 MNTH=0x0 YEAR=0x0kfddde[1].failstmp.lo: 0 ; 0x244: USEC=0x0 MSEC=0x0 SECS=0x0 MINS=0x0kfddde[1].timer: 0 ; 0x248: 0x00000000kfddde[1].size: 1024 ; 0x24c: 0x00000400kfddde[1].spare[0]: 0 ; 0x250: 0x00000000…………………………………………kfddde[2].entry.incarn: 1 ; 0x3a4: A=1 NUMM=0x0kfddde[2].entry.hash: 2 ; 0x3a8: 0x00000002kfddde[2].entry.refer.number:4294967295 ; 0x3ac: 0xffffffffkfddde[2].entry.refer.incarn: 0 ; 0x3b0: A=0 NUMM=0x0kfddde[2].dsknum: 2 ; 0x3b4: 0x0002kfddde[2].state: 2 ; 0x3b6: KFDSTA_NORMALkfddde[2].ub1spare: 0 ; 0x3b7: 0x00kfddde[2].dskname: TEST_0002 ; 0x3b8: length=9kfddde[2].fgname: TEST_0002 ; 0x3d8: length=9kfddde[2].crestmp.hi: 32991061 ; 0x3f8: HOUR=0x15 DAYS=0x1a MNTH=0x9 YEAR=0x7ddkfddde[2].crestmp.lo: 2138126336 ; 0x3fc: USEC=0x0 MSEC=0x4e SECS=0x37 MINS=0x1fkfddde[2].failstmp.hi: 0 ; 0x400: HOUR=0x0 DAYS=0x0 MNTH=0x0 YEAR=0x0kfddde[2].failstmp.lo: 0 ; 0x404: USEC=0x0 MSEC=0x0 SECS=0x0 MINS=0x0kfddde[2].timer: 0 ; 0x408: 0x00000000kfddde[2].size: 1024 ; 0x40c: 0x00000400kfddde[2].spare[0]: 0 ; 0x410: 0x00000000kfddde[2].spare[1]: 0 ; 0x414: 0x00000000kfddde[2].spare[2]: 0 ; 0x418: 0x00000000kfddde[2].spare[3]: 0 ; 0x41c: 0x00000000kfddde[2].spare[4]: 0 ; 0x420: 0x00000000kfdhdb.dsknum: 2 ; 0x024: 0x0001kfdhdb.grptyp: 1 ; 0x026: KFDGTP_EXTERNALkfdhdb.hdrsts: 3 ; 0x027: KFDHDR_MEMBERkfdhdb.dskname: TEST_0002 ; 0x028: length=9kfdhdb.grpname: TEST ; 0x048: length=4kfdhdb.fgname: TEST_0002 ; 0x068: length=9kfdhdb.capname: ; 0x088: length=0[oracle@asm10g ~]$ kfed merge /dev/mapper/asm6 text=asm6.txt[oracle@asm10g ~]$SQL> alter diskgroup test mount;Diskgroup altered.
2,只有一个磁盘的磁盘组
下面是只有一个盘的DISKGROUP
SQL> drop diskgroup test;Diskgroup dropped.SQL> create diskgroup test external redundancy disk ‘/dev/mapper/asm4’;Diskgroup created.[oracle@asm10g ~]$ dd if=/dev/zero of=/dev/mapper/asm4 bs=1024 count=11+0 records in1+0 records out1024 bytes (1.0 kB) copied, 0.000163 seconds, 6.3 MB/sSQL> alter diskgroup test mount;alter diskgroup test mount*ERROR at line 1:ORA-15032: not all alterations performedORA-15063: ASM discovered an insufficient number of disks for diskgroup "TEST"[oracle@asm10g ~]$ kfod a=/dev/mapper/asm* d=all s=true——————————————————————————–Disk Size Header Path ===========================================================================1: 1024 Mb MEMBER /dev/mapper/asm12: 2048 Mb MEMBER /dev/mapper/asm23: 3072 Mb MEMBER /dev/mapper/asm34: 1024 Mb CANDIDATE /dev/mapper/asm45: 1024 Mb CANDIDATE /dev/mapper/asm56: 1024 Mb CANDIDATE /dev/mapper/asm6——————————————————————————–ORACLE_SID ORACLE_HOME ==========================================================================+ASM /u01/app/oracle/product/10.2.0/db[oracle@asm10g ~]$ ./test.sh 1 0 1000 /dev/mapper/asm4 KFBTYP_DISKDIR|moreKFBTYP_DISKDIR–blocks number–768–extent number—3—-block number—0——KFBTYP_DISKDIR–blocks number–769–extent number—3—-block number—1——KFBTYP_DISKDIR–blocks number–770–extent number—3—-block number—2——KFBTYP_DISKDIR–blocks number–771–extent number—3—-block number—3——KFBTYP_DISKDIR–blocks number–772–extent number—3—-block number—4——KFBTYP_DISKDIR–blocks number–773–extent number—3—-block number—5——[oracle@asm10g ~]$ kfed read /dev/mapper/asm4 aunum=3 blknum=0|morekfbh.endian: 1 ; 0x000: 0x01kfbh.hard: 130 ; 0x001: 0x82kfbh.type: 6 ; 0x002: KFBTYP_DISKDIRkfbh.datfmt: 1 ; 0x003: 0x01kfbh.block.blk: 0 ; 0x004: T=0 NUMB=0x0kfbh.block.obj: 2 ; 0x008: TYPE=0x0 NUMB=0x2kfbh.check: 2692121256 ; 0x00c: 0xa07682a8kfbh.fcn.base: 0 ; 0x010: 0x00000000kfbh.fcn.wrap: 0 ; 0x014: 0x00000000kfbh.spare1: 0 ; 0x018: 0x00000000kfbh.spare2: 0 ; 0x01c: 0x00000000kffdnd.bnode.incarn: 1 ; 0x000: A=1 NUMM=0x0kffdnd.bnode.frlist.number: 4294967295 ; 0x004: 0xffffffffkffdnd.bnode.frlist.incarn: 0 ; 0x008: A=0 NUMM=0x0kffdnd.overfl.number: 4294967295 ; 0x00c: 0xffffffffkffdnd.overfl.incarn: 0 ; 0x010: A=0 NUMM=0x0kffdnd.parent.number: 0 ; 0x014: 0x00000000kffdnd.parent.incarn: 1 ; 0x018: A=1 NUMM=0x0kffdnd.fstblk.number: 0 ; 0x01c: 0x00000000kffdnd.fstblk.incarn: 1 ; 0x020: A=1 NUMM=0x0kfddde[0].entry.incarn: 1 ; 0x024: A=1 NUMM=0x0kfddde[0].entry.hash: 0 ; 0x028: 0x00000000kfddde[0].entry.refer.number:4294967295 ; 0x02c: 0xffffffffkfddde[0].entry.refer.incarn: 0 ; 0x030: A=0 NUMM=0x0kfddde[0].dsknum: 0 ; 0x034: 0x0000kfddde[0].state: 2 ; 0x036: KFDSTA_NORMALkfddde[0].ub1spare: 0 ; 0x037: 0x00kfddde[0].dskname: TEST_0000 ; 0x038: length=9kfddde[0].fgname: TEST_0000 ; 0x058: length=9kfddde[0].crestmp.hi: 32991062 ; 0x078: HOUR=0x16 DAYS=0x1a MNTH=0x9 YEAR=0x7ddkfddde[0].crestmp.lo: 1601869824 ; 0x07c: USEC=0x0 MSEC=0x2a6 SECS=0x37 MINS=0x17kfddde[0].failstmp.hi: 0 ; 0x080: HOUR=0x0 DAYS=0x0 MNTH=0x0 YEAR=0x0kfddde[0].failstmp.lo: 0 ; 0x084: USEC=0x0 MSEC=0x0 SECS=0x0 MINS=0x0kfddde[0].timer: 0 ; 0x088: 0x00000000kfddde[0].size: 1024 ; 0x08c: 0x00000400
通过上面的值,我们可以确认绿色的值
[oracle@asm10g ~]$ ./test.sh 1 0 1000 /dev/mapper/asm4 KFBTYP_FREESPC |moreKFBTYP_FREESPC–blocks number–1–extent number—0—-block number—1——
可以确认红色部分
[oracle@asm10g ~]$ ./test.sh 1 0 1000 /dev/mapper/asm4 KFBTYP_ALLOCTBL |moreKFBTYP_ALLOCTBL–blocks number–2–extent number—0—-block number—2——KFBTYP_ALLOCTBL–blocks number–3–extent number—0—-block number—3——KFBTYP_ALLOCTBL–blocks number–4–extent number—0—-block number—4——
通过这个值 ,可以确认深蓝色部分
[oracle@asm10g ~]$ ./test.sh 1 0 1000 /dev/mapper/asm4 xptr.au |morexptr.au–blocks number–513–extent number—2—-block number—1——xptr.au–blocks number–514–extent number—2—-block number—2——xptr.au–blocks number–515–extent number—2—-block number—3——xptr.au–blocks number–516–extent number—2—-block number—4——
通过这个值 ,可以确认蓝色部分
[oracle@asm10g ~]$ kfed read /dev/mapper/asm4 aunum=1 blknum=0|grep copyCntkfdpHdrB.copyCnt: 1 ; 0x010: 0x01
通过这个值 ,可以确认紫色部分
[oracle@asm10g ~]$ kfed merge /dev/mapper/asm4 te=asm4.txt[oracle@asm10g ~]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.5.0 – Production on Thu Sep 26 23:04:30 2013Copyright (c) 1982, 2010, Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> alter diskgroup test mount2 ; Diskgroup altered. kfbh.endian: 1 ; 0x000: 0x01kfbh.hard: 130 ; 0x001: 0x82kfbh.type: 1 ; 0x002: KFBTYP_DISKHEADkfbh.datfmt: 1 ; 0x003: 0x01kfbh.block.blk: 0 ; 0x004: T=0 NUMB=0x0kfbh.block.obj: 2147483648 ; 0x008: TYPE=0x8 NUMB=0x1kfbh.check: 1084736906 ; 0x00c: 0x40a7c58akfbh.fcn.base: 0 ; 0x010: 0x00000000kfbh.fcn.wrap: 0 ; 0x014: 0x00000000kfbh.spare1: 0 ; 0x018: 0x00000000kfbh.spare2: 0 ; 0x01c: 0x00000000kfdhdb.driver.provstr: ORCLDISK ; 0x000: length=8kfdhdb.driver.reserved[0]: 0 ; 0x008: 0x00000000kfdhdb.driver.reserved[1]: 0 ; 0x00c: 0x00000000kfdhdb.driver.reserved[2]: 0 ; 0x010: 0x00000000kfdhdb.driver.reserved[3]: 0 ; 0x014: 0x00000000kfdhdb.driver.reserved[4]: 0 ; 0x018: 0x00000000kfdhdb.driver.reserved[5]: 0 ; 0x01c: 0x00000000kfdhdb.compat: 168820736 ; 0x020: 0x0a100000kfdhdb.dsknum: 0 ; 0x024: 0x0001kfdhdb.grptyp: 1 ; 0x026: KFDGTP_EXTERNALkfdhdb.hdrsts: 3 ; 0x027: KFDHDR_MEMBERkfdhdb.dskname: TEST_0000 ; 0x028: length=9kfdhdb.grpname: TEST ; 0x048: length=4kfdhdb.fgname: TEST_0000 ; 0x068: length=9kfdhdb.capname: ; 0x088: length=0kfdhdb.crestmp.hi: 32991062 ; 0x078: HOUR=0x16 DAYS=0x1a MNTH=0x9 YEAR=0x7ddkfdhdb.crestmp.lo: 1601869824 ; 0x07c: USEC=0x0 MSEC=0x2a6 SECS=0x37 MINS=0x17kfdhdb.mntstmp.hi: 32991062 ; 0x0b0: HOUR=0x15 DAYS=0x1a MNTH=0x9 YEAR=0x7ddkfdhdb.mntstmp.lo: 1601869820 ; 0x0b4: USEC=0x0 MSEC=0xde SECS=0x0 MINS=0x20kfdhdb.secsize: 512 ; 0x0b8: 0x0200kfdhdb.blksize: 4096 ; 0x0ba: 0x1000kfdhdb.ausize: 1048576 ; 0x0bc: 0x00100000kfdhdb.mfact: 113792 ; 0x0c0: 0x0001bc80kfdhdb.dsksize: 1024 ; 0x0c4: 0x00000400kfdhdb.pmcnt: 2 ; 0x0c8: 0x00000002kfdhdb.fstlocn: 1 ; 0x0cc: 0x00000000kfdhdb.altlocn: 2 ; 0x0d0: 0x00000002kfdhdb.f1b1locn: 2 ; 0x0d4: 0x00000000kfdhdb.redomirrors[0]: 0 ; 0x0d8: 0x0000kfdhdb.redomirrors[1]: 0 ; 0x0da: 0x0000kfdhdb.redomirrors[2]: 0 ; 0x0dc: 0x0000kfdhdb.redomirrors[3]: 0 ; 0x0de: 0x0000kfdhdb.dbcompat: 168820736 ; 0x0e0: 0x0a100000kfdhdb.grpstmp.hi: 32991062 ; 0x0e4: HOUR=0x16 DAYS=0x1a MNTH=0x9 YEAR=0x7ddkfdhdb.grpstmp.lo: 1601869819 ; 0x0e8: USEC=0x0 MSEC=0x21 SECS=0x37 MINS=0x1fkfdhdb.ub4spare[0]: 0 ; 0x0ec: 0x00000000kfdhdb.ub4spare[1]: 0 ; 0x0f0: 0x00000000kfdhdb.ub4spare[2]: 0 ; 0x0f4: 0x00000000kfdhdb.ub4spare[3]: 0 ; 0x0f8: 0x00000000kfdhdb.ub4spare[4]: 0 ; 0x0fc: 0x00000000kfdhdb.ub4spare[5]: 0 ; 0x100: 0x00000000kfdhdb.ub4spare[6]: 0 ; 0x104: 0x00000000kfdhdb.ub4spare[7]: 0 ; 0x108: 0x00000000kfdhdb.ub4spare[8]: 0 ; 0x10c: 0x00000000kfdhdb.ub4spare[9]: 0 ; 0x110: 0x00000000kfdhdb.ub4spare[10]: 0 ; 0x114: 0x00000000kfdhdb.ub4spare[11]: 0 ; 0x118: 0x00000000kfdhdb.ub4spare[12]: 0 ; 0x11c: 0x00000000kfdhdb.ub4spare[13]: 0 ; 0x120: 0x00000000kfdhdb.ub4spare[14]: 0 ; 0x124: 0x00000000kfdhdb.ub4spare[15]: 0 ; 0x128: 0x00000000kfdhdb.ub4spare[16]: 0 ; 0x12c: 0x00000000kfdhdb.ub4spare[17]: 0 ; 0x130: 0x00000000kfdhdb.ub4spare[18]: 0 ; 0x134: 0x00000000kfdhdb.ub4spare[19]: 0 ; 0x138: 0x00000000kfdhdb.ub4spare[20]: 0 ; 0x13c: 0x00000000kfdhdb.ub4spare[21]: 0 ; 0x140: 0x00000000kfdhdb.ub4spare[22]: 0 ; 0x144: 0x00000000kfdhdb.ub4spare[23]: 0 ; 0x148: 0x00000000kfdhdb.ub4spare[24]: 0 ; 0x14c: 0x00000000kfdhdb.ub4spare[25]: 0 ; 0x150: 0x00000000kfdhdb.ub4spare[26]: 0 ; 0x154: 0x00000000kfdhdb.ub4spare[27]: 0 ; 0x158: 0x00000000kfdhdb.ub4spare[28]: 0 ; 0x15c: 0x00000000kfdhdb.ub4spare[29]: 0 ; 0x160: 0x00000000kfdhdb.ub4spare[30]: 0 ; 0x164: 0x00000000kfdhdb.ub4spare[31]: 0 ; 0x168: 0x00000000kfdhdb.ub4spare[32]: 0 ; 0x16c: 0x00000000kfdhdb.ub4spare[33]: 0 ; 0x170: 0x00000000kfdhdb.ub4spare[34]: 0 ; 0x174: 0x00000000kfdhdb.ub4spare[35]: 0 ; 0x178: 0x00000000kfdhdb.ub4spare[36]: 0 ; 0x17c: 0x00000000kfdhdb.ub4spare[37]: 0 ; 0x180: 0x00000000kfdhdb.ub4spare[38]: 0 ; 0x184: 0x00000000kfdhdb.ub4spare[39]: 0 ; 0x188: 0x00000000kfdhdb.ub4spare[40]: 0 ; 0x18c: 0x00000000kfdhdb.ub4spare[41]: 0 ; 0x190: 0x00000000kfdhdb.ub4spare[42]: 0 ; 0x194: 0x00000000kfdhdb.ub4spare[43]: 0 ; 0x198: 0x00000000kfdhdb.ub4spare[44]: 0 ; 0x19c: 0x00000000kfdhdb.ub4spare[45]: 0 ; 0x1a0: 0x00000000kfdhdb.ub4spare[46]: 0 ; 0x1a4: 0x00000000kfdhdb.ub4spare[47]: 0 ; 0x1a8: 0x00000000kfdhdb.ub4spare[48]: 0 ; 0x1ac: 0x00000000kfdhdb.ub4spare[49]: 0 ; 0x1b0: 0x00000000kfdhdb.ub4spare[50]: 0 ; 0x1b4: 0x00000000kfdhdb.ub4spare[51]: 0 ; 0x1b8: 0x00000000kfdhdb.ub4spare[52]: 0 ; 0x1bc: 0x00000000kfdhdb.ub4spare[53]: 0 ; 0x1c0: 0x00000000kfdhdb.ub4spare[54]: 0 ; 0x1c4: 0x00000000kfdhdb.ub4spare[55]: 0 ; 0x1c8: 0x00000000kfdhdb.ub4spare[56]: 0 ; 0x1cc: 0x00000000kfdhdb.ub4spare[57]: 0 ; 0x1d0: 0x00000000kfdhdb.acdb.aba.seq: 0 ; 0x1d4: 0x00000000kfdhdb.acdb.aba.blk: 0 ; 0x1d8: 0x00000000kfdhdb.acdb.ents: 0 ; 0x1dc: 0x0000kfdhdb.acdb.ub2spare: 0 ; 0x1de: 0x0000
------------------作者介绍-----------------------
姓名:黄廷忠
现就职:Oracle中国高级服务团队
曾就职:OceanBase、云和恩墨、东方龙马等
电话、微信、QQ:18081072613
个人博客: (http://www.htz.pw)
CSDN地址: (https://blog.csdn.net/wwwhtzpw)
博客园地址: (https://www.cnblogs.com/www-htz-pw)