asm 添加disk时，ctrl+C导致diskgroup无法mount
本站文章除注明转载外，均为本站原创： 转载自love wife love life —Roger的Oracle/MySQL/PostgreSQL数据恢复博客
昨天系统割接时，一套10204 rac(asm)在添加disk时，ctrl+C中断后导致diskgroup无法mount，今天通过
vmware进行模拟了一下，然后给出解决方法，供大家参考。
—-如下来模拟添加asm disk时，中断操作导致asm 磁盘组无法mount的情况
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 |
SQL> show parameter disk NAME Type VALUE ------------------------------------ ------ ------------------------------ asm_diskgroups string DATA1 asm_diskstring string /dev/sdb, /dev/sde, /dev/sdd, /dev/sdc disk_asynch_io boolea TRUE n SQL> select path from v$asm_disk where group_number=1; PATH -------------------- /dev/sdd /dev/sdc SQL> alter diskgroup data1 add disk '/dev/sdb','/dev/sde' rebalance power 0; alter diskgroup data1 add disk '/dev/sdb','/dev/sde' rebalance power 0 * ERROR at line 1: ORA-01013: user requested cancel of current operation SQL> ----过几秒就ctrl+C |
果然此时数据库实例crash了，如下：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 |
[oracle@10gasm ~]$ ps -ef|grep pmon oracle 4176 1 0 03:47 ? 00:00:00 asm_pmon_+ASM oracle 27813 10014 0 08:30 pts/2 00:00:00 grep pmon [oracle@10gasm ~]$ cd /home/oracle/admin/test/bdump/ [oracle@10gasm bdump]$ tail -50 alert_test.log ASMB started with pid=16, OS id=27628 Starting background process RBAL RBAL started with pid=17, OS id=27632 Sat Dec 22 08:25:29 2012 SUCCESS: diskgroup DATA1 was mounted Sat Dec 22 08:25:34 2012 Setting recovery target incarnation to 2 Sat Dec 22 08:25:34 2012 Successful mount of redo thread 1, with mount id 2100867564 Sat Dec 22 08:25:34 2012 Database mounted in Exclusive Mode Completed: ALTER DATABASE MOUNT Sat Dec 22 08:25:34 2012 ALTER DATABASE OPEN Sat Dec 22 08:25:34 2012 Thread 1 opened at log sequence 2 Current log# 1 seq# 2 mem# 0: +DATA1/test/onlinelog/group_1.261.802678553 Successful open of redo thread 1 Sat Dec 22 08:25:34 2012 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Sat Dec 22 08:25:34 2012 SMON: enabling cache recovery Sat Dec 22 08:25:35 2012 Successfully onlined Undo Tablespace 1. Sat Dec 22 08:25:35 2012 SMON: enabling tx recovery Sat Dec 22 08:25:36 2012 Database Characterset is ZHS16GBK replication_dependency_tracking turned off (no async multimaster replication found) Starting background process QMNC QMNC started with pid=21, OS id=27657 Sat Dec 22 08:25:43 2012 Completed: ALTER DATABASE OPEN Sat Dec 22 08:29:37 2012 SUCCESS: diskgroup DATA1 was dismounted SUCCESS: diskgroup DATA1 was dismounted Sat Dec 22 08:29:39 2012 Errors in file /home/oracle/admin/test/bdump/test_ckpt_27611.trc: ORA-00206: error in writing (block 3, # blocks 1) of control file ORA-00202: control file: '+DATA1/test/controlfile/current.260.802678553' ORA-15078: ASM diskgroup was forcibly dismounted Sat Dec 22 08:29:39 2012 Errors in file /home/oracle/admin/test/bdump/test_ckpt_27611.trc: ORA-00221: error on write to control file ORA-00206: error in writing (block 3, # blocks 1) of control file ORA-00202: control file: '+DATA1/test/controlfile/current.260.802678553' ORA-15078: ASM diskgroup was forcibly dismounted Sat Dec 22 08:29:39 2012 CKPT: terminating instance due to error 221 Instance terminated by CKPT, pid = 27611 [oracle@10gasm bdump]$ |
如果尝试把这些disk删除或者重新添加，都会报错，类似如下：
|
1 2 3 4 5 6 7 |
SQL> alter diskgroup data1 drop disk '/dev/sdb','/dev/sde'; alter diskgroup data1 drop disk '/dev/sdb','/dev/sde' * ERROR at line 1: ORA-15032: not all alterations performed ORA-15054: disk "/DEV/SDE" does not exist in diskgroup "DATA1" ORA-15054: disk "/DEV/SDB" does not exist in diskgroup "DATA1" |
发现不行了，只能先把disk header清空掉，重启asm实例，尝试通过重建新的磁盘组然后drop的方式去删除：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 |
[oracle@10gasm ~]$ dd if=/dev/zero of=/dev/sdb bs=4096 count=1 1+0 records in 1+0 records out 4096 bytes (4.1 kB) copied, 0.000317152 seconds, 12.9 MB/s [oracle@10gasm ~]$ dd if=/dev/zero of=/dev/sde bs=4096 count=1 1+0 records in 1+0 records out 4096 bytes (4.1 kB) copied, 9.9421e-05 seconds, 41.2 MB/s SQL> shutdown immediate ASM diskgroups dismounted ASM instance shutdown SQL> startup ASM instance started Total System Global Area 83886080 bytes Fixed Size 1217836 bytes Variable Size 57502420 bytes ASM Cache 25165824 bytes ORA-15032: not all alterations performed ORA-15040: diskgroup is incomplete ORA-15042: ASM disk "3" is missing ORA-15042: ASM disk "2" is missing SQL> create diskgroup data2 external redundancy disk '/dev/sde','/dev/sdb'; Diskgroup created. SQL> drop diskgroup data2; Diskgroup dropped. SQL> SQL> alter diskgroup data mount; alter diskgroup data mount * ERROR at line 1: ORA-15032: not all alterations performed ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DATA" SQL> |
此时仍然无法mount，昨天操作骚扰熊哥，提到了pst和disk directory等信息，可以已经包含了这些disk，所以这里
我想到，既然如此，那么可以通过来修改这部分内容，然后成功将diskgroup mount，如下是的操作过程：
下面我们来看下asm的pst信息中是否包我们新加的2个disk：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 |
[oracle@10gasm ~]$ kfed read /dev/sdd aun=1 | more kfbh.endian: 1 ; 0x000: 0x01 kfbh.hard: 130 ; 0x001: 0x82 kfbh.type: 17 ; 0x002: KFBTYP_PST_META kfbh.datfmt: 1 ; 0x003: 0x01 kfbh.block.blk: 256 ; 0x004: T=0 NUMB=0x100 kfbh.block.obj: 2147483648 ; 0x008: TYPE=0x8 NUMB=0x0 kfbh.check: 4116287946 ; 0x00c: 0xf55991ca kfbh.fcn.base: 0 ; 0x010: 0x00000000 kfbh.fcn.wrap: 0 ; 0x014: 0x00000000 kfbh.spare1: 0 ; 0x018: 0x00000000 kfbh.spare2: 0 ; 0x01c: 0x00000000 kfdpHdrB.time.hi: 32977608 ; 0x000: HOUR=0x8 DAYS=0x16 MNTH=0xc YEAR=0x7dc kfdpHdrB.time.lo: 1975197696 ; 0x004: USEC=0x0 MSEC=0x2c8 SECS=0x1b MINS=0x1d kfdpHdrB.last: 3 ; 0x008: 0x00000003 kfdpHdrB.next: 3 ; 0x00c: 0x00000003 kfdpHdrB.copyCnt: 1 ; 0x010: 0x01 kfdpHdrB.ub1spare: 0 ; 0x011: 0x00 kfdpHdrB.ub2spare: 0 ; 0x012: 0x0000 kfdpHdrB.incarn: 0 ; 0x014: 0x00000000 kfdpHdrB.copy[0]: 0 ; 0x018: 0x0000 kfdpHdrB.copy[1]: 0 ; 0x01a: 0x0000 kfdpHdrB.copy[2]: 0 ; 0x01c: 0x0000 kfdpHdrB.copy[3]: 0 ; 0x01e: 0x0000 kfdpHdrB.copy[4]: 0 ; 0x020: 0x0000 kfdpHdrB.dtaSz: 4 ; 0x022: 0x0004 --包含4个disk,说明新加的2个已经包含在里面了 ub1[0]: 2 ; 0x024: 0x02 .....省略部分内容 |
下面再来看下asm disk directory信息：
|
1 2 3 4 5 6 7 8 9 10 |
[oracle@10gasm ~]$ kfed read /dev/sdc aun=2 blkn=0|grep dsknum kfddde[0].dsknum: 0 ; 0x034: 0x0000 kfddde[1].dsknum: 1 ; 0x1f4: 0x0001 kfddde[2].dsknum: 2 ; 0x3b4: 0x0002 kfddde[3].dsknum: 3 ; 0x574: 0x0003 kfddde[4].dsknum: 0 ; 0x734: 0x0000 kfddde[5].dsknum: 0 ; 0x8f4: 0x0000 kfddde[6].dsknum: 0 ; 0xab4: 0x0000 kfddde[7].dsknum: 0 ; 0xc74: 0x0000 [oracle@10gasm ~]$ |
仍然可以看到，disk directory中也有新加的disk的信息了。 这里我们要做的就是把多余的disk清理掉：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 |
kfed read /dev/sdc aun=2 blkn=0 > sdc.txt 将kfddde[2].dsknum,kfddde[3].dsknum 修改为0即可，另外还必须修改如下的地方，将多余的disk的信息全部改为0： 这里是diskgroup中正常的盘，/dev/sdc,起disknum为1，对于对于的盘disknum为2,3，下面信息你都行进行处理。 kfddde[1].entry.incarn: 1 ; 0x1e4: A=1 NUMM=0x0 kfddde[1].entry.hash: 1 ; 0x1e8: 0x00000001 kfddde[1].entry.refer.number:4294967295 ; 0x1ec: 0xffffffff kfddde[1].entry.refer.incarn: 0 ; 0x1f0: A=0 NUMM=0x0 kfddde[1].dsknum: 1 ; 0x1f4: 0x0001 kfddde[1].state: 2 ; 0x1f6: KFDSTA_NORMAL kfddde[1].ub1spare: 0 ; 0x1f7: 0x00 kfddde[1].dskname: DATA1_0001 ; 0x1f8: length=10 kfddde[1].fgname: DATA1_0001 ; 0x218: length=10 kfddde[1].crestmp.hi: 32977478 ; 0x238: HOUR=0x6 DAYS=0x12 MNTH=0xc YEAR=0x7dc kfddde[1].crestmp.lo: 2407340032 ; 0x23c: USEC=0x0 MSEC=0x346 SECS=0x37 MINS=0x23 kfddde[1].failstmp.hi: 0 ; 0x240: HOUR=0x0 DAYS=0x0 MNTH=0x0 YEAR=0x0 kfddde[1].failstmp.lo: 0 ; 0x244: USEC=0x0 MSEC=0x0 SECS=0x0 MINS=0x0 kfddde[1].timer: 0 ; 0x248: 0x00000000 kfddde[1].size: 1024 ; 0x24c: 0x00000400 kfddde[1].spare[0]: 0 ; 0x250: 0x00000000 kfddde[1].spare[1]: 0 ; 0x254: 0x00000000 kfddde[1].spare[2]: 0 ; 0x258: 0x00000000 kfddde[1].spare[3]: 0 ; 0x25c: 0x00000000 kfddde[1].spare[4]: 0 ; 0x260: 0x00000000 kfddde[1].zones[0].start: 0 ; 0x264: 0x00000000 kfddde[1].zones[0].size: 1024 ; 0x268: 0x00000400 kfddde[1].zones[0].used: 503 ; 0x26c: 0x000001f7 kfddde[1].zones[0].spare: 0 ; 0x270: 0x00000000 kfddde[1].zones[0].classes[0].imbal[0]:501 ; 0x274: 0x000001f5 修改完成之后，再使用kfed merge回去，如下： kfed merge /dev/sdc aun=2 text=sdc.txt |
下面是关于pst的信息修改：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 |
[oracle@10gasm ~]$ kfed read /dev/sdd aun=1 > sdd.txt [oracle@10gasm ~]$ vi sdd.txt kfbh.endian: 1 ; 0x000: 0x01 kfbh.hard: 130 ; 0x001: 0x82 kfbh.type: 17 ; 0x002: KFBTYP_PST_META kfbh.datfmt: 1 ; 0x003: 0x01 kfbh.block.blk: 256 ; 0x004: T=0 NUMB=0x100 kfbh.block.obj: 2147483648 ; 0x008: TYPE=0x8 NUMB=0x0 kfbh.check: 4116287946 ; 0x00c: 0xf55991ca kfbh.fcn.base: 0 ; 0x010: 0x00000000 kfbh.fcn.wrap: 0 ; 0x014: 0x00000000 kfbh.spare1: 0 ; 0x018: 0x00000000 kfbh.spare2: 0 ; 0x01c: 0x00000000 kfdpHdrB.time.hi: 32977608 ; 0x000: HOUR=0x8 DAYS=0x16 MNTH=0xc YEAR=0x7dc kfdpHdrB.time.lo: 1975197696 ; 0x004: USEC=0x0 MSEC=0x2c8 SECS=0x1b MINS=0x1d kfdpHdrB.last: 3 ; 0x008: 0x00000003 kfdpHdrB.next: 3 ; 0x00c: 0x00000003 kfdpHdrB.copyCnt: 1 ; 0x010: 0x01 kfdpHdrB.ub1spare: 0 ; 0x011: 0x00 kfdpHdrB.ub2spare: 0 ; 0x012: 0x0000 kfdpHdrB.incarn: 0 ; 0x014: 0x00000000 kfdpHdrB.copy[0]: 0 ; 0x018: 0x0000 kfdpHdrB.copy[1]: 0 ; 0x01a: 0x0000 kfdpHdrB.copy[2]: 0 ; 0x01c: 0x0000 kfdpHdrB.copy[3]: 0 ; 0x01e: 0x0000 kfdpHdrB.copy[4]: 0 ; 0x020: 0x0000 kfdpHdrB.dtaSz: 2 ; 0x022: 0x0002 ub1[0]: 2 ; 0x024: 0x02 ub1[1]: 0 ; 0x025: 0x00 ......... [oracle@10gasm ~]$ cat sdd.txt |grep kfdpHdrB.dtaSz kfdpHdrB.dtaSz: 2 ; 0x022: 0x0002 [oracle@10gasm ~]$ kfed merge /dev/sdd text=sdd.txt [oracle@10gasm ~]$ 分别修复了如下几个地方： kfdpHdrB.last: 1 ; 0x008: 0x00000001 kfdpHdrB.next: 1 ; 0x00c: 0x00000001 kfdpHdrB.dtaSz: 2 ; 0x022: 0x0002 |
当然，这里你修改一个block是不行的，asm通常会用好几个block去存pst信息，我这里
其实还merge了blkn 1,2,3等几个pst block，最后成功mount磁盘组。
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 |
SQL> alter diskgroup data1 mount; Diskgroup altered. SQL> 此时asm alert 信息如下： SQL> alter diskgroup data1 mount Sat Dec 22 22:23:45 2012 NOTE: cache registered group DATA1 number=1 incarn=0x1c5e7683 Sat Dec 22 22:23:45 2012 NOTE: Hbeat: instance first (grp 1) Sat Dec 22 22:23:51 2012 NOTE: start heartbeating (grp 1) NOTE: cache opening disk 0 of grp 1: DATA1_0000 path:/dev/sdd Sat Dec 22 22:23:51 2012 NOTE: F1X0 found on disk 0 fcn 0.0 NOTE: cache opening disk 1 of grp 1: DATA1_0001 path:/dev/sdc NOTE: cache mounting (first) group 1/0x1C5E7683 (DATA1) NOTE: cache recovered group 1 to fcn 0.2032 Sat Dec 22 22:23:51 2012 NOTE: opening chunk 1 at fcn 0.2032 ABA NOTE: seq=5 blk=117 Sat Dec 22 22:23:51 2012 NOTE: cache mounting group 1/0x1C5E7683 (DATA1) succeeded SUCCESS: diskgroup DATA1 was mounted Sat Dec 22 22:23:53 2012 NOTE: recovering COD for group 1/0x1c5e7683 (DATA1) SUCCESS: completed COD recovery for group 1/0x1c5e7683 (DATA1) |
最后我们再将前面失败的几个disk添加到asm diskgroup中，如下：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 |
SQL> alter diskgroup data1 add disk '/dev/sdb','/dev/sde' rebalance power 0; Diskgroup altered. SQL> 此时的alert log信息如下： Sat Dec 22 23:44:41 2012 SQL> alter diskgroup data1 add disk '/dev/sdb','/dev/sde' rebalance power 0 Sat Dec 22 23:44:41 2012 NOTE: initializing header on grp 1 disk DATA1_0002 NOTE: initializing header on grp 1 disk DATA1_0003 NOTE: cache opening disk 2 of grp 1: DATA1_0002 path:/dev/sdb NOTE: cache opening disk 3 of grp 1: DATA1_0003 path:/dev/sde NOTE: PST update: grp = 1 NOTE: requesting all-instance disk validation for group=1 Sat Dec 22 23:44:41 2012 NOTE: disk validation pending for group 1/0x1c5e7683 (DATA1) SUCCESS: validated disks for 1/0x1c5e7683 (DATA1) Sat Dec 22 23:44:44 2012 NOTE: PST update: grp = 1 NOTE: requesting all-instance PST refresh for group=1 Sat Dec 22 23:44:44 2012 NOTE: PST refresh pending for group 1/0x1c5e7683 (DATA1) SUCCESS: refreshed PST for 1/0x1c5e7683 (DATA1) Sat Dec 22 23:44:47 2012 NOTE: requesting all-instance PST refresh for group=1 Sat Dec 22 23:44:47 2012 NOTE: PST refresh pending for group 1/0x1c5e7683 (DATA1) SUCCESS: refreshed PST for 1/0x1c5e7683 (DATA1) |
通过alert log，其实我们也可以清楚的看到，在添加disk的过程中，其实主要需要做如下几个步骤：
1. 初始化disk header block
2. 更新pst。
当然，这里其实还涉及到其他的操作，另外如果是开启了rebalance操作，后还有rebalance的信息。
当然，如果你不想通过上面方式去做，可以直接使用oracle自带的amdu去抽取文件，不过这里需要说明的是，
在很多情况下，甚至disk header损坏的情况下，可能amdu都是不行的。你可以借助ODU去操作。 下面来详细
描述如何用amdu去抽取datafile以及其他文件。
—首先需要找到asm alias信息
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 |
[oracle@10gasm ~]$ kfed read /dev/sdd aun=2 blkn=6|grep au|more kfffde[0].xptr.au: 26 ; 0x4a0: 0x0000001a kfffde[1].xptr.au: 4294967295 ; 0x4a8: 0xffffffff kfffde[2].xptr.au: 4294967295 ; 0x4b0: 0xffffffff [oracle@10gasm ~]$ kfed read /dev/sdd aun=26 blkn=1|more kfbh.endian: 1 ; 0x000: 0x01 kfbh.hard: 130 ; 0x001: 0x82 kfbh.type: 11 ; 0x002: KFBTYP_ALIASDIR kfbh.datfmt: 1 ; 0x003: 0x01 kfbh.block.blk: 1 ; 0x004: T=0 NUMB=0x1 kfbh.block.obj: 6 ; 0x008: TYPE=0x0 NUMB=0x6 kfbh.check: 1090379337 ; 0x00c: 0x40fdde49 kfbh.fcn.base: 1995 ; 0x010: 0x000007cb kfbh.fcn.wrap: 0 ; 0x014: 0x00000000 kfbh.spare1: 0 ; 0x018: 0x00000000 kfbh.spare2: 0 ; 0x01c: 0x00000000 kffdnd.bnode.incarn: 1 ; 0x000: A=1 NUMM=0x0 kffdnd.bnode.frlist.number: 4294967295 ; 0x004: 0xffffffff kffdnd.bnode.frlist.incarn: 0 ; 0x008: A=0 NUMM=0x0 kffdnd.overfl.number: 4294967295 ; 0x00c: 0xffffffff kffdnd.overfl.incarn: 0 ; 0x010: A=0 NUMM=0x0 kffdnd.parent.number: 0 ; 0x014: 0x00000000 kffdnd.parent.incarn: 1 ; 0x018: A=1 NUMM=0x0 kffdnd.fstblk.number: 1 ; 0x01c: 0x00000001 kffdnd.fstblk.incarn: 1 ; 0x020: A=1 NUMM=0x0 kfade[0].entry.incarn: 1 ; 0x024: A=1 NUMM=0x0 kfade[0].entry.hash: 710518681 ; 0x028: 0x2a59a799 kfade[0].entry.refer.number: 2 ; 0x02c: 0x00000002 kfade[0].entry.refer.incarn: 1 ; 0x030: A=1 NUMM=0x0 kfade[0].name: DATAFILE ; 0x034: length=8 kfade[0].fnum: 4294967295 ; 0x064: 0xffffffff kfade[0].finc: 4294967295 ; 0x068: 0xffffffff kfade[0].flags: 4 ; 0x06c: U=0 S=0 S=1 U=0 F=0 kfade[0].ub1spare: 0 ; 0x06d: 0x00 kfade[0].ub2spare: 0 ; 0x06e: 0x0000 kfade[1].entry.incarn: 3 ; 0x070: A=1 NUMM=0x1 kfade[1].entry.hash: 4053320104 ; 0x074: 0xf198c1a8 kfade[1].entry.refer.number: 3 ; 0x078: 0x00000003 kfade[1].entry.refer.incarn: 3 ; 0x07c: A=1 NUMM=0x1 kfade[1].name: CONTROLFILE ; 0x080: length=11 kfade[1].fnum: 4294967295 ; 0x0b0: 0xffffffff kfade[1].finc: 4294967295 ; 0x0b4: 0xffffffff kfade[1].flags: 4 ; 0x0b8: U=0 S=0 S=1 U=0 F=0 kfade[1].ub1spare: 0 ; 0x0b9: 0x00 kfade[1].ub2spare: 0 ; 0x0ba: 0x0000 kfade[2].entry.incarn: 1 ; 0x0bc: A=1 NUMM=0x0 kfade[2].entry.hash: 2803485489 ; 0x0c0: 0xa719cb31 kfade[2].entry.refer.number: 4 ; 0x0c4: 0x00000004 kfade[2].entry.refer.incarn: 1 ; 0x0c8: A=1 NUMM=0x0 kfade[2].name: ONLINELOG ; 0x0cc: length=9 kfade[2].fnum: 4294967295 ; 0x0fc: 0xffffffff kfade[2].finc: 4294967295 ; 0x100: 0xffffffff kfade[2].flags: 4 ; 0x104: U=0 S=0 S=1 U=0 F=0 kfade[2].ub1spare: 0 ; 0x105: 0x00 kfade[2].ub2spare: 0 ; 0x106: 0x0000 kfade[3].entry.incarn: 1 ; 0x108: A=1 NUMM=0x0 kfade[3].entry.hash: 2905271101 ; 0x10c: 0xad2aeb3d kfade[3].entry.refer.number: 5 ; 0x110: 0x00000005 kfade[3].entry.refer.incarn: 1 ; 0x114: A=1 NUMM=0x0 kfade[3].name: TEMPFILE ; 0x118: length=8 kfade[3].fnum: 4294967295 ; 0x148: 0xffffffff kfade[3].finc: 4294967295 ; 0x14c: 0xffffffff kfade[3].flags: 4 ; 0x150: U=0 S=0 S=1 U=0 F=0 kfade[3].ub1spare: 0 ; 0x151: 0x00 kfade[3].ub2spare: 0 ; 0x152: 0x0000 kfade[4].entry.incarn: 1 ; 0x154: A=1 NUMM=0x0 kfade[4].entry.hash: 3261836913 ; 0x158: 0xc26bae71 kfade[4].entry.refer.number: 6 ; 0x15c: 0x00000006 kfade[4].entry.refer.incarn: 1 ; 0x160: A=1 NUMM=0x0 kfade[4].name: PARAMETERFILE ; 0x164: length=13 kfade[4].fnum: 4294967295 ; 0x194: 0xffffffff kfade[4].finc: 4294967295 ; 0x198: 0xffffffff kfade[4].flags: 4 ; 0x19c: U=0 S=0 S=1 U=0 F=0 kfade[4].ub1spare: 0 ; 0x19d: 0x00 kfade[4].ub2spare: 0 ; 0x19e: 0x0000 kfade[5].entry.incarn: 1 ; 0x1a0: A=1 NUMM=0x0 kfade[5].entry.hash: 2892671843 ; 0x1a4: 0xac6aab63 kfade[5].entry.refer.number: 4294967295 ; 0x1a8: 0xffffffff kfade[5].entry.refer.incarn: 0 ; 0x1ac: A=0 NUMM=0x0 kfade[5].name: spfiletest.ora ; 0x1b0: length=14 kfade[5].fnum: 265 ; 0x1e0: 0x00000109 kfade[5].finc: 802678613 ; 0x1e4: 0x2fd7e755 kfade[5].flags: 17 ; 0x1e8: U=1 S=0 S=0 U=0 F=1 kfade[5].ub1spare: 0 ; 0x1e9: 0x00 kfade[5].ub2spare: 0 ; 0x1ea: 0x0000 ....省略部分内容 |
datafile在最前面，说明在第2个block，如下：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 |
[oracle@10gasm ~]$ kfed read /dev/sdd aun=26 blkn=2|more kfbh.endian: 1 ; 0x000: 0x01 kfbh.hard: 130 ; 0x001: 0x82 kfbh.type: 11 ; 0x002: KFBTYP_ALIASDIR kfbh.datfmt: 1 ; 0x003: 0x01 kfbh.block.blk: 2 ; 0x004: T=0 NUMB=0x2 kfbh.block.obj: 6 ; 0x008: TYPE=0x0 NUMB=0x6 kfbh.check: 892835323 ; 0x00c: 0x353795fb kfbh.fcn.base: 1599 ; 0x010: 0x0000063f kfbh.fcn.wrap: 0 ; 0x014: 0x00000000 kfbh.spare1: 0 ; 0x018: 0x00000000 kfbh.spare2: 0 ; 0x01c: 0x00000000 kffdnd.bnode.incarn: 1 ; 0x000: A=1 NUMM=0x0 kffdnd.bnode.frlist.number: 4294967295 ; 0x004: 0xffffffff kffdnd.bnode.frlist.incarn: 0 ; 0x008: A=0 NUMM=0x0 kffdnd.overfl.number: 4294967295 ; 0x00c: 0xffffffff kffdnd.overfl.incarn: 0 ; 0x010: A=0 NUMM=0x0 kffdnd.parent.number: 1 ; 0x014: 0x00000001 kffdnd.parent.incarn: 1 ; 0x018: A=1 NUMM=0x0 kffdnd.fstblk.number: 2 ; 0x01c: 0x00000002 kffdnd.fstblk.incarn: 1 ; 0x020: A=1 NUMM=0x0 kfade[0].entry.incarn: 1 ; 0x024: A=1 NUMM=0x0 kfade[0].entry.hash: 1251413818 ; 0x028: 0x4a970f3a kfade[0].entry.refer.number: 4294967295 ; 0x02c: 0xffffffff kfade[0].entry.refer.incarn: 0 ; 0x030: A=0 NUMM=0x0 kfade[0].name: SYSTEM ; 0x034: length=6 kfade[0].fnum: 256 ; 0x064: 0x00000100 kfade[0].finc: 802678453 ; 0x068: 0x2fd7e6b5 kfade[0].flags: 18 ; 0x06c: U=0 S=1 S=0 U=0 F=1 kfade[0].ub1spare: 0 ; 0x06d: 0x00 kfade[0].ub2spare: 0 ; 0x06e: 0x0000 kfade[1].entry.incarn: 1 ; 0x070: A=1 NUMM=0x0 kfade[1].entry.hash: 1356948434 ; 0x074: 0x50e163d2 kfade[1].entry.refer.number: 4294967295 ; 0x078: 0xffffffff kfade[1].entry.refer.incarn: 0 ; 0x07c: A=0 NUMM=0x0 kfade[1].name: SYSAUX ; 0x080: length=6 kfade[1].fnum: 257 ; 0x0b0: 0x00000101 kfade[1].finc: 802678455 ; 0x0b4: 0x2fd7e6b7 kfade[1].flags: 18 ; 0x0b8: U=0 S=1 S=0 U=0 F=1 kfade[1].ub1spare: 0 ; 0x0b9: 0x00 kfade[1].ub2spare: 0 ; 0x0ba: 0x0000 kfade[2].entry.incarn: 1 ; 0x0bc: A=1 NUMM=0x0 kfade[2].entry.hash: 495364582 ; 0x0c0: 0x1d86a9e6 kfade[2].entry.refer.number: 4294967295 ; 0x0c4: 0xffffffff kfade[2].entry.refer.incarn: 0 ; 0x0c8: A=0 NUMM=0x0 kfade[2].name: UNDOTBS1 ; 0x0cc: length=8 kfade[2].fnum: 258 ; 0x0fc: 0x00000102 .....省略部分内容 定位到asm file number号： <pre lang="text"> [oracle@10gasm ~]$ kfed read /dev/sdd aun=26 blkn=2|grep fnum | more kfade[0].fnum: 256 ; 0x064: 0x00000100 kfade[1].fnum: 257 ; 0x0b0: 0x00000101 kfade[2].fnum: 258 ; 0x0fc: 0x00000102 kfade[3].fnum: 259 ; 0x148: 0x00000103 kfade[4].fnum: 0 ; 0x194: 0x00000000 kfade[5].fnum: 0 ; 0x1e0: 0x00000000 ...... |
接着我们来看controlfile：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 |
[oracle@10gasm ~]$ kfed read /dev/sdd aun=26 blkn=3|more kfbh.endian: 1 ; 0x000: 0x01 kfbh.hard: 130 ; 0x001: 0x82 kfbh.type: 11 ; 0x002: KFBTYP_ALIASDIR kfbh.datfmt: 1 ; 0x003: 0x01 kfbh.block.blk: 3 ; 0x004: T=0 NUMB=0x3 kfbh.block.obj: 6 ; 0x008: TYPE=0x0 NUMB=0x6 kfbh.check: 363349019 ; 0x00c: 0x15a8441b kfbh.fcn.base: 1683 ; 0x010: 0x00000693 kfbh.fcn.wrap: 0 ; 0x014: 0x00000000 kfbh.spare1: 0 ; 0x018: 0x00000000 kfbh.spare2: 0 ; 0x01c: 0x00000000 kffdnd.bnode.incarn: 3 ; 0x000: A=1 NUMM=0x1 kffdnd.bnode.frlist.number: 4294967295 ; 0x004: 0xffffffff kffdnd.bnode.frlist.incarn: 0 ; 0x008: A=0 NUMM=0x0 kffdnd.overfl.number: 4294967295 ; 0x00c: 0xffffffff kffdnd.overfl.incarn: 0 ; 0x010: A=0 NUMM=0x0 kffdnd.parent.number: 1 ; 0x014: 0x00000001 kffdnd.parent.incarn: 1 ; 0x018: A=1 NUMM=0x0 kffdnd.fstblk.number: 3 ; 0x01c: 0x00000003 kffdnd.fstblk.incarn: 3 ; 0x020: A=1 NUMM=0x1 kfade[0].entry.incarn: 3 ; 0x024: A=1 NUMM=0x1 kfade[0].entry.hash: 3062743642 ; 0x028: 0xb68dc25a kfade[0].entry.refer.number: 4294967295 ; 0x02c: 0xffffffff kfade[0].entry.refer.incarn: 0 ; 0x030: A=0 NUMM=0x0 kfade[0].name: Current ; 0x034: length=7 kfade[0].fnum: 260 ; 0x064: 0x00000104 kfade[0].finc: 802678553 ; 0x068: 0x2fd7e719 kfade[0].flags: 18 ; 0x06c: U=0 S=1 S=0 U=0 F=1 .... 省略部分内容 |
下面是redo logfile的信息：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 |
[oracle@10gasm ~]$ kfed read /dev/sdd aun=26 blkn=4|more kfbh.endian: 1 ; 0x000: 0x01 kfbh.hard: 130 ; 0x001: 0x82 kfbh.type: 11 ; 0x002: KFBTYP_ALIASDIR kfbh.datfmt: 1 ; 0x003: 0x01 kfbh.block.blk: 4 ; 0x004: T=0 NUMB=0x4 kfbh.block.obj: 6 ; 0x008: TYPE=0x0 NUMB=0x6 kfbh.check: 1826975500 ; 0x00c: 0x6ce56f0c kfbh.fcn.base: 1887 ; 0x010: 0x0000075f kfbh.fcn.wrap: 0 ; 0x014: 0x00000000 kfbh.spare1: 0 ; 0x018: 0x00000000 kfbh.spare2: 0 ; 0x01c: 0x00000000 kffdnd.bnode.incarn: 1 ; 0x000: A=1 NUMM=0x0 kffdnd.bnode.frlist.number: 4294967295 ; 0x004: 0xffffffff kffdnd.bnode.frlist.incarn: 0 ; 0x008: A=0 NUMM=0x0 kffdnd.overfl.number: 4294967295 ; 0x00c: 0xffffffff kffdnd.overfl.incarn: 0 ; 0x010: A=0 NUMM=0x0 kffdnd.parent.number: 1 ; 0x014: 0x00000001 kffdnd.parent.incarn: 1 ; 0x018: A=1 NUMM=0x0 kffdnd.fstblk.number: 4 ; 0x01c: 0x00000004 kffdnd.fstblk.incarn: 1 ; 0x020: A=1 NUMM=0x0 kfade[0].entry.incarn: 1 ; 0x024: A=1 NUMM=0x0 kfade[0].entry.hash: 2031796096 ; 0x028: 0x791abf80 kfade[0].entry.refer.number: 4294967295 ; 0x02c: 0xffffffff kfade[0].entry.refer.incarn: 0 ; 0x030: A=0 NUMM=0x0 kfade[0].name: group_1 ; 0x034: length=7 kfade[0].fnum: 261 ; 0x064: 0x00000105 kfade[0].finc: 802678553 ; 0x068: 0x2fd7e719 kfade[0].flags: 18 ; 0x06c: U=0 S=1 S=0 U=0 F=1 kfade[0].ub1spare: 0 ; 0x06d: 0x00 kfade[0].ub2spare: 0 ; 0x06e: 0x0000 kfade[1].entry.incarn: 1 ; 0x070: A=1 NUMM=0x0 kfade[1].entry.hash: 392836082 ; 0x074: 0x176a33f2 kfade[1].entry.refer.number: 4294967295 ; 0x078: 0xffffffff kfade[1].entry.refer.incarn: 0 ; 0x07c: A=0 NUMM=0x0 kfade[1].name: group_2 ; 0x080: length=7 kfade[1].fnum: 262 ; 0x0b0: 0x00000106 kfade[1].finc: 802678555 ; 0x0b4: 0x2fd7e71b kfade[1].flags: 18 ; 0x0b8: U=0 S=1 S=0 U=0 F=1 kfade[1].ub1spare: 0 ; 0x0b9: 0x00 kfade[1].ub2spare: 0 ; 0x0ba: 0x0000 kfade[2].entry.incarn: 1 ; 0x0bc: A=1 NUMM=0x0 kfade[2].entry.hash: 2800308934 ; 0x0c0: 0xa6e952c6 kfade[2].entry.refer.number: 4294967295 ; 0x0c4: 0xffffffff kfade[2].entry.refer.incarn: 0 ; 0x0c8: A=0 NUMM=0x0 kfade[2].name: group_3 ; 0x0cc: length=7 kfade[2].fnum: 263 ; 0x0fc: 0x00000107 kfade[2].finc: 802678557 ; 0x100: 0x2fd7e71d kfade[2].flags: 18 ; 0x104: U=0 S=1 S=0 U=0 F=1 kfade[2].ub1spare: 0 ; 0x105: 0x00 kfade[2].ub2spare: 0 ; 0x106: 0x0000 kfade[3].entry.incarn: 0 ; 0x108: A=0 NUMM=0x0 kfade[3].entry.hash: 0 ; 0x10c: 0x00000000 kfade[3].entry.refer.number: 0 ; 0x110: 0x00000000 kfade[3].entry.refer.incarn: 0 ; 0x114: A=0 NUMM=0x0 kfade[3].name: ; 0x118: length=0 ......... |
tempfile我们就不管了，你可以把库拉起来了新建就行了，最后来看下spfile：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 |
[oracle@10gasm ~]$ kfed read /dev/sdd aun=26 blkn=6|more kfbh.endian: 1 ; 0x000: 0x01 kfbh.hard: 130 ; 0x001: 0x82 kfbh.type: 11 ; 0x002: KFBTYP_ALIASDIR kfbh.datfmt: 1 ; 0x003: 0x01 kfbh.block.blk: 6 ; 0x004: T=0 NUMB=0x6 kfbh.block.obj: 6 ; 0x008: TYPE=0x0 NUMB=0x6 kfbh.check: 3446176149 ; 0x00c: 0xcd687995 kfbh.fcn.base: 1994 ; 0x010: 0x000007ca kfbh.fcn.wrap: 0 ; 0x014: 0x00000000 kfbh.spare1: 0 ; 0x018: 0x00000000 kfbh.spare2: 0 ; 0x01c: 0x00000000 kffdnd.bnode.incarn: 1 ; 0x000: A=1 NUMM=0x0 kffdnd.bnode.frlist.number: 4294967295 ; 0x004: 0xffffffff kffdnd.bnode.frlist.incarn: 0 ; 0x008: A=0 NUMM=0x0 kffdnd.overfl.number: 4294967295 ; 0x00c: 0xffffffff kffdnd.overfl.incarn: 0 ; 0x010: A=0 NUMM=0x0 kffdnd.parent.number: 1 ; 0x014: 0x00000001 kffdnd.parent.incarn: 1 ; 0x018: A=1 NUMM=0x0 kffdnd.fstblk.number: 6 ; 0x01c: 0x00000006 kffdnd.fstblk.incarn: 1 ; 0x020: A=1 NUMM=0x0 kfade[0].entry.incarn: 1 ; 0x024: A=1 NUMM=0x0 kfade[0].entry.hash: 1965945079 ; 0x028: 0x752df0f7 kfade[0].entry.refer.number: 4294967295 ; 0x02c: 0xffffffff kfade[0].entry.refer.incarn: 0 ; 0x030: A=0 NUMM=0x0 kfade[0].name: spfile ; 0x034: length=6 kfade[0].fnum: 265 ; 0x064: 0x00000109 kfade[0].finc: 802678613 ; 0x068: 0x2fd7e755 kfade[0].flags: 18 ; 0x06c: U=0 S=1 S=0 U=0 F=1 kfade[0].ub1spare: 0 ; 0x06d: 0x00 kfade[0].ub2spare: 0 ; 0x06e: 0x0000 .......... |
下面开始抽取的简单命令，过程补贴了最后加上结果：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 |
--extrace spfile amdu -dis '/dev/sd*' -extract data1.265 -output spfile.ora --extrace controlfile amdu -dis '/dev/sd*' -nodir -norep -extract data1.260 -output control01.ctl --extract datafile amdu -dis '/dev/sd*' -nodir -norep -extract data1.256 -output system01.dbf amdu -dis '/dev/sd*' -nodir -norep -extract data1.257 -output sysaux01.dbf amdu -dis '/dev/sd*' -nodir -norep -extract data1.258 -output undotbs01.dbf amdu -dis '/dev/sd*' -nodir -norep -extract data1.259 -output users01.dbf --extract redo logfile amdu -dis '/dev/sd*' -nodir -norep -extract data1.261 -output redo01.log amdu -dis '/dev/sd*' -nodir -norep -extract data1.262 -output redo02.log amdu -dis '/dev/sd*' -nodir -norep -extract data1.263 -output redo03.log 最后我们来看看amdu所抽取出来的文件： [oracle@10gasm amdu_2012_12_22_23_22_52]$ ls -ltr total 878236 -rw-r--r-- 1 oracle oinstall 2560 Dec 22 23:26 spfile.ora -rw-r--r-- 1 oracle oinstall 7061504 Dec 22 23:27 control01.ctl -rw-r--r-- 1 oracle oinstall 52429312 Dec 22 23:28 redo01.log -rw-r--r-- 1 oracle oinstall 52429312 Dec 22 23:28 redo02.log -rw-r--r-- 1 oracle oinstall 503324672 Dec 22 23:29 system01.dbf -rw-r--r-- 1 oracle oinstall 251666432 Dec 22 23:30 sysaux01.dbf -rw-r--r-- 1 oracle oinstall 26222592 Dec 22 23:31 undotbs01.dbf -rw-r--r-- 1 oracle oinstall 5251072 Dec 22 23:31 users01.dbf |
最后你可以通过dbv来检测一下所抽取的文件是否完好：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 |
[oracle@10gasm amdu_2012_12_22_23_22_52]$ dbv file=system01.dbf DBVERIFY: Release 10.2.0.1.0 - Production on Sat Dec 22 23:33:52 2012 Copyright (c) 1982, 2005, Oracle. All rights reserved. DBVERIFY - Verification starting : FILE = system01.dbf DBVERIFY - Verification complete Total Pages Examined : 61440 Total Pages Processed (Data) : 36222 Total Pages Failing (Data) : 0 Total Pages Processed (Index): 6767 Total Pages Failing (Index): 0 Total Pages Processed (Other): 1775 Total Pages Processed (Seg) : 0 Total Pages Failing (Seg) : 0 Total Pages Empty : 16676 Total Pages Marked Corrupt : 0 Total Pages Influx : 0 Highest block SCN : 475652 (0.475652) [oracle@10gasm amdu_2012_12_22_23_22_52]$ dbv file=sysaux01.dbf DBVERIFY: Release 10.2.0.1.0 - Production on Sat Dec 22 23:34:08 2012 Copyright (c) 1982, 2005, Oracle. All rights reserved. DBVERIFY - Verification starting : FILE = sysaux01.dbf DBVERIFY - Verification complete Total Pages Examined : 30720 Total Pages Processed (Data) : 2252 Total Pages Failing (Data) : 0 Total Pages Processed (Index): 2127 Total Pages Failing (Index): 0 Total Pages Processed (Other): 14035 Total Pages Processed (Seg) : 0 Total Pages Failing (Seg) : 0 Total Pages Empty : 12306 Total Pages Marked Corrupt : 0 Total Pages Influx : 0 Highest block SCN : 475379 (0.475379) [oracle@10gasm amdu_2012_12_22_23_22_52]$ dbv file=users01.dbf DBVERIFY: Release 10.2.0.1.0 - Production on Sat Dec 22 23:34:25 2012 Copyright (c) 1982, 2005, Oracle. All rights reserved. DBVERIFY - Verification starting : FILE = users01.dbf DBVERIFY - Verification complete Total Pages Examined : 640 Total Pages Processed (Data) : 15 Total Pages Failing (Data) : 0 Total Pages Processed (Index): 2 Total Pages Failing (Index): 0 Total Pages Processed (Other): 26 Total Pages Processed (Seg) : 0 Total Pages Failing (Seg) : 0 Total Pages Empty : 597 Total Pages Marked Corrupt : 0 Total Pages Influx : 0 Highest block SCN : 442362 (0.442362) [oracle@10gasm amdu_2012_12_22_23_22_52]$ dbv file=undotbs01.dbf DBVERIFY: Release 10.2.0.1.0 - Production on Sat Dec 22 23:34:33 2012 Copyright (c) 1982, 2005, Oracle. All rights reserved. DBVERIFY - Verification starting : FILE = undotbs01.dbf DBVERIFY - Verification complete Total Pages Examined : 3200 Total Pages Processed (Data) : 0 Total Pages Failing (Data) : 0 Total Pages Processed (Index): 0 Total Pages Failing (Index): 0 Total Pages Processed (Other): 2444 Total Pages Processed (Seg) : 0 Total Pages Failing (Seg) : 0 Total Pages Empty : 756 Total Pages Marked Corrupt : 0 Total Pages Influx : 0 Highest block SCN : 475650 (0.475650) [oracle@10gasm amdu_2012_12_22_23_22_52]$ |
补充： 从11gR1开始，操作根本不需要这样操作了,从11.2.0.3开始，甚至还可以直接force drop disk和force mount diskgroup。
6 Responses to “asm 添加disk时，ctrl+C导致diskgroup无法mount”
大师就是大师
good!
请问11gR1上可以怎么操作呢？
11gR1 没有测试过，11gR2没有这个问题。
[…] X86 上的评论手板www.gelinbeier.cn 在 关于dbwr/lgwr的一点知识 上的评论lizhenxu 在 asm 添加disk时，ctrl+C导致diskgroup无法mount 上的评论xigua 在 asm 添加disk时，ctrl+C导致diskgroup无法mount 上的评论Internal […]
[…] 大家可以参考下： asm 添加disk时，ctrl+C导致diskgroup无法mount http://www.killdb.com/2012/12/23/asm-%E6%B7%BB%E5%8A%A0disk%E6%97%B6%EF%BC%8Cctrlc%E5%AF%BC%E8%87%B4… […]
Leave a Reply
You must be logged in to post a comment.