wonder

45 积分	0 好友	3 主题

发消息

ASM磁盘挂载不上

1^#

发表于 2012-5-15 14:35:50 | 查看: 6239| 回复: 2

RHEL5.4  GI 11.2.0.1

[root@slave ~]# /etc/init.d/oracleasm listdisks
VOLB
VOLC
VOLD

[root@slave ~]# cat /proc/partitions
major minor  #blocks  name
8    0 31457280 sda
8    1    200781 sda1
8    2 10241437 sda2
8    3 2096482 sda3
8    4 18916537 sda4
8 16 20971520 sdb
8 17 20964793 sdb1
8 32 20971520 sdc
8 33 20964793 sdc1
8 48 20971520 sdd
8 49 20964793 sdd1

[root@slave ~]# ll /dev/oracleasm/disks/
总计 0
brw-rw---- 1 grid asmadmin 8, 17 05-15 13:54 VOLB
brw-rw---- 1 grid asmadmin 8, 33 05-15 13:54 VOLC
brw-rw---- 1 grid asmadmin 8, 49 05-15 13:55 VOLD

[grid@slave dbs]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.1.0 Production on Tue May 15 14:11:21 2012
Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Automatic Storage Management option
SQL> shutdown immediate
ORA-15100: invalid or missing diskgroup name

ASM instance shutdown
SQL> startup
ASM instance started
Total System Global Area  284565504 bytes
Fixed Size    1336036 bytes
Variable Size 258063644 bytes
ASM Cache    25165824 bytes
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"

SQL> SELECT GROUP_NUMBER, DISK_NUMBER, MOUNT_STATUS, HEADER_STATUS, PATH FROM V$ASM_DISK;
GROUP_NUMBER DISK_NUMBER MOUNT_S HEADER_STATU PATH
------------ ----------- ------- ------------ --------------------
0       0 CLOSED  PROVISIONED  /dev/oracleasm/disks
         /VOLD
0       2 CLOSED  PROVISIONED  /dev/oracleasm/disks
         /VOLB
0       1 CLOSED  PROVISIONED  /dev/oracleasm/disks
         /VOLC

alter日志：
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Automatic Storage Management option.
Using parameter settings in server-side pfile /u02/app/grid/dbs/init+ASM.ora
System parameters with non-default values:
  large_pool_size       = 12M
  instance_type          = "asm"
  remote_login_passwordfile= "EXCLUSIVE"
  asm_diskstring          = "/dev/oracleasm/disks/VOL*"
  asm_diskgroups          = "DATA"
  asm_power_limit       = 1
  diagnostic_dest       = "/u02/app/grid"
Tue May 15 14:13:14 2012
PMON started with pid=2, OS id=31320
Tue May 15 14:13:14 2012
VKTM started with pid=3, OS id=31322 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Tue May 15 14:13:14 2012
GEN0 started with pid=4, OS id=31326
Tue May 15 14:13:14 2012
DIAG started with pid=5, OS id=31328
Tue May 15 14:13:14 2012
PSP0 started with pid=6, OS id=31330
Tue May 15 14:13:14 2012
DIA0 started with pid=7, OS id=31332
Tue May 15 14:13:14 2012
MMAN started with pid=8, OS id=31334
Tue May 15 14:13:14 2012
DBW0 started with pid=9, OS id=31336
Tue May 15 14:13:15 2012
LGWR started with pid=10, OS id=31338
Tue May 15 14:13:15 2012
CKPT started with pid=11, OS id=31340
Tue May 15 14:13:15 2012
SMON started with pid=12, OS id=31342
Tue May 15 14:13:15 2012
RBAL started with pid=13, OS id=31344
Tue May 15 14:13:15 2012
GMON started with pid=14, OS id=31346
Tue May 15 14:13:15 2012
MMON started with pid=15, OS id=31348
Tue May 15 14:13:15 2012
MMNL started with pid=16, OS id=31350
ORACLE_BASE from environment = /u02/app
Tue May 15 14:13:15 2012
SQL> ALTER DISKGROUP ALL MOUNT
NOTE: Diskgroups listed in ASM_DISKGROUPS are
DATA
NOTE: cache registered group DATA number=1 incarn=0xe7ba2e3a
NOTE: cache began mount (first) of group DATA number=1 incarn=0xe7ba2e3a
NOTE: Loaded library: /opt/oracle/extapi/32/asm/orcl/1/libasm.so
ERROR: no PST quorum in group: required 2, found 0
NOTE: cache dismounting (clean) group 1/0xE7BA2E3A (DATA)
NOTE: dbwr not being msg'd to dismount
NOTE: lgwr not being msg'd to dismount
NOTE: cache dismounted group 1/0xE7BA2E3A (DATA)
NOTE: cache ending mount (fail) of group DATA number=1 incarn=0xe7ba2e3a
kfdp_dismount(): 2
kfdp_dismountBg(): 2
ERROR: diskgroup DATA was not mounted
NOTE: cache deleting context for group DATA 1/-407228870
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"
ERROR: ALTER DISKGROUP ALL MOUNT

刘大，帮忙看看，谢了

[ 本帖最后由 wonder 于 2012-5-15 14:46 编辑 ]

分享0