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.
注意事项:
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.
操作步骤:
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.
具体操作如下:
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
From Oracle
-------------------------------------------------------------------------------------------------------
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表空间和数据文件的关系,否则拒绝申请
分享到:
相关推荐
6.8.1 Packet Tracer - Configure NAT for IPv4 Cisco Packet Tracer 思科模拟器 正确答案文件 可直接上交正确答案文件 本答案版权归mewhaku所有,严禁再次转载!!! Copyright @mewhaku 2022 All Rights ...
To enable remote connections on the instance of SQL Server 2005 and to turn on the SQL Server Browser service, use the SQL Server 2005 Surface Area Configuration tool. The Surface Area Configuration ...
官方操作手册,该手册内包含操作截图,完整的指导用户如何使用SAP ABAP系统。内含SSL证书部署的步骤
Red Linux6 ,/etc/init.d/oracleasm configure配置所需
How you configure Iscsi target using starwind free Nas software & configure Iscsi initiator on Oracle Linux 6.4
您是否发现,昂贵的内部存储硬件、严格的数据可用性要求,以及利用 现代存储解决方案的难度给您带来了复杂的技术挑战?
vmware-vsphere-install-configure-manage-v70
2.7.2-packet-tracer---configure-single-area-ospfv2---physical-mode_zh-CN.pka
EGSnrc toolkit for Monte Carlo simulation of ionizing radiation transport
ns-server-configure.rar
4.2.7 Packet Tracer - Configure Router-on-a-Stick Inter-VLAN Routing Cisco Packet Tracer 思科模拟器 正确答案文件 可直接上交正确答案文件 本答案版权归mewhaku所有,严禁再次转载!!! Copyright @...
kmgmt-2511-configure-dynamic-host-configuration-protocol-dhcp-cbs.pdf
2.7.2 Lab - Configure Single-Area OSPFv2
Shibboleth idp-configure-with-sp
树莓派-rxtx2.1.7r2-configure
how to configure kernelhow to configure kernel
python库。资源全名:azure-cli-configure-0.1.0b7.tar.gz
资源来自pypi官网。 资源全名:dev-pipeline-configure-0.2.0.tar.gz
1.3.6 Packet Tracer - Configure SSH.pka
DataGrid-ASP.NET MVC-如何基于... 将Controller,LoadAction,UpdateAction,InsertAction和DeleteAction选项设置为true,以便dxDataGrid的数据源可以访问控制器中的相应动作。 . DataSource ( d => d .... .... .... .... .... ....