诗檀软件专业数据库修复团队
适用于:
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)的地方。