Oracle ASM Error--ora-15033

Oracle ASM Error--ora-15033

System environment:

Operating system: AIX 5.3.8

Oracle:oracle 10GR2

Symptom:

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

cause of failure:  

[[Email protected] 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[[email protected] dbs] $LSPV  hdisk1           00c6d0ef0395eef2                     rootvg           activehdisk0           0006816a72287441                     asmvg           active

It should be in the ODM of Aix, Rlv_data1 and Rlv_data2, already belong to another disk group.

Workaround:

1) Clean Raw header information

[[email protected]/] #dd if=/dev/zero of=/dev/rlv_data1 bs=8k count=256256+0 records in256+0 Records Out[[email protected ]/] #dd if=/dev/zero of=/dev/rlv_data2 bs=8k count=256256+0 Records in256+0 Records out

2) Re-establish ASM DiskGroup

[[Email protected] 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 data and Recover diskgroup are automatically deleted after cleaning raw header information  ! sql> create diskgroup datafile  2      normal  redundancy  3      failgroup fg1 disk  '/dev/rlv_data1 '   4    failgroup fg2 disk  '/dev/rlv_data2 ';D iskgroup  Created. Disk group creation succeeded  !

3) Verify

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

@ At this point, the problem is solved!

This article is from the "Tianya blog," Please make sure to keep this source http://tiany.blog.51cto.com/513694/1529597