首页 » 数据库 » Oracle » ORACLE 11g R2 Rac向已有ASM组增加磁盘操作

ORACLE 11g R2 Rac向已有ASM组增加磁盘操作

 

ORACLE 11g R2 Rac向已有ASM组增加磁盘操作

配置要求说明:将/dev/sdb2 一个800G的区加入到ASM现有的DATA组

1、现有asm 磁盘和磁盘组查看

# oracleasm listdisks
DISK1
SQL> select name from v$asm_diskgroup;
NAME
------------------------------
DATA

su - grid

$ asmcmd

ASMCMD> lsdg

State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name

MOUNTED  EXTERN  N         512   4096  1048576   1228807   246184                0          246184              0             Y  DATA/

2、创建ASM磁盘

# oracleasm createdisk DISK2 /dev/sdb2

Writing disk header: done

Instantiating disk: done

# oracleasm listdisks

DISK1

DISK2

在其他节点执行

# oracleasm scandisks

Reloading disk partitions: done

Cleaning any stale ASM disks...

Scanning system for ASM disks...

Instantiating disk "DISK2"

# oracleasm listdisks

DISK1

DISK2

# ll /dev/oracleasm/disks/

total 0

brw-rw---- 1 grid asmadmin 8, 17 Nov  1 17:09 DISK1

brw-rw---- 1 grid asmadmin 8, 18 Dec 23 17:06 DISK2

在rac1节点上执行

[root@rac1 mapper]# su - grid

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

[oracle@rac1 ~]$ sqlplus "/as sysasm"

SQL*Plus: Release 11.2.0.4.0 Production on Wed Dec 23 17:14:55 2015

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

SQL> select name,path from v$asm_disk_stat;

NAME

------------------------------

PATH

--------------------------------------------------------------------------------

DISK1

ORCL:DISK1

SQL>alter diskgroup DATA add disk 'ORCL:DISK2' name DISK2;

SQL> conn /as sysasm

Connected.

SQL> alter diskgroup DATA add disk 'ORCL:DISK2' name DISK2;

Diskgroup altered.

3、验证:

SQL>  select name,path from v$asm_disk_stat;

NAME

------------------------------

PATH

--------------------------------------------------------------------------------

DISK1

ORCL:DISK1

DISK2

ORCL:DISK2

$asmcmd

ASMCMD> lsdg

State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name

MOUNTED  EXTERN  Y         512   4096  1048576   1945597   962966                0          962966              0             Y  DATA/

DATA组空间大小已增加。

将磁盘增加到ASM组完成

原文链接:ORACLE 11g R2 Rac向已有ASM组增加磁盘操作,转载请注明来源!

1