Oracle ASM errors-ORA-15033

Oracle ASM errors-ORA-15033

Oracle ASM errors-ORA-15033

System Environment:

Operating System: AIX 5.3.8

Oracle: Oracle 10gR2

Fault 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 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

Fault Cause:

[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/

Lv_data2 jfs 64 64 1 open/syncd N/

Asmredo2 jfs 32 32 1 open/syncd N/

[Oracle @ aix213 dbs] $ lspv

Hdisk1 00c6d0ef0395eef2 rootvg active

Hdisk0 0006816a72287441 asmvg active

It should be in the ODM of AIX. rlv_data1 and rlv_data2 already belong to another disk group.

Solution:

1) Clear raw header information

[Root @ aix213/] # dd if =/dev/zero of =/dev/rlv_data1 bs = 8 k count = 256

256 + 0 records in

256 + 0 records out

[Root @ aix213/] # dd if =/dev/zero of =/dev/rlv_data2 bs = 8 k count = 256

256 + 0 records in

256 + 0 records out

2) recreate the 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,200 5, Oracle. All rights reserved.

Connected:

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

After raw header information is cleared, data and recover diskgroup are automatically deleted!

SQL> create diskgroup datafile

2 normal redundancy

3 failgroup fg1 disk '/dev/rlv_data1'

4 failgroup fg2 disk '/dev/rlv_data2 ';

Diskgroup created.

The disk group is created successfully!

3) Verification

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

@ Now, the problem is solved!

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

Oracle 11g from entry to proficient in PDF + CD source code

Installing Oracle 11g R2 using RHEL6 ASM

Oracle 10g manual creation of the ASM Database

Oracle 10g R2 create ASM instance Step By Step