- 最后登录
- 2014-3-2
- 在线时间
- 7 小时
- 威望
- 0
- 金钱
- 48
- 注册时间
- 2013-4-2
- 阅读权限
- 10
- 帖子
- 14
- 精华
- 0
- 积分
- 0
- UID
- 1002
|
1#
发表于 2014-3-2 14:22:38
|
查看: 2305 |
回复: 1
本帖最后由 lonnyhe 于 2014-3-2 14:24 编辑
[grid@gpsdb ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on Sun Mar 2 14:08:00 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
SQL> select GROUP_NUMBER,name,DISK_NUMBER,MOUNT_STATUS,HEADER_STATUS,STATE,LABEL,PATH from v$asm_disk;
GROUP_NUMBER NAME DISK_NUMBER MOUNT_S HEADER_STATU STATE LABEL PATH
------------ -------------------- ----------- ------- ------------ -------- ------------------------------- ------------------------------
0 0 CLOSED MEMBER NORMAL /dev/mapper/disk5p1
0 1 CLOSED MEMBER NORMAL /dev/mapper/disk4p1
0 2 CLOSED MEMBER NORMAL /dev/mapper/disk3p1
0 3 CLOSED MEMBER NORMAL /dev/mapper/disk2p1
1 ARC_0000 0 CACHED MEMBER NORMAL /dev/mapper/disk6p1
SQL> select name,state from v$asm_diskgroup;
NAME STATE
-------------------- -----------
DATA DISMOUNTED
ARC MOUNTED
SQL>
SQL> alter diskgroup DATA mount;
alter diskgroup DATA mount
*
ERROR at line 1:
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>
附件2.txt 3.txt 4.txt 5.txt 是通过kfed read 读取的信息。
kfed read /dev/mapper/disk2p1 > 2.txt
kfed read /dev/mapper/disk3p1 > 3.txt
kfed read /dev/mapper/disk4p1 > 4.txt
kfed read /dev/mapper/disk5p1 > 5.txt
老大帮忙看看是怎么回事?
|
|