如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!
诗檀软件专业数据库修复团队
服务热线 ： 13764045638 QQ号:47079569 邮箱：[email protected]
症状
ASM DISK WITH MOUNT_STATUS=CLOSED HEADER_STATUS=MEMBER GROUP_NUMBER=0
GROUP_NUMBER DISK_NUMBER MOUNT_S HEADER_STATU MODE_ST STATE OS_MB TOTAL_MB FREE_MB NAME FAILGROUP LABEL PATH
0 0 CLOSED MEMBER ONLINE NORMAL 69711 0 0 EMCORA43 ORCL:EMCORA43
0 1 CLOSED MEMBER ONLINE NORMAL 69711 0 0 EMCORA47 ORCL:EMCORA47
KFED IS SHOWING THESE DISKS ARE MEMBER OF ALREADY MOUNTED DISKGROUP (PRD_GOLD_FRA1)
GROUP_NUMBER NAME STATE
4 PRD_GOLD_FRA1 MOUNTED
/dev/oracleasm/disks/EMCORA47
disk /dev/oracleasm/disks/EMCORA47 is disk_number 12
kfdhdb.dsknum: 12 ; 0x024: 0x000c <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
kfdhdb.grptyp: 1 ; 0x026: KFDGTP_EXTERNAL
kfdhdb.hdrsts: 3 ; 0x027: KFDHDR_MEMBER
kfdhdb.dskname: EMCORA68 ; 0x028: length=8
kfdhdb.grpname: PRD_GOLD_FRA1 ; 0x048: length=13
kfdhdb.fgname: EMCORA68 ; 0x068: length=8
/dev/oracleasm/disks/EMCORA43
disk /dev/oracleasm/disks/EMCORA43 is disk_number 11
kfdhdb.dsknum: 11 ; 0x024: 0x000b <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
kfdhdb.grptyp: 1 ; 0x026: KFDGTP_EXTERNAL
kfdhdb.hdrsts: 3 ; 0x027: KFDHDR_MEMBER
kfdhdb.dskname: EMCORA66 ; 0x028: length=8
kfdhdb.grpname: PRD_GOLD_FRA1 ; 0x048: length=13
kfdhdb.fgname: EMCORA66 ; 0x068: length=8
原因
尽管PRD_GOLD_DATA1 dg的安装显示它是去分配磁盘EMCORA43和EMCORA47,这意味着它们不包含在磁盘组中。
这可能是由于增加这些磁盘时并没有跨节点共享设备:
alert_+ASM1.log.15
===================
Sun Mar 25 12:43:15 2012
…………………..
NOTE: Instance updated compatible.asm to 10.1.0.0.0 for grp 3
SUCCESS: diskgroup PRD_GOLD_DATA1 was mounted
NOTE: De-assigning number (4,11) from disk (ORCL:EMCORA43)
NOTE: De-assigning number (4,12) from disk (ORCL:EMCORA47)
kfdp_query(PRD_GOLD_FRA1): 38
kfdp_queryBg(): 38
NOTE: Instance updated compatible.asm to 10.1.0.0.0 for grp 4
SUCCESS: diskgroup PRD_GOLD_FRA1 was mounted
+ASM1_ora_10972.trc
======================
Validated domain 11, flags = 0x0
ASM name of disk 0x70882a00 (4:11:EMCORA66:ORCL:EMCORA43) is being cleared
NOTE: De-assigning number (4,11) from disk (ORCL:EMCORA43)
ASM name of disk 0x708819a8 (4:12:EMCORA68:ORCL:EMCORA47) is being cleared
NOTE: De-assigning number (4,12) from disk (ORCL:EMCORA47)
或者由于以下错误:
警告: 在深层发现中忽略磁盘o/192.168.54.52/RECO_CD_11_ldnpso0322admin
ERROR: ORA-15033 signalled during reconfiguration of diskgroup RECO
….
alert_+ASM8.log:
Tue Apr 20 07:46:05 2010
ORA-15032: not all alterations performed
ORA-15033: disk ‘o/192.168.54.52/RECO_CD_00_ldnpso0322admin’ belongs to diskgroup “RECO”
ERROR: alter diskgroup RECO add disk ‘o/192.168.54.52/RECO_CD_00_ldnpso0322admin’ rebalance power 10 wait
磁盘号11和12 不显示在v$asm_disk 查询输出中:
SELECT GROUP_NUMBER,DISK_NUMBER,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,OS_MB,TOTAL_MB,FREE_MB,NAME,FAILGROUP,LABEL,PATH FROM V$ASM_DISK WHERE GROUP_NUMBER=4;
GROUP_NUMBER DISK_NUMBER MOUNT_S HEADER_STATU MODE_ST STATE OS_MB TOTAL_MB FREE_MB NAME FAILGROUP LABEL PATH
4 0 CACHED MEMBER ONLINE NORMAL 69711 69711 21499 EMCORA24 EMCORA24 EMCORA24 ORCL:EMCORA24
4 1 CACHED MEMBER ONLINE NORMAL 69711 69711 21486 EMCORA25 EMCORA25 EMCORA25 ORCL:EMCORA25
4 2 CACHED MEMBER ONLINE NORMAL 69711 69711 21647 EMCORA26 EMCORA26 EMCORA26 ORCL:EMCORA26
4 3 CACHED MEMBER ONLINE NORMAL 69711 69711 21625 EMCORA27 EMCORA27 EMCORA27 ORCL:EMCORA27
4 4 CACHED MEMBER ONLINE NORMAL 69711 69711 21578 EMCORA30 EMCORA30 EMCORA30 ORCL:EMCORA30
4 5 CACHED MEMBER ONLINE NORMAL 69711 69711 21640 EMCORA31 EMCORA31 EMCORA31 ORCL:EMCORA31
4 6 CACHED MEMBER ONLINE NORMAL 69711 69711 21853 EMCDB004 EMCDB004 EMCDB004 ORCL:EMCDB004
4 7 CACHED MEMBER ONLINE NORMAL 69711 69711 21767 EMCORA34 EMCORA34 EMCORA34 ORCL:EMCORA34
4 8 CACHED MEMBER ONLINE NORMAL 69711 69711 21692 EMCORA35 EMCORA35 EMCORA35 ORCL:EMCORA35
4 9 CACHED MEMBER ONLINE NORMAL 69711 69711 21754 EMCORA36 EMCORA36 EMCORA36 ORCL:EMCORA36
4 10 CACHED MEMBER ONLINE NORMAL 69711 69711 22076 EMCORA65 EMCORA65 EMCORA65 ORCL:EMCORA65
4 13 CACHED MEMBER ONLINE NORMAL 69711 69711 22342 EMCORA64 EMCORA64 EMCORA64 ORCL:EMCORA64
解决方法
– 仅采用磁盘的10 MB dd 备份:
dd if=/dev/oracleasm/disks/EMCORA43 of=/tmp/EMCORA43.txt bs=1M count=10
dd if=/dev/oracleasm/disks/EMCORA47 of=/tmp/EMCORA43.txt bs=1M count=10
– 更改这些2磁盘到000的许可
#chmod 000 /dev/oracleasm/disks/EMCORA47
#chmod 000 /dev/oracleasm/disks/EMCORA43
– 然后卸载和安装 磁盘组PRD_GOLD_DATA1
– 如果成功安装磁盘组，那么我们可以通过使用dd命令清除头部移动这两个磁盘。
dd if=/dev/zero of=/dev/oracleasm/disks/EMCORA43 bs=1M count=1
dd if=/dev/zero of=/dev/oracleasm/disks/EMCORA47 bs=1M count=1
-或者你可以通过从 asmlib oracleasm删除标签从asm移动这两个磁盘 (或许你需要为接下来的操作改变磁盘的许可到660)
/etc/init.d/oracleasm deletedisk EMCORA43
/etc/init.d/oracleasm deletedisk EMCORA47
-或者使用强制选项创建一个带有这些磁盘的磁盘组，然后如果一切良好，然后你可以继续，删除新创建的磁盘组，添加这些磁盘到想要的磁盘组。
Leave a Reply