Oracle ASM错误之--ORA-15033
来源:互联网 发布:丹尼格兰杰数据 编辑:程序博客网 时间:2024/05/21 04:34
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
故障原因:
[oracle@aix213 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[oracle@aix213 dbs]$lspv hdisk1 00c6d0ef0395eef2 rootvg activehdisk0 0006816a72287441 asmvg active
应该是在AIX的ODM中,rlv_data1和rlv_data2,已经属于另外的磁盘组。
解决方法:
1)清理raw头部信息
[root@aix213 /]#dd if=/dev/zero of=/dev/rlv_data1 bs=8k count=256256+0 records in256+0 records out[root@aix213 /]#dd if=/dev/zero of=/dev/rlv_data2 bs=8k count=256256+0 records in256+0 records out
2)重新建立ASM DISKGROUP
[oracle@aix213 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
0 0
- Oracle ASM错误之--ORA-15033
- Oracle ASM错误之--ORA-15031、ORA-15014
- Oracle 10g手工建立ASM磁盘组错误之--ORA-15201
- Oracle 10g手工建立ASM磁盘组错误之--ORA-15106
- Oracle 10g手工建立ASM磁盘组错误之--ORA-15201
- dbca asm ora 01017错误
- 常见Oracle错误之ORA-01102错误
- Oracle Study之--Oracle 11gR2访问ASM diskgroup错误
- Oracle GoldenGate 系列:使用 Oracle ASM API DBLOGREADER 时遇 ora-01031 错误
- Oracle+RAC+ASM数据库ora-00257日志归档器错误解决方法
- oracle 12c rac GRID for linux安装错误CLSRSC-258+ASM启动ora-00854
- Oracle 11g RAC ASM 错误之(1)
- ASM:ORA-15063 错误处理方法一则
- ASM添加磁盘时报 ORA-15020错误
- ORA-15196 ORACLE ASM问题详解
- ORA-15196 ORACLE ASM问题详解
- oracle ASM实例ORA-04031故障处理
- ORACLE之ASM配置
- Solaris 10下有趣的FTP错误--ROOT不能访问FTP
- 爬山为什么要穿登山鞋
- Unix系统性能监控工具之--SAR
- Oracle 学习之--Buffer Cache深入解析
- Oracle ASM错误之--ORA-15031、ORA-15014
- Oracle ASM错误之--ORA-15033
- Oracle Study之--Oracle等待事件(1)
- Oracle非归档模式Media Recovery错误之--ORA-26040
- Oracle Study之--Oracle等待事件(2)
- Oracle Study之--Oracle等待事件(3)
- Oracle Study之--Oracle等待事件(4)
- Oracle Study之--Oracle等待事件(5)
- AIX HACMP系统错误--NODE同步配置错误
- AIX RAC构建错误之--未配置Default Gateway