Oracle ASM错误之--ORA-15033

系统环境：

操作系统： AIX 5.3.8

Oracle： Oracle 10gR2


故障现象：

SQL>creatediskgroupdatafile2normalredundancyfailgroupfg1disk'/dev/rlv_data1'34failgroupfg2disk'/dev/rlv_data2';creatediskgroupdatafile*ERRORatline1:ORA-15018:diskgroupcannotbecreatedORA-15033:disk'/dev/rlv_data2'belongstodiskgroup"RECOVER"ORA-15033:disk'/dev/rlv_data1'belongstodiskgroup"DATA"SQL>selectgroup_number,name,statefromv$asm_diskgroup;GROUP_NUMBERNAMESTATE-----------------------------------------------------0REDODISMOUNTED0ARCHDISMOUNTED0DATADISMOUNTED0RECOVERDISMOUNTED

故障原因：

[oracle@aix213dbs]$lsvg-lasmvgasmvg:LVNAMETYPELPsPPsPVsLVSTATEMOUNTPOINTlv_data1jfs64641open/syncdN/Alv_data2jfs64641open/syncdN/Aasmredo2jfs32321open/syncdN/A[oracle@aix213dbs]$lspvhdisk100c6d0ef0395eef2rootvgactivehdisk00006816a72287441asmvgactive

应该是在AIX的ODM中，rlv_data1和rlv_data2，已经属于另外的磁盘组。

解决方法：

1）清理raw头部信息

[root@aix213/]#ddif=/dev/zeroof=/dev/rlv_data1bs=8kcount=256256+0recordsin256+0recordsout[root@aix213/]#ddif=/dev/zeroof=/dev/rlv_data2bs=8kcount=256256+0recordsin256+0recordsout

2）重新建立ASM DISKGROUP

[oracle@aix213dbs]$sqlplus/assysdbaSQL*Plus:Release10.2.0.1.0-ProductiononThuJul2411:44:292014Copyright(c)1982,2005,Oracle.Allrightsreserved.Connectedto:OracleDatabase10gEnterpriseEditionRelease10.2.0.1.0-64bitProductionWiththePartitioning,OLAPandDataMiningoptionsSQL>selectname,statefromv$asm_diskgroup;NAMESTATE-----------------------------------------REDODISMOUNTEDARCHDISMOUNTED清理raw头部信息后data和recoverdiskgroup自动被删除！SQL>creatediskgroupdatafile2normalredundancy3failgroupfg1disk'/dev/rlv_data1'4failgroupfg2disk'/dev/rlv_data2';Diskgroupcreated.磁盘组创建成功！

3）验证

SQL>selectname,statefromv$asm_diskgroup;NAMESTATE-----------------------------------------REDODISMOUNTEDARCHDISMOUNTEDDATAFILEMOUNTEDSQL>alterdiskgroupredomount;Diskgroupaltered.SQL>alterdiskgrouparchmount;Diskgroupaltered.SQL>selectname,statefromv$asm_diskgroup;NAMESTATE-----------------------------------------REDOMOUNTEDARCHMOUNTEDDATAFILEMOUNTED

@至此，问题被解决 ！