How To Create An ASM Diskgroup Using XML code Thru ASMCMD [ID 1290550.1]

 

 

Oracle Server - Enterprise Edition Version: 11.2.0.1 to 11.2.0.2 - Release: 11.2 to 11.2

 

步骤如下：

 

1)  Create a XML file (e.g. diskgroup.xml) with the next code:

<dg name="datadg" redundancy="normal">
<fg name="SAN1">
<dsk string="ORCL:ASMDISK1"/>
<dsk string="ORCL:ASMDISK2"/> </fg>
<fg name="SAN2">
<dsk string="ORCL:ASMDISK3"/>
<dsk string="ORCL:ASMDISK4"/> </fg>
<a name="compatible.asm" value="11.2"/>
<a name="compatible.rdbms" value="11.2"/>
<a name="compatible.advm" value="11.2"/>
</dg>

2) Then execute the XML script thru ASMCMD as follow:

[grid@dbaasm ~]$ asmcmd mkdg diskgroup.xml

3) Validate the diskgroup was created:

SQL*Plus: Release 11.2.0.1.0 Production on Tue Feb 1 17:59:37 2011

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Automatic Storage Management option

SQL> select name, state, type from v$asm_diskgroup;

NAME STATE TYPE
------------------------------ ----------- ------
ACFSDG MOUNTED EXTERN
DATA MOUNTED NORMAL
DATADG MOUNTED NORMAL  <(= Here
RECO MOUNTED NORMAL

 

 

 

 

From Oracle

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

QQ: 492913789
Email: ahdba@qq.com
Blog: http://www.cndba.cn/dave

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

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

聊天 群：40132017   聊天2群：69087192

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