Oracle ASM錯誤之--ORA-15033

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

@至此，問題被解決 ！

在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