Oracle ASM错误之--ORA-15033

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

@至此,问题被解决 !


本文出自 “天涯客的blog” 博客,请务必保留此出处http://tiany.blog.51cto.com/513694/1529597

Oracle ASM错误之--ORA-15033,布布扣,bubuko.com

Oracle ASM错误之--ORA-15033

上一篇:Python菜鸟之路:Python基础-类(2)——成员、成员修饰符、异常及其他


下一篇:Chapter 1 Securing Your Server and Network(6):为SQL Server访问配置防火墙