环境:

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

SQL> connect / as sysdba
Connected.

SQL> select name,total_mb from v$asm_diskgroup;

NAME                             TOTAL_MB
------------------------------ ----------
DATA                                16378
RECDATA                             16378

-- The End --

ITPub博客

使用ASMCA添加磁盘组

最新文章