Oracle ASM错误之--ORA-15033

Oracle ASM错误之--ORA-15033系统环境：操作系统： AIX 5.3.8Oracle： Oracle 10gR2故障现象：SQL> create diskgroup datafile 2 normal redundancy failgroup fg1 disk "/dev/rlv_data1" 3 4 failgroup fg2 disk "/dev/rlv_data2";create diskgroup datafile*ERROR at line 1:ORA-15018: diskgroup cannot be createdORA-15033: disk "/dev/rlv_data2" belongs to diskgroup "RECOVER"ORA-15033: disk "/dev/rlv_data1" belongs to diskgroup "DATA"SQL> select group_number,name,state from v$asm_diskgroup;GROUP_NUMBER NAME STATE------------ ------------------------------ ----------- 0 REDO DISMOUNTED 0 ARCH DISMOUNTED 0 DATA DISMOUNTED 0 RECOVER DISMOUNTED故障原因： [oracle@aix213 dbs]$lsvg -l asmvgasmvg:LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINTlv_data1 jfs 64 64 1 open/syncd N/Alv_data2 jfs 64 64 1 open/syncd N/Aasmredo2 jfs 32 32 1 open/syncd N/A[oracle@aix213 dbs]$lspvhdisk1 00c6d0ef0395eef2 rootvg activehdisk0 0006816a72287441 asmvg active应该是在AIX的ODM中，rlv_data1和rlv_data2，已经属于另外的磁盘组。解决方法：1）清理raw头部信息[root@aix213 /]#dd if=/dev/zero of=/dev/rlv_data1 bs=8k count=256256+0 records in256+0 records out[root@aix213 /]#dd if=/dev/zero of=/dev/rlv_data2 bs=8k count=256256+0 records in256+0 records out
2）重新建立ASM DISKGROUP[oracle@aix213 dbs]$sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Thu Jul 24 11:44:29 2014Copyright （c） 1982, 2005, Oracle. All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP and Data Mining optionsSQL> select name ,state from v$asm_diskgroup;NAME STATE------------------------------ -----------REDO DISMOUNTEDARCH DISMOUNTED清理raw头部信息后data和recover diskgroup自动被删除！SQL> create diskgroup datafile 2 normal redundancy 3 failgroup fg1 disk "/dev/rlv_data1" 4 failgroup fg2 disk "/dev/rlv_data2";Diskgroup created.磁盘组创建成功！
3）验证SQL> select name ,state from v$asm_diskgroup;NAME STATE------------------------------ -----------REDO DISMOUNTEDARCH DISMOUNTEDDATAFILE MOUNTEDSQL> alter diskgroup redo mount;Diskgroup altered.SQL> alter diskgroup arch mount;Diskgroup altered.SQL> select name ,state from v$asm_diskgroup;NAME STATE------------------------------ -----------REDO MOUNTEDARCH MOUNTEDDATAFILE MOUNTED
@至此，问题被解决！在CentOS 6.4下安装Oracle 11gR2（x64） http://www.linuxidc.com/Linux/2014-02/97374.htmOracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htmDebian 下安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htmOracle 11g从入门到精通 PDF+光盘源代码 http://www.linuxidc.com/Linux/2013-06/85670.htmRHEL6 ASM方式安装Oracle 11g R2 http://www.linuxidc.com/Linux/2013-06/86002.htmOracle 10g 手工创建ASM数据库 http://www.linuxidc.com/Linux/2013-01/78229.htmOracle 10g R2创建ASM实例Step By Step http://www.linuxidc.com/Linux/2014-05/101821.htm更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12本文永久更新链接地址