Oracle ASM错误之--ORA-15033 系统环境： 操作系统： AIX 5.3.8 Oracle： Oracle 10gR2 故障现象： SQLgt; create diskgroup
Oracle ASM错误之--ORA-15033
系统环境：
操作系统： AIX 5.3.8
Oracle： 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 created
ORA-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 asmvg
asmvg:
LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT
lv_data1 jfs 64 64 1 open/syncd N/A
lv_data2 jfs 64 64 1 open/syncd N/A
asmredo2 jfs 32 32 1 open/syncd N/A
[oracle@aix213 dbs]$lspv
hdisk1 00c6d0ef0395eef2 rootvg active
hdisk0 0006816a72287441 asmvg active
应该是在AIX的ODM中，，rlv_data1和rlv_data2，已经属于另外的磁盘组。
解决方法：
1）清理raw头部信息
[root@aix213 /]#dd if=/dev/zero of=/dev/rlv_data1 bs=8k count=256
256 0 records in
256 0 records out
[root@aix213 /]#dd if=/dev/zero of=/dev/rlv_data2 bs=8k count=256
256 0 records in
256 0 records out
2）重新建立ASM DISKGROUP
[oracle@aix213 dbs]$sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jul 24 11:44:29 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> select name ,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
REDO DISMOUNTED
ARCH 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 DISMOUNTED
ARCH DISMOUNTED
DATAFILE MOUNTED
SQL> alter diskgroup redo mount;
Diskgroup altered.
SQL> alter diskgroup arch mount;
Diskgroup altered.
SQL> select name ,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
REDO MOUNTED
ARCH MOUNTED
DATAFILE MOUNTED
@至此，问题被解决 ！
在CentOS 6.4下安装Oracle 11gR2(x64)
Oracle 11gR2 在VMWare虚拟机中安装步骤
Debian 下 安装 Oracle 11g XE R2
Oracle 11g从入门到精通 PDF 光盘源代码
RHEL6 ASM方式安装Oracle 11g R2
Oracle 10g 手工创建ASM数据库
Oracle 10g R2创建ASM实例Step By Step
本文永久更新链接地址：
