本文主要是介绍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表空间和数据文件的关系,否则拒绝申请
这篇关于How To Create An ASM Diskgroup Using XML code Thru ASMCMD [ID 1290550.1]的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!