ORA-15024 discovered duplicately numbered ASM disk %s

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638    QQ号:47079569    邮箱:service@parnassusdata.com

 

适用于:

Oracle Database – 企业版 – 版本10.2.0.4及以后
本文献的信息适用于任何平台

症状

改变磁盘组 FLASHBACK_WPRSA004安装
*
第1行的错误:
alter diskgroup FLASHBACK_WPRSA004 mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15024: discovered duplicately numbered ASM disk 0

注意磁盘组不自动安装。

原因

在重启期间复制发现的磁盘,于是,安装磁盘组失败

解决方法

需要完成下列故障排除步骤以解决复制问题。

1) 上一次dg#17(FLASHBACK_WPRSA004)成功安装, 它使用1磁盘:

alert__ASM1.log:
~~~~~~~~~~~~~~

Fri Jul 18 11:15:00 2014
启动ORACLE实例(正常)
sskgpgetexecname 获取内容失败
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
警告: 没有指定群集互联,根据通信驱动器配置的Oracle集群流量,可向本机的公共接口,Oracle建议RAC集群数据库与专用互连以增强安全性和性能进行配置。
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as /orabase/app/oracle/product/10.2/dbs/arch
Autotune of undo retention is turned off.
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.4.0.
System parameters with non-default values:
large_pool_size          = 12582912
instance_type            = asm
cluster_database         = TRUE
instance_number          = 1
remote_login_passwordfile= EXCLUSIVE
background_dump_dest     = /dst/db/oracle/admin/+ASM/bdump
user_dump_dest           = /dst/db/oracle/admin/+ASM/udump
core_dump_dest           = /dst/db/oracle/admin/+ASM/cdump
asm_diskstring           = /dev/asm*
asm_diskgroups           = ARCHIVE_WPRSA001, CONTROLFILE_WPRSA001, DATA001_WPRSA001, FLASHBACK_WPRSA001, DATA001_WPRSA002, ARCHIVE_WPRSA002,
FLASHBACK_WPRSA002, CONTROLFILE_WPRSA002, CONTROLFILE_WPRSA003, DATA001_WPRSA003, FLASHBACK_WPRSA003,
CONTROLFILE_WPRSA004, DATA001_WPRSA004, FLASHBACK_WPRSA004, ARCHIVE_WPRSA003, ARCHIVE_WPRSA004, DATA002_WPRSA003

Fri Jul 18 11:15:07 2014
SQL> ALTER DISKGROUP ALL MOUNT
Fri Jul 18 11:15:08 2014
NOTE: cache registered group ARCHIVE_WPRSA001 number=1 incarn=0x4b8022de
NOTE: cache registered group ARCHIVE_WPRSA002 number=2 incarn=0x4b9022df
NOTE: cache registered group ARCHIVE_WPRSA003 number=3 incarn=0x4b9022e0
NOTE: cache registered group ARCHIVE_WPRSA004 number=4 incarn=0x4b9022e1
NOTE: cache registered group CONTROLFILE_WPRSA001 number=5 incarn=0x4b9022e2
NOTE: cache registered group CONTROLFILE_WPRSA002 number=6 incarn=0x4ba022e3
NOTE: cache registered group CONTROLFILE_WPRSA003 number=7 incarn=0x4ba022e4
NOTE: cache registered group CONTROLFILE_WPRSA004 number=8 incarn=0x4ba022e5
NOTE: cache registered group DATA001_WPRSA001 number=9 incarn=0x4bb022e6
NOTE: cache registered group DATA001_WPRSA002 number=10 incarn=0x4bb022e7
NOTE: cache registered group DATA001_WPRSA003 number=11 incarn=0x4bb022e8
NOTE: cache registered group DATA001_WPRSA004 number=12 incarn=0x4bc022e9
NOTE: cache registered group DATA002_WPRSA003 number=13 incarn=0x4bc022ea
NOTE: cache registered group FLASHBACK_WPRSA001 number=14 incarn=0x4bc022eb
NOTE: cache registered group FLASHBACK_WPRSA002 number=15 incarn=0x4bd022ec
NOTE: cache registered group FLASHBACK_WPRSA003 number=16 incarn=0x4bd022ed
NOTE: cache registered group FLASHBACK_WPRSA004 number=17 incarn=0x4bd022ee          <—————— HERE (dg#17 or FLASHBACK_WPRSA004)

Fri Jul 18 11:15:19 2014

NOTE: cache opening disk 0 of grp 17: FLASHBACK_WPRSA004_0000 path:/dev/asm_v4042_01_asmflsh4a    <—– Only 1 disk

Fri Jul 18 11:15:20 2014
NOTE: cache mounting group 17/0x4BD022EE (FLASHBACK_WPRSA004) succeeded
SUCCESS: diskgroup FLASHBACK_WPRSA004 was mounted                                                       <—————— Jul.18 11:15 (last time the dg#17 mounted successfully)

2) 现在,无法mount diskgroup

alert__ASM1.log:
~~~~~~~~~~~~~~

Mon Aug 25 11:41:50 2014
Starting ORACLE instance (normal)
sskgpgetexecname failed to get name
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
警告: 没有指定群集互联,根据通信驱动器配置的Oracle集群流量,可向本机的公共接口,Oracle建议RAC集群数据库与专用互连以增强安全性和性能进行配置。
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as /orabase/app/oracle/product/10.2/dbs/arch
Autotune of undo retention is turned off.
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.4.0.
System parameters with non-default values:
large_pool_size          = 12582912
instance_type            = asm
cluster_database         = TRUE
instance_number          = 1
remote_login_passwordfile= EXCLUSIVE
background_dump_dest     = /dst/db/oracle/admin/+ASM/bdump
user_dump_dest           = /dst/db/oracle/admin/+ASM/udump
core_dump_dest           = /dst/db/oracle/admin/+ASM/cdump
asm_diskstring           = /dev/asm*
asm_diskgroups           = ARCHIVE_WPRSA001, CONTROLFILE_WPRSA001, DATA001_WPRSA001, FLASHBACK_WPRSA001, DATA001_WPRSA002, ARCHIVE_WPRSA002,
FLASHBACK_WPRSA002, CONTROLFILE_WPRSA002, CONTROLFILE_WPRSA003, DATA001_WPRSA003, FLASHBACK_WPRSA003,
CONTROLFILE_WPRSA004, DATA001_WPRSA004, FLASHBACK_WPRSA004, ARCHIVE_WPRSA003, ARCHIVE_WPRSA004, DATA002_WPRSA003

Mon Aug 25 11:41:52 2014
SQL> ALTER DISKGROUP ALL MOUNT
Mon Aug 25 11:41:52 2014
NOTE: cache registered group ARCHIVE_WPRSA001 number=1 incarn=0xb7d45ac3
NOTE: cache registered group ARCHIVE_WPRSA002 number=2 incarn=0xb8245ac4
NOTE: cache registered group ARCHIVE_WPRSA003 number=3 incarn=0xb8245ac5
NOTE: cache registered group ARCHIVE_WPRSA004 number=4 incarn=0xb8245ac6
NOTE: cache registered group CONTROLFILE_WPRSA001 number=5 incarn=0xb8245ac7
NOTE: cache registered group CONTROLFILE_WPRSA002 number=6 incarn=0xb8245ac8
NOTE: cache registered group CONTROLFILE_WPRSA003 number=7 incarn=0xb8245ac9
NOTE: cache registered group CONTROLFILE_WPRSA004 number=8 incarn=0xb8245aca
NOTE: cache registered group DATA001_WPRSA001 number=9 incarn=0xb8245acb
NOTE: cache registered group DATA001_WPRSA002 number=10 incarn=0xb8245acc
NOTE: cache registered group DATA001_WPRSA003 number=11 incarn=0xb8345acd
NOTE: cache registered group DATA001_WPRSA004 number=12 incarn=0xb8345ace
NOTE: cache registered group DATA002_WPRSA003 number=13 incarn=0xb8345acf
NOTE: cache registered group FLASHBACK_WPRSA001 number=14 incarn=0xb8345ad0
NOTE: cache registered group FLASHBACK_WPRSA002 number=15 incarn=0xb8345ad1
NOTE: cache registered group FLASHBACK_WPRSA003 number=16 incarn=0xb8345ad2
NOTE: cache registered group FLASHBACK_WPRSA004 number=17 incarn=0xb8345ad3                     <——————– diskgroup under review

NOTE: cache dismounting group 17/0xB8345AD3 (FLASHBACK_WPRSA004)
NOTE: dbwr not being msg’d to dismount
ERROR: diskgroup FLASHBACK_WPRSA004 was not mounted                                                               <——————- HERE (it cannot mount)

Mon Aug 25 15:31:45 2014
SQL> alter diskgroup FLASHBACK_WPRSA004 mount
Mon Aug 25 15:31:45 2014
NOTE: cache registered group FLASHBACK_WPRSA004 number=9 incarn=0x77145b62
NOTE: cache dismounting group 9/0x77145B62 (FLASHBACK_WPRSA004)
NOTE: dbwr not being msg’d to dismount
ERROR: diskgroup FLASHBACK_WPRSA004 was not mounted                                                                <——————- HERE (it cannot mount upon demand)

3) 从’ASM_GENERIC_ASM_METADATA.html’,我们看到没有安装任何磁盘组,asm 发现了多少磁盘,什么是它们的v$asm_disk.HEADER_STATUS:

* THIS ASM REPORT WAS GENERATED AT: ==)>     29-AUG-2014 15:19:51
* INSTANCE NAME: ==)>     +ASM1
* HOSTNAME ASSOCIATED WITH THIS ASM INSTANCE: ==)>     rc-aixdb-18
* v$asm_diskgroup:   <—- 9 listed (including FLASHBACK_WPRSA004) and all STATE=DISMOUNTED
* v$asm_disk:        <—— 17 listed (all dismounted ie, all listed under dg#0)
– 7 disks: header_status=CANDIDATE
– 10 disks: header_status=MEMBER (includes ‘/dev/asm_v4042_01_asmflsh4a’)
* v$asm_operation:   <— no rows selected
* OTHER:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bi
asm_diskgroups       ARCHIVE_WPRSA001,CONTROLFILE_WPRSA001,DATA001_WPRSA001,FLASHBACK_WPRSA001,DATA001_WPRSA002,ARCHIVE_WPRSA002,
FLASHBACK_WPRSA002,CONTROLFILE_WPRSA002,CONTROLFILE_WPRSA003,DATA001_WPRSA003,FLASHBACK_WPRSA003,CONTROLFILE_WPRSA004,
DATA001_WPRSA004,FLASHBACK_WPRSA004,ARCHIVE_WPRSA003,ARCHIVE_WPRSA004,DATA002_WPRSA003
asm_diskstring         /dev/asm*
asm_power_limit         1
cluster_database         TRUE
instance_name           +ASM1
instance_type         asm
spfile

4) Kfed显示dg#17 (或 FLASHBACK_WPRSA004)的复制磁盘

kfed_DH.out:
~~~~~~~~~~~
/dev/asm_v4000_01_asmcntr1a   –> kfbh.type:                            0 ; 0x002: KFBTYP_INVALID
/dev/asm_v4000_01_asmcntr2a   –> kfbh.type:                            0 ; 0x002: KFBTYP_INVALID
/dev/asm_v4042_01_asmarch2a  –> kfbh.type:                            0 ; 0x002: KFBTYP_INVALID
/dev/asm_v4042_01_asmflsh1a   –> kfbh.type:                            0 ; 0x002: KFBTYP_INVALID
/dev/asm_v4042_01_asmflsh2a   –> kfbh.type:                            0 ; 0x002: KFBTYP_INVALID
/dev/asm_v4042_02_asmdata1a  –> kfbh.type:                            0 ; 0x002: KFBTYP_INVALID
/dev/asm_v4042_02_asmdata2a  –> kfbh.type:                            0 ; 0x002: KFBTYP_INVALID
/dev/asm_v4000_01_asmcntr3a   –> kfdhdb.dskname:CONTROLFILE_WPRSA003_0000 ; 0x028: length=25
/dev/asm_v4000_01_asmcntr4a   –> kfdhdb.dskname:CONTROLFILE_WPRSA004_0000 ; 0x028: length=25
/dev/asm_v4042_01_asmarch3a  –> kfdhdb.dskname:   ARCHIVE_WPRSA003_0000 ; 0x028: length=21
/dev/asm_v4042_01_asmarch4a  –> kfdhdb.dskname:   ARCHIVE_WPRSA004_0000 ; 0x028: length=21
/dev/asm_v4042_01_asmflsh3a   –> kfdhdb.dskname: FLASHBACK_WPRSA003_0000 ; 0x028: length=23
/dev/asm_v4042_01_asmflsh4a   –> kfdhdb.dskname: FLASHBACK_WPRSA004_0000 ; 0x028: length=23      <——– HERE
/dev/asm_v4042_02_asmarch1a  –> kfdhdb.dskname: FLASHBACK_WPRSA004_0000 ; 0x028: length=23      <——– HERE
/dev/asm_v4042_02_asmdata3a  –> kfdhdb.dskname:   DATA001_WPRSA003_0000 ; 0x028: length=21
/dev/asm_v4042_02_asmdata4a  –> kfdhdb.dskname:   DATA001_WPRSA004_0000 ; 0x028: length=21
/dev/asm_v503c_01_asmdata1a  –> kfdhdb.dskname:   DATA002_WPRSA003_0000 ; 0x028: length=21

5) ASM不能容忍不止一次发现相同的磁盘。
所以, 请要么移动复制设备/磁盘,要么改变它们的拥有者:OS 组和文件限制到ASM不能访问(rw)的地方。

关注dbDao.com的新浪微博

扫码关注dbDao.com 微信公众号:

沪公网安备 31010802001379号

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569