如何在linux 10gR2 rac 新增ASM磁盘组

1.需要对新增加的设备在每个节点进行授权 使oracle用户能操作

[root@rac1 oracle]# chown oracle:dba /dev/raw/raw6ITPUB个人空间:x(Hss9L4V
[root@rac1 oracle]# chmod 660 /dev/raw/raw6

[root@rac2 oracle]# chown oracle:dba /dev/raw/raw6
QmX7L*v0\0[root@rac2 oracle]# chmod 660 /dev/raw/raw6

2.oracle用户扫描磁盘路径 能让asm认到设备

select path from v$asm_disk;

设置asm设备搜索路径

alter system set asm_diskstring='ORCL:VOL*','/dev/raw/raw*';

3.在rac1节点进行操作

[oracle@rac1 ~]$ export ORACLE_SID=+ASM1

[oracle@rac1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jun 27 09:03:28 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ITPUB个人空间-\*L~` ]r)Q7]%A
Connected to:ITPUB个人空间aSs)Ff k
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionITPUB个人空间X7EB4|Q#^|[*Q
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL>  select group_number,name,state,total_mb from v$asm_diskgroup;

GROUP_NUMBER NAME                           STATE         TOTAL_MBITPUB个人空间:H$h^ws7|_
------------ ------------------------------ ----------- ----------ITPUB个人空间yu/OX ez(^yP
           2 DATA                           MOUNTED           3057

SQL> create diskgroup testdg external redundancy disk '/dev/raw/raw6';

Diskgroup created.

SQL> select group_number,name,state,total_mb from v$asm_diskgroup;

GROUP_NUMBER NAME                           STATE         TOTAL_MB
R4OD!z`^B0------------ ------------------------------ ----------- ----------
d8P[R!p@0           1 TESTDG                         MOUNTED           2047
~3~ O#wu0           2 DATA                           MOUNTED           3057

SQL> exitITPUB个人空间n a)D$]:O kJe wdU

[.n"h$XR0~@W:i1Z0
5eOw@u/H$k+o$]1Jj04.在rac2节点进行操作

[oracle@rac2 dbs]$ export ORACLE_SID=+ASM2ITPUB个人空间Y~ R"X.J*ilxa
[oracle@rac2 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jun 27 09:08:26 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ddM%[WF@F0Connected to:
|L|-Y%yM0Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionITPUB个人空间"E+sgM3}7I
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> select group_number,name,state,total_mb from v$asm_diskgroup;

GROUP_NUMBER NAME                           STATE         TOTAL_MBITPUB个人空间}.u._T8fk5`[KDe
------------ ------------------------------ ----------- ----------
&y1pVqY3w/]0           2 DATA                           MOUNTED           3057

SQL> alter diskgroup testdg mount;
-D#|}#Xz8@ ZoJ0alter diskgroup testdg mountITPUB个人空间a p
gS3r*ju-D
*
o9n t3W jr(MG\Q W0ERROR at line 1:
r4si5Cu XPc0ORA-15032: not all alterations performed
.W I0}+E)S:hb/S0ORA-15063: ASM discovered an insufficient number of disks for diskgroup
iG9?nM:u(l0"TESTDG"

这是因为没在节点2进行授权 所以报这个错 按照1点 进行授权后就正常了ITPUB个人空间&z0{I LH
SQL> select group_number,name,state,total_mb from v$asm_diskgroup;

GROUP_NUMBER NAME                           STATE         TOTAL_MBITPUB个人空间,R"iGh1i7c-oJ
------------ ------------------------------ ----------- ----------ITPUB个人空间
R
l$e6Dh~(Hk
           0 TESTDG                         DISMOUNTED           0
'zE\*jxw0           2 DATA                           MOUNTED           3057

SQL> alter diskgroup testdg mount;

Diskgroup altered.

SQL> select group_number,name,state,total_mb from v$asm_diskgroup;

GROUP_NUMBER NAME                           STATE         TOTAL_MB
\/p\N&s0------------ ------------------------------ ----------- ----------
HR|$~)`![0           1 TESTDG                         MOUNTED           2047
+Z0eYpe]0           2 DATA                           MOUNTED           3057

SQL>ITPUB个人空间"brFw\y9EETo