Oracle技术之ASM DISK HEADER 备份与恢复
最近遇到几次ASM DATA HEADER出问题导致DISK GROUP 不能正常的MOUNT,是的数据库不能正常工作,从来带来了无穷的麻烦,这个时候心想,如果我做了ASM DATA HEADER的备份该多好啊,可惜世上没有后悔药,建议大家检查下自己的ASM库,ASM HEADER是否已经做了备份,如果没有请及时处理下.这里试验提供了dd和kfed备份和恢复ASM HEADER查询ASM相关信息
SQL> select group_number,name,state,total_mb,free_mb from v$asm_diskgroup;
GROUP_NUMBER NAME STATE TOTAL_MB FREE_MB
------------ ------------------------------ ---------- ---------- ----------
1 DATA MOUNTED 2046 1314
2 XIFENFEI MOUNTED 6141 4378
SQL> select group_number,DISK_NUMBER,PATH,STATE from v$asm_disk;
GROUP_NUMBER DISK_NUMBER PATH STATE
------------ ----------- ------------------------------ ----------------
1 1 /dev/oracleasm/disks/VOL2 NORMAL
1 0 /dev/oracleasm/disks/VOL1 NORMAL
2 1 /dev/oracleasm/disks/VOL4 NORMAL
2 0 /dev/oracleasm/disks/VOL3 NORMAL
找出ASM DISK对应磁盘分区
$ /etc/init.d/oracleasmquerydisk -d VOL1
Disk "VOL1" is a valid ASM disk on device
$ ll /dev |grep 8|grep 33
brw-r----- 1 root disk 8,33 Apr 17 11:37 sdc1
$ /etc/init.d/oracleasmquerydisk -d VOL2
Disk "VOL2" is a valid ASM disk on device
$ ll /dev |grep 8|grep 34
brw-r----- 1 root disk 8,34 Apr 17 11:37 sdc2
$ /etc/init.d/oracleasmquerydisk -d VOL3
Disk "VOL3" is a valid ASM disk on device
$ ll /dev |grep 8,|grep 17
brw-r----- 1 root disk 8,17 Apr 17 11:37 sdb1
$ /etc/init.d/oracleasmquerydisk -d VOL4
Disk "VOL4" is a valid ASM disk on device
$ ll /dev |grep 8,|grep 18
brw-r----- 1 root disk 8,18 Apr 17 11:37 sdb2
备份ASM HEADER信息(备份XIFENFEI磁盘组)
--dd方式备份
# dd if=/dev/sdb1 of=vol3header.dd bs=4096 count=1
1+0 records in
1+0 records out
4096 bytes (4.1 kB) copied, 0.000143581 seconds, 28.5 MB/s
# dd if=/dev/sdb2 of=vol4header.dd bs=4096 count=1
1+0 records in
1+0 records out
4096 bytes (4.1 kB) copied, 0.000147727 seconds, 27.7 MB/s
--kfed方式备份
$ kfed read /dev/oracleasm/disks/VOL3 text=vol3header.txt
$ more vol3header.txt
kfbh.endian: 1 ; 0x000: 0x01
kfbh.hard: 130 ; 0x001: 0x82
kfbh.type: 1 ; 0x002: KFBTYP_DISKHEAD
kfbh.datfmt: 1 ; 0x003: 0x01
kfbh.block.blk: 0 ; 0x004: blk=0
kfbh.block.obj: 2147483648 ; 0x008: disk=0
kfbh.check: 198826195 ; 0x00c: 0x0bd9d8d3
kfbh.fcn.base: 0 ; 0x010: 0x00000000
kfbh.fcn.wrap: 0 ; 0x014: 0x00000000
kfbh.spare1: 0 ; 0x018: 0x00000000
kfbh.spare2: 0 ; 0x01c: 0x00000000
kfdhdb.driver.provstr: ORCLDISKVOL3 ; 0x000: length=12
kfdhdb.driver.reserved: 860639062 ; 0x008: 0x334c4f56
kfdhdb.driver.reserved: 0 ; 0x00c: 0x00000000
kfdhdb.driver.reserved: 0 ; 0x010: 0x00000000
kfdhdb.driver.reserved: 0 ; 0x014: 0x00000000
kfdhdb.driver.reserved: 0 ; 0x018: 0x00000000
kfdhdb.driver.reserved: 0 ; 0x01c: 0x00000000
kfdhdb.compat: 186646528 ; 0x020: 0x0b200000
kfdhdb.dsknum: 0 ; 0x024: 0x0000
kfdhdb.grptyp: 1 ; 0x026: KFDGTP_EXTERNAL
kfdhdb.hdrsts: 3 ; 0x027: KFDHDR_MEMBER
kfdhdb.dskname: XIFENFEI_0000 ; 0x028: length=13
kfdhdb.grpname: XIFENFEI ; 0x048: length=8
kfdhdb.fgname: XIFENFEI_0000 ; 0x068: length=13
kfdhdb.capname: ; 0x088: length=0
kfdhdb.crestmp.hi: 32967790 ; 0x0a8: HOUR=0xe DAYS=0x3 MNTH=0x3 YEAR=0x7dc
kfdhdb.crestmp.lo: 2015933440 ; 0x0ac: USEC=0x0 MSEC=0x22d SECS=0x2 MINS=0x1e
kfdhdb.mntstmp.hi: 32969259 ; 0x0b0: HOUR=0xb DAYS=0x11 MNTH=0x4 YEAR=0x7dc
kfdhdb.mntstmp.lo: 2707277824 ; 0x0b4: USEC=0x0 MSEC=0x372 SECS=0x15 MINS=0x28
kfdhdb.secsize: 512 ; 0x0b8: 0x0200
kfdhdb.blksize: 4096 ; 0x0ba: 0x1000
kfdhdb.ausize: 1048576 ; 0x0bc: 0x00100000
kfdhdb.mfact: 113792 ; 0x0c0: 0x0001bc80
kfdhdb.dsksize: 2353 ; 0x0c4: 0x00000931
kfdhdb.pmcnt: 2 ; 0x0c8: 0x00000002
kfdhdb.fstlocn: 1 ; 0x0cc: 0x00000001
kfdhdb.altlocn: 2 ; 0x0d0: 0x00000002
kfdhdb.f1b1locn: 2 ; 0x0d4: 0x00000002
kfdhdb.redomirrors: 0 ; 0x0d8: 0x0000
kfdhdb.redomirrors: 0 ; 0x0da: 0x0000
kfdhdb.redomirrors: 0 ; 0x0dc: 0x0000
kfdhdb.redomirrors: 0 ; 0x0de: 0x0000
kfdhdb.dbcompat: 168820736 ; 0x0e0: 0x0a100000
kfdhdb.grpstmp.hi: 32967790 ; 0x0e4: HOUR=0xe DAYS=0x3 MNTH=0x3 YEAR=0x7dc
kfdhdb.grpstmp.lo: 2015746048 ; 0x0e8: USEC=0x0 MSEC=0x176 SECS=0x2 MINS=0x1e
kfdhdb.vfstart: 0 ; 0x0ec: 0x00000000
kfdhdb.vfend: 0 ; 0x0f0: 0x00000000
kfdhdb.spfile: 0 ; 0x0f4: 0x00000000
kfdhdb.spfflg: 0 ; 0x0f8: 0x00000000
kfdhdb.ub4spare: 0 ; 0x0fc: 0x00000000
kfdhdb.ub4spare: 0 ; 0x100: 0x00000000
kfdhdb.ub4spare: 0 ; 0x104: 0x00000000
kfdhdb.ub4spare: 0 ; 0x108: 0x00000000
kfdhdb.ub4spare: 0 ; 0x10c: 0x00000000
kfdhdb.ub4spare: 0 ; 0x110: 0x00000000
kfdhdb.ub4spare: 0 ; 0x114: 0x00000000
kfdhdb.ub4spare: 0 ; 0x118: 0x00000000
kfdhdb.ub4spare: 0 ; 0x11c: 0x00000000
kfdhdb.ub4spare: 0 ; 0x120: 0x00000000
kfdhdb.ub4spare: 0 ; 0x124: 0x00000000
kfdhdb.ub4spare: 0 ; 0x128: 0x00000000
kfdhdb.ub4spare: 0 ; 0x12c: 0x00000000
kfdhdb.ub4spare: 0 ; 0x130: 0x00000000
kfdhdb.ub4spare: 0 ; 0x134: 0x00000000
kfdhdb.ub4spare: 0 ; 0x138: 0x00000000
kfdhdb.ub4spare: 0 ; 0x13c: 0x00000000
kfdhdb.ub4spare: 0 ; 0x140: 0x00000000
kfdhdb.ub4spare: 0 ; 0x144: 0x00000000
kfdhdb.ub4spare: 0 ; 0x148: 0x00000000
kfdhdb.ub4spare: 0 ; 0x14c: 0x00000000
kfdhdb.ub4spare: 0 ; 0x150: 0x00000000
kfdhdb.ub4spare: 0 ; 0x154: 0x00000000
kfdhdb.ub4spare: 0 ; 0x158: 0x00000000
kfdhdb.ub4spare: 0 ; 0x15c: 0x00000000
kfdhdb.ub4spare: 0 ; 0x160: 0x00000000
kfdhdb.ub4spare: 0 ; 0x164: 0x00000000
kfdhdb.ub4spare: 0 ; 0x168: 0x00000000
kfdhdb.ub4spare: 0 ; 0x16c: 0x00000000
kfdhdb.ub4spare: 0 ; 0x170: 0x00000000
kfdhdb.ub4spare: 0 ; 0x174: 0x00000000
kfdhdb.ub4spare: 0 ; 0x178: 0x00000000
kfdhdb.ub4spare: 0 ; 0x17c: 0x00000000
kfdhdb.ub4spare: 0 ; 0x180: 0x00000000
kfdhdb.ub4spare: 0 ; 0x184: 0x00000000
kfdhdb.ub4spare: 0 ; 0x188: 0x00000000
kfdhdb.ub4spare: 0 ; 0x18c: 0x00000000
kfdhdb.ub4spare: 0 ; 0x190: 0x00000000
kfdhdb.ub4spare: 0 ; 0x194: 0x00000000
kfdhdb.ub4spare: 0 ; 0x198: 0x00000000
kfdhdb.ub4spare: 0 ; 0x19c: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1a0: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1a4: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1a8: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1ac: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1b0: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1b4: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1b8: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1bc: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1c0: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1c4: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1c8: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1cc: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1d0: 0x00000000
kfdhdb.acdb.aba.seq: 0 ; 0x1d4: 0x00000000
kfdhdb.acdb.aba.blk: 0 ; 0x1d8: 0x00000000
kfdhdb.acdb.ents: 0 ; 0x1dc: 0x0000
kfdhdb.acdb.ub2spare: 0 ; 0x1de: 0x0000
$ kfed read /dev/oracleasm/disks/VOL4 text=vol4header.txt
破坏VOL3 ASM磁盘
# dd if=/dev/zero of=/dev/sdb1 bs=4096 count=1
1+0 records in
1+0 records out
4096 bytes (4.1 kB) copied, 0.00165264 seconds, 2.5 MB/s
$ kfed read /dev/oracleasm/disks/VOL3
kfbh.endian: 0 ; 0x000: 0x00
kfbh.hard: 0 ; 0x001: 0x00
kfbh.type: 0 ; 0x002: KFBTYP_INVALID
kfbh.datfmt: 0 ; 0x003: 0x00
kfbh.block.blk: 0 ; 0x004: blk=0
kfbh.block.obj: 0 ; 0x008: file=0
kfbh.check: 0 ; 0x00c: 0x00000000
kfbh.fcn.base: 0 ; 0x010: 0x00000000
kfbh.fcn.wrap: 0 ; 0x014: 0x00000000
kfbh.spare1: 0 ; 0x018: 0x00000000
kfbh.spare2: 0 ; 0x01c: 0x00000000
B4BFE200 00000000 00000000 00000000 00000000[................]
Repeat 255 times
KFED-00322: Invalid content encountered during block traversal: []
启动ASM
$ sqlplus / as sysoper
SQL*Plus:> Copyright (c) 1982, 2011, Oracle.All rights reserved.
Connected to an> SQL> startup
ASM instance started
ORA-15032: not all> ORA-15017: diskgroup "XIFENFEI" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup
"XIFENFEI"
恢复ASM DATE HEADER
--dd 恢复
# dd if=vol3header.dd of=/dev/sdb1 bs=4096 count=1
1+0 records in
1+0 records out
4096 bytes (4.1 kB) copied, 0.00197913 seconds, 2.1 MB/s
--kfed 恢复
$ kfed merge /dev/oracleasm/disks/VOL3 text=vol3header.txt
MOUNT DISKGROUP
SQL>>
Diskgroup> 最近遇到几次ASM DATA HEADER出问题导致DISK GROUP 不能正常的MOUNT,是的数据库不能正常工作,从来带来了无穷的麻烦,这个时候心想,如果我做了ASM DATA HEADER的备份该多好啊,可惜世上没有后悔药,建议大家检查下自己的ASM库,ASM HEADER是否已经做了备份,如果没有请及时处理下.这里试验提供了dd和kfed备份和恢复ASM HEADER
查询ASM相关信息
SQL> select group_number,name,state,total_mb,free_mb from v$asm_diskgroup;
GROUP_NUMBER NAME STATE TOTAL_MB FREE_MB
------------ ------------------------------ ---------- ---------- ----------
1 DATA MOUNTED 2046 1314
2 XIFENFEI MOUNTED 6141 4378
SQL> select group_number,DISK_NUMBER,PATH,STATE from v$asm_disk;
GROUP_NUMBER DISK_NUMBER PATH STATE
------------ ----------- ------------------------------ ----------------
1 1 /dev/oracleasm/disks/VOL2 NORMAL
1 0 /dev/oracleasm/disks/VOL1 NORMAL
2 1 /dev/oracleasm/disks/VOL4 NORMAL
2 0 /dev/oracleasm/disks/VOL3 NORMAL
找出ASM DISK对应磁盘分区
$ /etc/init.d/oracleasmquerydisk -d VOL1
Disk "VOL1" is a valid ASM disk on device
$ ll /dev |grep 8|grep 33
brw-r----- 1 root disk 8,33 Apr 17 11:37 sdc1
$ /etc/init.d/oracleasmquerydisk -d VOL2
Disk "VOL2" is a valid ASM disk on device
$ ll /dev |grep 8|grep 34
brw-r----- 1 root disk 8,34 Apr 17 11:37 sdc2
$ /etc/init.d/oracleasmquerydisk -d VOL3
Disk "VOL3" is a valid ASM disk on device
$ ll /dev |grep 8,|grep 17
brw-r----- 1 root disk 8,17 Apr 17 11:37 sdb1
$ /etc/init.d/oracleasmquerydisk -d VOL4
Disk "VOL4" is a valid ASM disk on device
$ ll /dev |grep 8,|grep 18
brw-r----- 1 root disk 8,18 Apr 17 11:37 sdb2
备份ASM HEADER信息(备份XIFENFEI磁盘组)
--dd方式备份
# dd if=/dev/sdb1 of=vol3header.dd bs=4096 count=1
1+0 records in
1+0 records out
4096 bytes (4.1 kB) copied, 0.000143581 seconds, 28.5 MB/s
# dd if=/dev/sdb2 of=vol4header.dd bs=4096 count=1
1+0 records in
1+0 records out
4096 bytes (4.1 kB) copied, 0.000147727 seconds, 27.7 MB/s
--kfed方式备份
$ kfed read /dev/oracleasm/disks/VOL3 text=vol3header.txt
$ more vol3header.txt
kfbh.endian: 1 ; 0x000: 0x01
kfbh.hard: 130 ; 0x001: 0x82
kfbh.type: 1 ; 0x002: KFBTYP_DISKHEAD
kfbh.datfmt: 1 ; 0x003: 0x01
kfbh.block.blk: 0 ; 0x004: blk=0
kfbh.block.obj: 2147483648 ; 0x008: disk=0
kfbh.check: 198826195 ; 0x00c: 0x0bd9d8d3
kfbh.fcn.base: 0 ; 0x010: 0x00000000
kfbh.fcn.wrap: 0 ; 0x014: 0x00000000
kfbh.spare1: 0 ; 0x018: 0x00000000
kfbh.spare2: 0 ; 0x01c: 0x00000000
kfdhdb.driver.provstr: ORCLDISKVOL3 ; 0x000: length=12
kfdhdb.driver.reserved: 860639062 ; 0x008: 0x334c4f56
kfdhdb.driver.reserved: 0 ; 0x00c: 0x00000000
kfdhdb.driver.reserved: 0 ; 0x010: 0x00000000
kfdhdb.driver.reserved: 0 ; 0x014: 0x00000000
kfdhdb.driver.reserved: 0 ; 0x018: 0x00000000
kfdhdb.driver.reserved: 0 ; 0x01c: 0x00000000
kfdhdb.compat: 186646528 ; 0x020: 0x0b200000
kfdhdb.dsknum: 0 ; 0x024: 0x0000
kfdhdb.grptyp: 1 ; 0x026: KFDGTP_EXTERNAL
kfdhdb.hdrsts: 3 ; 0x027: KFDHDR_MEMBER
kfdhdb.dskname: XIFENFEI_0000 ; 0x028: length=13
kfdhdb.grpname: XIFENFEI ; 0x048: length=8
kfdhdb.fgname: XIFENFEI_0000 ; 0x068: length=13
kfdhdb.capname: ; 0x088: length=0
kfdhdb.crestmp.hi: 32967790 ; 0x0a8: HOUR=0xe DAYS=0x3 MNTH=0x3 YEAR=0x7dc
kfdhdb.crestmp.lo: 2015933440 ; 0x0ac: USEC=0x0 MSEC=0x22d SECS=0x2 MINS=0x1e
kfdhdb.mntstmp.hi: 32969259 ; 0x0b0: HOUR=0xb DAYS=0x11 MNTH=0x4 YEAR=0x7dc
kfdhdb.mntstmp.lo: 2707277824 ; 0x0b4: USEC=0x0 MSEC=0x372 SECS=0x15 MINS=0x28
kfdhdb.secsize: 512 ; 0x0b8: 0x0200
kfdhdb.blksize: 4096 ; 0x0ba: 0x1000
kfdhdb.ausize: 1048576 ; 0x0bc: 0x00100000
kfdhdb.mfact: 113792 ; 0x0c0: 0x0001bc80
kfdhdb.dsksize: 2353 ; 0x0c4: 0x00000931
kfdhdb.pmcnt: 2 ; 0x0c8: 0x00000002
kfdhdb.fstlocn: 1 ; 0x0cc: 0x00000001
kfdhdb.altlocn: 2 ; 0x0d0: 0x00000002
kfdhdb.f1b1locn: 2 ; 0x0d4: 0x00000002
kfdhdb.redomirrors: 0 ; 0x0d8: 0x0000
kfdhdb.redomirrors: 0 ; 0x0da: 0x0000
kfdhdb.redomirrors: 0 ; 0x0dc: 0x0000
kfdhdb.redomirrors: 0 ; 0x0de: 0x0000
kfdhdb.dbcompat: 168820736 ; 0x0e0: 0x0a100000
kfdhdb.grpstmp.hi: 32967790 ; 0x0e4: HOUR=0xe DAYS=0x3 MNTH=0x3 YEAR=0x7dc
kfdhdb.grpstmp.lo: 2015746048 ; 0x0e8: USEC=0x0 MSEC=0x176 SECS=0x2 MINS=0x1e
kfdhdb.vfstart: 0 ; 0x0ec: 0x00000000
kfdhdb.vfend: 0 ; 0x0f0: 0x00000000
kfdhdb.spfile: 0 ; 0x0f4: 0x00000000
kfdhdb.spfflg: 0 ; 0x0f8: 0x00000000
kfdhdb.ub4spare: 0 ; 0x0fc: 0x00000000
kfdhdb.ub4spare: 0 ; 0x100: 0x00000000
kfdhdb.ub4spare: 0 ; 0x104: 0x00000000
kfdhdb.ub4spare: 0 ; 0x108: 0x00000000
kfdhdb.ub4spare: 0 ; 0x10c: 0x00000000
kfdhdb.ub4spare: 0 ; 0x110: 0x00000000
kfdhdb.ub4spare: 0 ; 0x114: 0x00000000
kfdhdb.ub4spare: 0 ; 0x118: 0x00000000
kfdhdb.ub4spare: 0 ; 0x11c: 0x00000000
kfdhdb.ub4spare: 0 ; 0x120: 0x00000000
kfdhdb.ub4spare: 0 ; 0x124: 0x00000000
kfdhdb.ub4spare: 0 ; 0x128: 0x00000000
kfdhdb.ub4spare: 0 ; 0x12c: 0x00000000
kfdhdb.ub4spare: 0 ; 0x130: 0x00000000
kfdhdb.ub4spare: 0 ; 0x134: 0x00000000
kfdhdb.ub4spare: 0 ; 0x138: 0x00000000
kfdhdb.ub4spare: 0 ; 0x13c: 0x00000000
kfdhdb.ub4spare: 0 ; 0x140: 0x00000000
kfdhdb.ub4spare: 0 ; 0x144: 0x00000000
kfdhdb.ub4spare: 0 ; 0x148: 0x00000000
kfdhdb.ub4spare: 0 ; 0x14c: 0x00000000
kfdhdb.ub4spare: 0 ; 0x150: 0x00000000
kfdhdb.ub4spare: 0 ; 0x154: 0x00000000
kfdhdb.ub4spare: 0 ; 0x158: 0x00000000
kfdhdb.ub4spare: 0 ; 0x15c: 0x00000000
kfdhdb.ub4spare: 0 ; 0x160: 0x00000000
kfdhdb.ub4spare: 0 ; 0x164: 0x00000000
kfdhdb.ub4spare: 0 ; 0x168: 0x00000000
kfdhdb.ub4spare: 0 ; 0x16c: 0x00000000
kfdhdb.ub4spare: 0 ; 0x170: 0x00000000
kfdhdb.ub4spare: 0 ; 0x174: 0x00000000
kfdhdb.ub4spare: 0 ; 0x178: 0x00000000
kfdhdb.ub4spare: 0 ; 0x17c: 0x00000000
kfdhdb.ub4spare: 0 ; 0x180: 0x00000000
kfdhdb.ub4spare: 0 ; 0x184: 0x00000000
kfdhdb.ub4spare: 0 ; 0x188: 0x00000000
kfdhdb.ub4spare: 0 ; 0x18c: 0x00000000
kfdhdb.ub4spare: 0 ; 0x190: 0x00000000
kfdhdb.ub4spare: 0 ; 0x194: 0x00000000
kfdhdb.ub4spare: 0 ; 0x198: 0x00000000
kfdhdb.ub4spare: 0 ; 0x19c: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1a0: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1a4: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1a8: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1ac: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1b0: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1b4: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1b8: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1bc: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1c0: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1c4: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1c8: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1cc: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1d0: 0x00000000
kfdhdb.acdb.aba.seq: 0 ; 0x1d4: 0x00000000
kfdhdb.acdb.aba.blk: 0 ; 0x1d8: 0x00000000
kfdhdb.acdb.ents: 0 ; 0x1dc: 0x0000
kfdhdb.acdb.ub2spare: 0 ; 0x1de: 0x0000
$ kfed read /dev/oracleasm/disks/VOL4 text=vol4header.txt
破坏VOL3 ASM磁盘
# dd if=/dev/zero of=/dev/sdb1 bs=4096 count=1
1+0 records in
1+0 records out
4096 bytes (4.1 kB) copied, 0.00165264 seconds, 2.5 MB/s
$ kfed read /dev/oracleasm/disks/VOL3
kfbh.endian: 0 ; 0x000: 0x00
kfbh.hard: 0 ; 0x001: 0x00
kfbh.type: 0 ; 0x002: KFBTYP_INVALID
kfbh.datfmt: 0 ; 0x003: 0x00
kfbh.block.blk: 0 ; 0x004: blk=0
kfbh.block.obj: 0 ; 0x008: file=0
kfbh.check: 0 ; 0x00c: 0x00000000
kfbh.fcn.base: 0 ; 0x010: 0x00000000
kfbh.fcn.wrap: 0 ; 0x014: 0x00000000
kfbh.spare1: 0 ; 0x018: 0x00000000
kfbh.spare2: 0 ; 0x01c: 0x00000000
B4BFE200 00000000 00000000 00000000 00000000[................]
Repeat 255 times
KFED-00322: Invalid content encountered during block traversal: []
启动ASM
$ sqlplus / as sysoper
SQL*Plus:> Copyright (c) 1982, 2011, Oracle.All rights reserved.
Connected to an> SQL> startup
ASM instance started
ORA-15032: not all> ORA-15017: diskgroup "XIFENFEI" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup
"XIFENFEI"
恢复ASM DATE HEADER
--dd 恢复
# dd if=vol3header.dd of=/dev/sdb1 bs=4096 count=1
1+0 records in
1+0 records out
4096 bytes (4.1 kB) copied, 0.00197913 seconds, 2.1 MB/s
--kfed 恢复
$ kfed merge /dev/oracleasm/disks/VOL3 text=vol3header.txt
MOUNT DISKGROUP
SQL>>
Diskgroup> 最近遇到几次ASM DATA HEADER出问题导致DISK GROUP 不能正常的MOUNT,是的数据库不能正常工作,从来带来了无穷的麻烦,这个时候心想,如果我做了ASM DATA HEADER的备份该多好啊,可惜世上没有后悔药,建议大家检查下自己的ASM库,ASM HEADER是否已经做了备份,如果没有请及时处理下.这里试验提供了dd和kfed备份和恢复ASM HEADER
查询ASM相关信息
SQL> select group_number,name,state,total_mb,free_mb from v$asm_diskgroup;
GROUP_NUMBER NAME STATE TOTAL_MB FREE_MB
------------ ------------------------------ ---------- ---------- ----------
1 DATA MOUNTED 2046 1314
2 XIFENFEI MOUNTED 6141 4378
SQL> select group_number,DISK_NUMBER,PATH,STATE from v$asm_disk;
GROUP_NUMBER DISK_NUMBER PATH STATE
------------ ----------- ------------------------------ ----------------
1 1 /dev/oracleasm/disks/VOL2 NORMAL
1 0 /dev/oracleasm/disks/VOL1 NORMAL
2 1 /dev/oracleasm/disks/VOL4 NORMAL
2 0 /dev/oracleasm/disks/VOL3 NORMAL
找出ASM DISK对应磁盘分区
$ /etc/init.d/oracleasmquerydisk -d VOL1
Disk "VOL1" is a valid ASM disk on device
$ ll /dev |grep 8|grep 33
brw-r----- 1 root disk 8,33 Apr 17 11:37 sdc1
$ /etc/init.d/oracleasmquerydisk -d VOL2
Disk "VOL2" is a valid ASM disk on device
$ ll /dev |grep 8|grep 34
brw-r----- 1 root disk 8,34 Apr 17 11:37 sdc2
$ /etc/init.d/oracleasmquerydisk -d VOL3
Disk "VOL3" is a valid ASM disk on device
$ ll /dev |grep 8,|grep 17
brw-r----- 1 root disk 8,17 Apr 17 11:37 sdb1
$ /etc/init.d/oracleasmquerydisk -d VOL4
Disk "VOL4" is a valid ASM disk on device
$ ll /dev |grep 8,|grep 18
brw-r----- 1 root disk 8,18 Apr 17 11:37 sdb2
备份ASM HEADER信息(备份XIFENFEI磁盘组)
--dd方式备份
# dd if=/dev/sdb1 of=vol3header.dd bs=4096 count=1
1+0 records in
1+0 records out
4096 bytes (4.1 kB) copied, 0.000143581 seconds, 28.5 MB/s
# dd if=/dev/sdb2 of=vol4header.dd bs=4096 count=1
1+0 records in
1+0 records out
4096 bytes (4.1 kB) copied, 0.000147727 seconds, 27.7 MB/s
--kfed方式备份
$ kfed read /dev/oracleasm/disks/VOL3 text=vol3header.txt
$ more vol3header.txt
kfbh.endian: 1 ; 0x000: 0x01
kfbh.hard: 130 ; 0x001: 0x82
kfbh.type: 1 ; 0x002: KFBTYP_DISKHEAD
kfbh.datfmt: 1 ; 0x003: 0x01
kfbh.block.blk: 0 ; 0x004: blk=0
kfbh.block.obj: 2147483648 ; 0x008: disk=0
kfbh.check: 198826195 ; 0x00c: 0x0bd9d8d3
kfbh.fcn.base: 0 ; 0x010: 0x00000000
kfbh.fcn.wrap: 0 ; 0x014: 0x00000000
kfbh.spare1: 0 ; 0x018: 0x00000000
kfbh.spare2: 0 ; 0x01c: 0x00000000
kfdhdb.driver.provstr: ORCLDISKVOL3 ; 0x000: length=12
kfdhdb.driver.reserved: 860639062 ; 0x008: 0x334c4f56
kfdhdb.driver.reserved: 0 ; 0x00c: 0x00000000
kfdhdb.driver.reserved: 0 ; 0x010: 0x00000000
kfdhdb.driver.reserved: 0 ; 0x014: 0x00000000
kfdhdb.driver.reserved: 0 ; 0x018: 0x00000000
kfdhdb.driver.reserved: 0 ; 0x01c: 0x00000000
kfdhdb.compat: 186646528 ; 0x020: 0x0b200000
kfdhdb.dsknum: 0 ; 0x024: 0x0000
kfdhdb.grptyp: 1 ; 0x026: KFDGTP_EXTERNAL
kfdhdb.hdrsts: 3 ; 0x027: KFDHDR_MEMBER
kfdhdb.dskname: XIFENFEI_0000 ; 0x028: length=13
kfdhdb.grpname: XIFENFEI ; 0x048: length=8
kfdhdb.fgname: XIFENFEI_0000 ; 0x068: length=13
kfdhdb.capname: ; 0x088: length=0
kfdhdb.crestmp.hi: 32967790 ; 0x0a8: HOUR=0xe DAYS=0x3 MNTH=0x3 YEAR=0x7dc
kfdhdb.crestmp.lo: 2015933440 ; 0x0ac: USEC=0x0 MSEC=0x22d SECS=0x2 MINS=0x1e
kfdhdb.mntstmp.hi: 32969259 ; 0x0b0: HOUR=0xb DAYS=0x11 MNTH=0x4 YEAR=0x7dc
kfdhdb.mntstmp.lo: 2707277824 ; 0x0b4: USEC=0x0 MSEC=0x372 SECS=0x15 MINS=0x28
kfdhdb.secsize: 512 ; 0x0b8: 0x0200
kfdhdb.blksize: 4096 ; 0x0ba: 0x1000
kfdhdb.ausize: 1048576 ; 0x0bc: 0x00100000
kfdhdb.mfact: 113792 ; 0x0c0: 0x0001bc80
kfdhdb.dsksize: 2353 ; 0x0c4: 0x00000931
kfdhdb.pmcnt: 2 ; 0x0c8: 0x00000002
kfdhdb.fstlocn: 1 ; 0x0cc: 0x00000001
kfdhdb.altlocn: 2 ; 0x0d0: 0x00000002
kfdhdb.f1b1locn: 2 ; 0x0d4: 0x00000002
kfdhdb.redomirrors: 0 ; 0x0d8: 0x0000
kfdhdb.redomirrors: 0 ; 0x0da: 0x0000
kfdhdb.redomirrors: 0 ; 0x0dc: 0x0000
kfdhdb.redomirrors: 0 ; 0x0de: 0x0000
kfdhdb.dbcompat: 168820736 ; 0x0e0: 0x0a100000
kfdhdb.grpstmp.hi: 32967790 ; 0x0e4: HOUR=0xe DAYS=0x3 MNTH=0x3 YEAR=0x7dc
kfdhdb.grpstmp.lo: 2015746048 ; 0x0e8: USEC=0x0 MSEC=0x176 SECS=0x2 MINS=0x1e
kfdhdb.vfstart: 0 ; 0x0ec: 0x00000000
kfdhdb.vfend: 0 ; 0x0f0: 0x00000000
kfdhdb.spfile: 0 ; 0x0f4: 0x00000000
kfdhdb.spfflg: 0 ; 0x0f8: 0x00000000
kfdhdb.ub4spare: 0 ; 0x0fc: 0x00000000
kfdhdb.ub4spare: 0 ; 0x100: 0x00000000
kfdhdb.ub4spare: 0 ; 0x104: 0x00000000
kfdhdb.ub4spare: 0 ; 0x108: 0x00000000
kfdhdb.ub4spare: 0 ; 0x10c: 0x00000000
kfdhdb.ub4spare: 0 ; 0x110: 0x00000000
kfdhdb.ub4spare: 0 ; 0x114: 0x00000000
kfdhdb.ub4spare: 0 ; 0x118: 0x00000000
kfdhdb.ub4spare: 0 ; 0x11c: 0x00000000
kfdhdb.ub4spare: 0 ; 0x120: 0x00000000
kfdhdb.ub4spare: 0 ; 0x124: 0x00000000
kfdhdb.ub4spare: 0 ; 0x128: 0x00000000
kfdhdb.ub4spare: 0 ; 0x12c: 0x00000000
kfdhdb.ub4spare: 0 ; 0x130: 0x00000000
kfdhdb.ub4spare: 0 ; 0x134: 0x00000000
kfdhdb.ub4spare: 0 ; 0x138: 0x00000000
kfdhdb.ub4spare: 0 ; 0x13c: 0x00000000
kfdhdb.ub4spare: 0 ; 0x140: 0x00000000
kfdhdb.ub4spare: 0 ; 0x144: 0x00000000
kfdhdb.ub4spare: 0 ; 0x148: 0x00000000
kfdhdb.ub4spare: 0 ; 0x14c: 0x00000000
kfdhdb.ub4spare: 0 ; 0x150: 0x00000000
kfdhdb.ub4spare: 0 ; 0x154: 0x00000000
kfdhdb.ub4spare: 0 ; 0x158: 0x00000000
kfdhdb.ub4spare: 0 ; 0x15c: 0x00000000
kfdhdb.ub4spare: 0 ; 0x160: 0x00000000
kfdhdb.ub4spare: 0 ; 0x164: 0x00000000
kfdhdb.ub4spare: 0 ; 0x168: 0x00000000
kfdhdb.ub4spare: 0 ; 0x16c: 0x00000000
kfdhdb.ub4spare: 0 ; 0x170: 0x00000000
kfdhdb.ub4spare: 0 ; 0x174: 0x00000000
kfdhdb.ub4spare: 0 ; 0x178: 0x00000000
kfdhdb.ub4spare: 0 ; 0x17c: 0x00000000
kfdhdb.ub4spare: 0 ; 0x180: 0x00000000
kfdhdb.ub4spare: 0 ; 0x184: 0x00000000
kfdhdb.ub4spare: 0 ; 0x188: 0x00000000
kfdhdb.ub4spare: 0 ; 0x18c: 0x00000000
kfdhdb.ub4spare: 0 ; 0x190: 0x00000000
kfdhdb.ub4spare: 0 ; 0x194: 0x00000000
kfdhdb.ub4spare: 0 ; 0x198: 0x00000000
kfdhdb.ub4spare: 0 ; 0x19c: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1a0: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1a4: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1a8: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1ac: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1b0: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1b4: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1b8: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1bc: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1c0: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1c4: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1c8: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1cc: 0x00000000
kfdhdb.ub4spare: 0 ; 0x1d0: 0x00000000
kfdhdb.acdb.aba.seq: 0 ; 0x1d4: 0x00000000
kfdhdb.acdb.aba.blk: 0 ; 0x1d8: 0x00000000
kfdhdb.acdb.ents: 0 ; 0x1dc: 0x0000
kfdhdb.acdb.ub2spare: 0 ; 0x1de: 0x0000
$ kfed read /dev/oracleasm/disks/VOL4 text=vol4header.txt
破坏VOL3 ASM磁盘
# dd if=/dev/zero of=/dev/sdb1 bs=4096 count=1
1+0 records in
1+0 records out
4096 bytes (4.1 kB) copied, 0.00165264 seconds, 2.5 MB/s
$ kfed read /dev/oracleasm/disks/VOL3
kfbh.endian: 0 ; 0x000: 0x00
kfbh.hard: 0 ; 0x001: 0x00
kfbh.type: 0 ; 0x002: KFBTYP_INVALID
kfbh.datfmt: 0 ; 0x003: 0x00
kfbh.block.blk: 0 ; 0x004: blk=0
kfbh.block.obj: 0 ; 0x008: file=0
kfbh.check: 0 ; 0x00c: 0x00000000
kfbh.fcn.base: 0 ; 0x010: 0x00000000
kfbh.fcn.wrap: 0 ; 0x014: 0x00000000
kfbh.spare1: 0 ; 0x018: 0x00000000
kfbh.spare2: 0 ; 0x01c: 0x00000000
B4BFE200 00000000 00000000 00000000 00000000[................]
Repeat 255 times
KFED-00322: Invalid content encountered during block traversal: []
启动ASM
$ sqlplus / as sysoper
SQL*Plus:> Copyright (c) 1982, 2011, Oracle.All rights reserved.
Connected to an> SQL> startup
ASM instance started
ORA-15032: not all> ORA-15017: diskgroup "XIFENFEI" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup
"XIFENFEI"
恢复ASM DATE HEADER
--dd 恢复
# dd if=vol3header.dd of=/dev/sdb1 bs=4096 count=1
1+0 records in
1+0 records out
4096 bytes (4.1 kB) copied, 0.00197913 seconds, 2.1 MB/s
--kfed 恢复
$ kfed merge /dev/oracleasm/disks/VOL3 text=vol3header.txt
MOUNT DISKGROUP
SQL>>
Diskgroup> oracle视频教程请关注:http://u.youku.com/user_video/id_UMzAzMjkxMjE2.html
页:
[1]