One ASM DISK GROUP contains all of the available disks of the server. Need to  re-configure the current DISK GROUP to break it down into three different ASM disk groups.

 http://www.cndba.cn/dave/article/832

注意事项：

1). A DISK GROUP with single disk is possible only if the redundancy of diskgroup is EXTERNAL.
2). We can n't change the redundancy of a diskgroup once it is created
3). By using external redundancy we are depending on external mechanisms (like RAID) for fault tolerance.

http://www.cndba.cn/dave/article/832

操作步骤：
1)   Check the redundancy of diskgroup and Identify the group number.
2)   Identify the physical disk names.
3)    Drop the identified disks from existing diskgroup.
4)   Create new  diskgroups.

 http://www.cndba.cn/dave/article/832http://www.cndba.cn/dave/article/832

具体操作如下：

1)  Check the redundancy of diskgroup and Identify the group number.

ASM:SQL>SELECT GROUP_NUMBER,TYPE FROM V$ASM_DISKGROUP WHERE NAME='DATA';

GROUP_NUMBER   TYPE
------------                -------
1                                EXTERN

(Here EXTERN indicates the Diskgroup DATA is created with redundancy external).


2)  Identify the DISK Name and Path.

ASM:SQL > SELECT NAME,PATH FROM V$ASM_DISK WHERE GROUP_NUMBER=1

NAME                        PATH
-----------                ----------
DATA_0001            /dev/raw/raw1
DATA_0002            /dev/raw/raw2
DATA_0003            /dev/raw/raw3


3)  Drop the identified disks from existing diskgroup.

ASM:SQL> ALTER DISKGROUP DATA DROP DISK DATA_0002
ASM:SQL> ALTER DISKGROUP DATA DROP DISK DATA_0003

4)  Create new two diskgroups.

create diskgroup DATA_A external redundancy disk '/dev/raw/raw1'
create diskgroup DATA_B external redundancy disk '/dev/raw/raw2'

 

       Note: The steps provided here assume that there is a disk group DATA with  external redundancy  contains three disks. This need to be break down to three seperate diskgroups. We depend on external redundancy when the defined disks have some external means  for fault tolerence(eg RAID),ie Oracle will not do any mirroring for these diskgroups

 http://www.cndba.cn/dave/article/832

 

 

 

 

From Oracle

-------------------------------------------------------------------------------------------------------http://www.cndba.cn/dave/article/832

Blog： http://blog.csdn.net/tianlesoftware

Email: dvd.dba@gmail.com

DBA1 群：62697716(满);   DBA2 群：62697977(满)   DBA3 群：62697850(满)  

DBA 超级群：63306533(满);  DBA4 群： 83829929  DBA5群： 142216823   

聊天 群：40132017   聊天2群：69087192

--加群需要在备注说明Oracle表空间和数据文件的关系，否则拒绝申请

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle 11g