环境:
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 16378
RECDATA 16378
-- The End --
阅读(24718) | 评论(1) | 转发(0) |
