oracle10g删除asm组,在Oracle10g 新增ASM磁盘组

首先在虚拟机器上 添加个硬盘1G 启动后对其进行分区 每个200M

[root@rac1 ~]# fdisk /dev/sdb

我把它分成了五个200M的扩展分区：

/dev/sdb5

/dev/sdb6

/dev/sdb7

/dev/sdb8

/dev/sdb9

[root@rac1 ~]# vi /etc/sysconfig/rawdevices

/dev/raw/raw1 /dev/sdf5

/dev/raw/raw2 /dev/sdf6

/dev/raw/raw3 /dev/sdf7

/dev/raw/raw4 /dev/sdf8

/dev/raw/raw5 /dev/sdf9

[root@rac1 ~]# service rawdevices restart

[root@rac1 ~]# chown oracle:dba /dev/raw/raw[1-5]

[root@rac1 ~]# chmod 660 /dev/raw/raw[1-5]

[root@rac1 ~]# ls -lat /dev/raw/raw*

crw-rw----  1 oracle dba 162, 5 Apr 17 10:57 /dev/raw/raw5

crw-rw----  1 oracle dba 162, 4 Apr 17 10:57 /dev/raw/raw4

crw-rw----  1 oracle dba 162, 3 Apr 17 10:57 /dev/raw/raw3

crw-rw----  1 oracle dba 162, 2 Apr 17 10:57 /dev/raw/raw2

crw-rw----  1 oracle dba 162, 1 Apr 17 10:57 /dev/raw/raw1

修改 /etc/udev/permissions.d/50-udev.permissions，使oracle能操作裸设备

[root@rac1 ~]# vi /etc/udev/permissions.d/50-udev.permissions

# raw devices

ram*:root:disk:0660

#raw/*:root:disk:0660

raw/*:oracle:dba:0660

[root@rac1 ~]# service rawdevices restart

Assigning devices:

/dev/raw/raw1  --&gt   /dev/sdb5

/dev/raw/raw1:  bound to major 8, minor 133

/dev/raw/raw2  --&gt   /dev/sdb6

/dev/raw/raw2:  bound to major 8, minor 134

/dev/raw/raw3  --&gt   /dev/sdb7

/dev/raw/raw3:  bound to major 8, minor 135

/dev/raw/raw4  --&gt   /dev/sdb8

/dev/raw/raw4:  bound to major 8, minor 136

/dev/raw/raw5  --&gt   /dev/sdb9

/dev/raw/raw5:  bound to major 8, minor 137

创建裸设备完成后 用oracle用户登录先启动asm实例,后启动数据库

[oracle@d10031 ~]$ export ORACLE_SID=+ASM

[oracle@d10031 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jun 23 16:20:11 2008

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

Connected to an idle instance.

SQL> startup

ASM instance started

Total System Global Area   83886080 bytes

Fixed Size                  1217836 bytes

Variable Size              57502420 bytes

ASM Cache                  25165824 bytes

ASM diskgroups mounted

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

[oracle@d10031 ~]$ export ORACLE_SID=ORCL

[oracle@d10031 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jun 23 16:20:28 2008

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

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area  167772160 bytes

Fixed Size                  1218316 bytes

Variable Size              62916852 bytes

Database Buffers          100663296 bytes

Redo Buffers                2973696 bytes

Database mounted.

Database opened.

[oracle@d10031 ~]$ export ORACLE_SID=+ASM

[oracle@d10031 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jun 23 16:21:51 2008

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

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

SQL>alter system set  asm_diskstring='ORCL:VOL*',' /dev/raw/raw*';

System altered.

SQL> select path from v$asm_disk;

PATH

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

/dev/raw/raw1

/dev/raw/raw2

/dev/raw/raw3

/dev/raw/raw4

/dev/raw/raw5

ORCL:VOL1

ORCL:VOL2

ORCL:VOL3

ORCL:VOL4

9 rows selected.

SQL> show parameter string;

NAME                                 TYPE        VALUE

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

asm_diskstring                       string      ORCL:VOL*, /dev/raw/raw*

SQL> create diskgroup testdg external redundancy disk '/dev/raw/raw1';

Diskgroup created.

SQL> select group_number,name,state,total_mb from v$asm_diskgroup;

GROUP_NUMBER NAME                           STATE         TOTAL_MB

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

1 DGROUP1                        MOUNTED           8188

2 TESTDG                         MOUNTED            196

红色就是新增加的磁盘组