Oracle ASM錯誤之--ORA-15033

標籤：oracle

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

故障原因：  

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

應該是在AIX的ODM中，rlv_data1和rlv_data2，已經屬於另外的磁碟組。

解決方案：

1）清理raw頭部資訊

[[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）重建立立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清理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                           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

@至此，問題被解決 ！

本文出自 “天涯客的blog” 部落格，請務必保留此出處http://tiany.blog.51cto.com/513694/1529597