oracle 10g rac asm磁盘组增加硬盘

环境:rhel4.4 ,oracle 10gR2

两个节点  rac1  rac2

SQL> select name from v$asm_diskgroup;


NAME
------------------------------
DATA
FLASH_RECOVER_AREA

要增加磁盘的磁盘组为:DATA

要增加的磁盘为: /dev/mapper/asm3p1

在rac1上执行

[root@rac1 mapper]# /etc/init.d/oracleasm createdisk ASM3 /dev/mapper/asm3p1
Marking disk "ASM3" as an ASM disk: [  OK  ]

[root@rac1 mapper]# ll /dev/oracleasm/disks/
total 0
brw-rw---- 1 oracle dba 253, 13 Oct 11 16:32 ASM1
brw-rw---- 1 oracle dba 253, 10 Oct 11 16:33 ASM2
brw-rw---- 1 oracle dba 253, 16 Oct 11 16:32 ASM3
brw-rw---- 1 oracle dba 253,  8 Oct 11 16:33 FLASHRECOVER






[root@rac1 mapper]# su - oracle
[oracle@rac1 ~]$ export ORACLE_SID=+ASM1
[oracle@rac1 ~]$ sqlplus "/as sysdba"


SQL*Plus: Release 10.2.0.4.0 - Production on Thu Oct 11 16:34:19 2012


Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.




Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options


SQL> select name from v$asm_diskgroup;


NAME
------------------------------
DATA
FLASH_RECOVER_AREA


SQL> select name,path from v$asm_disk_stat;


NAME
------------------------------
PATH
--------------------------------------------------------------------------------


/dev/oracleasm/disks/ASM3


DATA_0000
/dev/oracleasm/disks/ASM1


DATA_0001
/dev/oracleasm/disks/ASM2




NAME
------------------------------
PATH
--------------------------------------------------------------------------------
FLASH_RECOVER_AREA_0000
/dev/oracleasm/disks/FLASHRECOVER


在rac2上执行

[root@rac2 ~]# /etc/init.d/oracleasm scandisks
Scanning the system for Oracle ASMLib disks: [  OK  ]

[root@rac2 ~]# ll /dev/oracleasm/disks/
total 0
brw-rw---- 1 oracle dba 253, 14 Oct 11 18:03 ASM1
brw-rw---- 1 oracle dba 253, 12 Oct 11 18:03 ASM2
brw-rw---- 1 oracle dba 253, 16 Oct 11 18:03 ASM3
brw-rw---- 1 oracle dba 253, 11 Oct 11 18:03 FLASHRECOVER


在rac1上执行

SQL> alter diskgroup DATA add disk '/dev/oracleasm/disks/ASM3' name DATA_0002;

阅读更多
个人分类: Oracle
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

加入CSDN,享受更精准的内容推荐,与500万程序员共同成长!
关闭
关闭