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表空间和数据文件的关系,否则拒绝申请