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