root 加入oracle组,使用ASMCA添加磁盘组

环境:

OS:Red Hat Linux As 5

DB:11.2.0.1

1.查看当前磁盘情况(root用户)

[root@hxl ~]# fdisk -l

Disk /dev/sda: 21.4 GB, 21474836480 bytes

255 heads, 63 sectors/track, 2610 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot      Start         End      Blocks   Id  System

/dev/sda1   *         201        2610    19358325   83  Linux

/dev/sda2               1         200     1606468+  82  Linux swap / Solaris

Partition table entries are not in disk order

Disk /dev/sdb: 8589 MB, 8589934592 bytes

255 heads, 63 sectors/track, 1044 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot      Start         End      Blocks   Id  System

/dev/sdb1               1        1044     8385898+  83  Linux

Disk /dev/sdc: 8589 MB, 8589934592 bytes

255 heads, 63 sectors/track, 1044 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot      Start         End      Blocks   Id  System

/dev/sdc1               1        1044     8385898+  83  Linux

Disk /dev/sdd: 8589 MB, 8589934592 bytes

255 heads, 63 sectors/track, 1044 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot      Start         End      Blocks   Id  System

/dev/sdd1               1        1044     8385898+  83  Linux

Disk /dev/sde: 8589 MB, 8589934592 bytes

255 heads, 63 sectors/track, 1044 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Device Boot      Start         End      Blocks   Id  System

/dev/sde1               1        1044     8385898+  83  Linux

2.查看当前的ASM磁盘(root用户)[root@hxl ~]# oracleasm listdisks;

VOL1

VOL2

3.添加ASM磁盘(root用户)[root@hxl ~]# oracleasm createdisk VOL3 /dev/sdd1

Writing disk header: done

Instantiating disk: done

[root@hxl ~]# oracleasm createdisk VOL4 /dev/sde1

Writing disk header: done

Instantiating disk: done

[root@hxl ~]# oracleasm listdisks;

VOL1

VOL2

VOL3

VOL4

5.创建ASM磁盘组(grid用户)

[hxl.com/grid]$asmca

输入磁盘组名,采用外部冗余,然后选择磁盘.

6.查看磁盘组(grid用户)

[hxl.com/grid]$echo $ORACLE_SID

+ASM

[hxl.com/grid]$sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Fri Sep 21 03:07:27 2012

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

SQL> connect / as sysdba

Connected.

SQL> select name,total_mb from v$asm_diskgroup;

NAME                             TOTAL_MB

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

DATA                                16378RECDATA                             16378

-- The End --