Oracle ASM错误之--ORA-15033

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

本文永久更新链接地址：