- 最后登录
- 2013-5-8
- 在线时间
- 4 小时
- 威望
- 0
- 金钱
- 14
- 注册时间
- 2013-3-18
- 阅读权限
- 10
- 帖子
- 5
- 精华
- 0
- 积分
- 0
- UID
- 985
|
1#
发表于 2013-3-22 13:47:22
|
查看: 2053 |
回复: 1
首先我怀疑是由于节点1由于长期处于关机状态,data2磁盘组信息没有同步,而导致data2磁盘组装载不成功,还请大师指点。
--节点1:
[grid@3850rac1 raw]$ uname -a
Linux 3850rac1 2.6.32-71.el6.x86_64 #1 SMP Wed Sep 1 01:33:01 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux
[grid@3850rac1 raw]$
[grid@3850rac1 raw]$
[grid@3850rac1 raw]$ ps -ef | grep pmon
grid 6829 1 0 Mar11 ? 00:04:17 asm_pmon_+ASM1
oracle 7237 1 0 Mar11 ? 00:07:43 ora_pmon_Indepdb1
grid 62338 50801 0 13:41 pts/0 00:00:00 grep pmon
[grid@3850rac1 raw]$
[grid@3850rac1 raw]$
[grid@3850rac1 raw]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Fri Mar 22 13:41:12 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> conn / as sysasm
Connected.
SQL> select GROUP_NUMBER,NAME,STATE from v$asm_diskgroup;
GROUP_NUMBER NAME STATE
------------ ------------------------------------------------------------ ----------------------
0 DATA2 DISMOUNTED
1 DATA MOUNTED
SQL> select name,path from v$asm_disk;
NAME PATH
------------------------------------------------------------ ------------------------------
/dev/raw/raw5
/dev/raw/raw4
DATA_0009 /dev/raw/raw9
DATA_0001 /dev/raw/raw11
DATA_0005 /dev/raw/raw15
DATA_0002 /dev/raw/raw12
DATA_0000 /dev/raw/raw10
DATA_0007 /dev/raw/raw6
DATA_0004 /dev/raw/raw14
DATA_0003 /dev/raw/raw13
DATA_0008 /dev/raw/raw8
DATA_0006 /dev/raw/raw3
[grid@3850rac1 raw]$ pwd
/dev/raw
[grid@3850rac1 raw]$ ls -l
总用量 0
crw-rw---- 1 oracle oinstall 162, 10 3月 22 13:42 raw10
crw-rw---- 1 oracle oinstall 162, 11 3月 22 13:42 raw11
crw-rw---- 1 oracle oinstall 162, 12 3月 22 13:42 raw12
crw-rw---- 1 oracle oinstall 162, 13 3月 22 13:41 raw13
crw-rw---- 1 oracle oinstall 162, 14 3月 22 13:42 raw14
crw-rw---- 1 oracle oinstall 162, 15 3月 22 13:42 raw15
crw-rw---- 1 oracle oinstall 162, 3 3月 22 13:42 raw3
crw-rw---- 1 oracle oinstall 162, 4 3月 12 17:48 raw4
crw-rw---- 1 oracle oinstall 162, 5 3月 12 17:48 raw5
crw-rw---- 1 oracle oinstall 162, 6 3月 22 13:42 raw6
crw-rw---- 1 oracle oinstall 162, 7 3月 11 19:09 raw7
crw-rw---- 1 oracle oinstall 162, 8 3月 22 13:42 raw8
crw-rw---- 1 oracle oinstall 162, 9 3月 22 13:42 raw9
crw-rw---- 1 root disk 162, 0 3月 11 19:09 rawctl
--节点2:
[grid@3850rac2 raw]$ uname -a
Linux 3850rac2 2.6.32-71.el6.x86_64 #1 SMP Wed Sep 1 01:33:01 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux
[grid@3850rac2 raw]$
[grid@3850rac2 raw]$
[grid@3850rac2 raw]$ ps -ef | grep pmon
grid 2549 1 0 Jan08 ? 00:28:51 asm_pmon_+ASM2
oracle 3062 1 0 Jan08 ? 00:52:22 ora_pmon_Indepdb2
grid 52915 50897 0 13:30 pts/1 00:00:00 grep pmon
[grid@3850rac2 raw]$
[grid@3850rac2 raw]$
[grid@3850rac2 raw]$
[grid@3850rac2 raw]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Fri Mar 22 13:30:39 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> conn / as sysasm
Connected.
SQL> select GROUP_NUMBER,NAME,STATE from v$asm_diskgroup;
GROUP_NUMBER NAME STATE
------------ ------------------------------ -----------
1 DATA MOUNTED
2 DATA2 MOUNTED
SQL> select name,path from v$asm_disk;
NAME PATH
------------------------------ ------------------------------
DATA_0009 /dev/raw/raw9
DATA2_0000 /dev/raw/raw4
DATA_0000 /dev/raw/raw10
DATA2_0002 /dev/raw/raw7
DATA_0007 /dev/raw/raw6
DATA2_0001 /dev/raw/raw5
DATA_0006 /dev/raw/raw3
DATA_0008 /dev/raw/raw8
DATA_0001 /dev/raw/raw11
DATA_0002 /dev/raw/raw12
DATA_0005 /dev/raw/raw15
DATA_0004 /dev/raw/raw14
DATA_0003 /dev/raw/raw13
13 rows selected.
[grid@3850rac2 ~]$ cd /dev/raw/
[grid@3850rac2 raw]$ ls -l
总用量 0
crw-rw---- 1 oracle oinstall 162, 10 3月 22 13:14 raw10
crw-rw---- 1 oracle oinstall 162, 11 3月 22 13:14 raw11
crw-rw---- 1 oracle oinstall 162, 12 3月 22 13:14 raw12
crw-rw---- 1 oracle oinstall 162, 13 3月 22 13:12 raw13
crw-rw---- 1 oracle oinstall 162, 14 3月 22 13:14 raw14
crw-rw---- 1 oracle oinstall 162, 15 3月 22 13:12 raw15
crw-rw---- 1 oracle oinstall 162, 3 3月 22 13:14 raw3
crw-rw---- 1 oracle oinstall 162, 4 3月 22 13:14 raw4
crw-rw---- 1 oracle oinstall 162, 5 3月 22 13:14 raw5
crw-rw---- 1 oracle oinstall 162, 6 3月 22 13:14 raw6
crw-rw---- 1 oracle oinstall 162, 7 3月 22 11:32 raw7
crw-rw---- 1 oracle oinstall 162, 8 3月 22 13:14 raw8
crw-rw---- 1 oracle oinstall 162, 9 3月 22 13:14 raw9
crw-rw---- 1 root disk 162, 0 12月 26 11:41 rawctl |
|