如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!
诗檀软件专业数据库修复团队
服务热线 : 13764045638 QQ号:47079569 邮箱:service@parnassusdata.com
适用于:
Oracle Database – Enterprise Edition –版本11.2.0.1 及以上
本文信息适用于任何平台。
*** 11-May-2014检查相关性***
症状
2 node RAC – 11201 – Solaris10
ASM 不mount ASM 磁盘组,因为它发现磁盘不足。由于OCR磁盘储存在ASM中,这防止Oracle集群件的CRS 启动:
alert__ASM1.log:
~~~~~~~~~~~~~
…
Fri Oct 19 13:09:35 2012
NOTE: No asm libraries found in the system
ERROR: -5(Duplicate disk DATA:DATA_0000) <———– Notice this entry as it tells that ASM discovers duplicate disk (1)
* instance_number obtained from CSS = 1, checking for the existence of node 0…
* node 0 does not exist. instance_number = 1
Starting ORACLE instance (normal)
…
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options.
WARNING: using default parameter settings without any parameter file <—————- not using a pfile/spfile (1)
…
Fri Oct 19 13:09:44 2012
SQL> ALTER DISKGROUP ALL MOUNT /* asm agent */
NOTE: Diskgroup used for Voting files is:
DATASOA
Diskgroup used for OCR is:DATA
Diskgroup used for OCR is:DATASOA
NOTE: cache registered group DATASOA number=1 incarn=0xa9eb204b
NOTE: cache registered group DATA number=2 incarn=0xaa0b204c
ERROR: no PST quorum in group: required 2, found 0 <——- ASM disk discovery problem
…
NOTE: cache ending mount (fail) of group DATASOA number=1 incarn=0xa9eb204b
…
ERROR: diskgroup DATASOA was not mounted <——— Therefore ASM disk groups do not mount
…
NOTE: cache ending mount (fail) of group DATA number=2 incarn=0xaa0b204c
…
ERROR: diskgroup DATA was not mounted
…
WARNING: Disk Group DATASOA containing configured OCR is not mounted
WARNING: Disk Group DATASOA containing voting files is not mounted
WARNING: Disk Group DATA containing configured OCR is not mounted
ORA-15032: not all alterations performed
ORA-15017: diskgroup “DATA” cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup “DATA” <—- ASM discovers not sufficient disks
ORA-15017: diskgroup “DATASOA” cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup “DATASOA”
(1) 这些条目与 Note:1384692.1类似
原因
但是,问题不是ASM未发现所有磁盘,而是发现重复的磁盘 (即,ASM不是仅发现了5个所需的ASM磁盘,而是发现了两倍,即10个磁盘。)
当ASM不止一次发现了同一磁盘 ,它会忽略条目(v$asm_disk.mount_status=IGNORED),所以就像是发现了不足的磁盘。
因此,ASM警报日志在实例启动序列时显示条目”ERROR: -5(Duplicate disk …” 并在之后显示磁盘不足的错误(ORA-15063)。
.
解决方案ION
注:发现重复磁盘取决于所使用的平台。
在这个情况下 (Solaris),需要进行以下操作识别重复设备:
* 根据以前mount 所有ASM磁盘组的ASM警报日志条目的成功尝试,需要以下ASM磁盘:
NOTE: cache registered group DATASOA number=1 incarn=0xa9eac7b8
NOTE: cache registered group DATA number=2 incarn=0xaa0ac7b9
NOTE: Assigning number (1,0) to disk (/oracle_crs_install/shr_disk_links/ora_dbdsk1) <— 4 disks for DATASOA
NOTE: Assigning number (1,2) to disk (/oracle_crs_install/shr_disk_links/ora_dbdsk2)
NOTE: Assigning number (1,3) to disk (/oracle_crs_install/shr_disk_links/ora_dbdsk3)
NOTE: Assigning number (1,1) to disk (/oracle_crs_install/shr_disk_links/ora_dbdsk4)
NOTE: Assigning number (2,0) to disk (/dev/rdsk/c0t60050768018105880000000000000023d0s6) <— 1 disk for DATA
* The Grid-plug-and-play profile or <Grid Infrastructure Home>/gpnp/<hostname>/profiles/peer/profile.xml, lists the disk discovery string that will be used (along with the spfile that will be use):
DiscoveryString=”/oracle_crs_install/shr_disk_links/ora_dbdsk*,/dev/rdsk/c*23d0s6″ SPFile=”+DATA/wlsoadbt1-clust/asmparameterfile/registry.253.778542929″
* From the above, it was found that ASM was discovering It was found that
/dev/rdsk/c0t60050768018105880000000000000035d0s6 <– dupl
/dev/rdsk/c0t60050768018105880000000000000034d0s6 <– dupl
/dev/rdsk/c0t60050768018105880000000000000033d0s6 <– dupl
/dev/rdsk/c0t60050768018105880000000000000032d0s6 <– dupl
/dev/rdsk/c0t60050768018105880000000000000038d0s6 <– dupl
/dev/rdsk/c0t60050768018105880000000000000023d0s6
/oracle_crs_install/shr_disk_links/ora_dbdsk1
/oracle_crs_install/shr_disk_links/ora_dbdsk2
/oracle_crs_install/shr_disk_links/ora_dbdsk3
/oracle_crs_install/shr_disk_links/ora_dbdsk4
* 由于重复磁盘被识别并分离,请更改它们的设备所有者:以ASM不再发现(访问)它们的方式更改组或文件权限。
ASM可以容忍每个ASM磁盘只发现一次(不超过一次,否则会被认为是“重复的磁盘”,就可能会遇到这种情况。
参考
NOTE:1384692.1 – ASM Spfile Is Not Used when ASM Instance Starts Even It Exists Inside of OCR Diskgroup (11.2)
Comment