在windows中搭建虚拟ASM环境创建Oracle 10G数据库(四)

SQL> ALTER DISKGROUP dg1 ADD failgroup DG1_0001 disk 'D:\oracle\asmdisk\disk5
Diskgroup altered.

SQL> select group_number,mount_status,name,failgroup,path from v$asm_disk;

GROUP_NUMBER MOUNT_S NAME FAILGROUP PATH
------------ ------- -------------------- -------------------- ------------------------
1 CACHED DG1_0000 DG1_0000 D:\ORACLE\ASMDISK\DISK1
1 CACHED DG1_0001 DG1_0001 D:\ORACLE\ASMDISK\DISK2
2 CACHED DG2_0000 DG2_0000 D:\ORACLE\ASMDISK\DISK3
1 CACHED DG1_0002 DG1_0000 D:\ORACLE\ASMDISK\DISK4
1 CACHED DG1_0003 DG1_0001 D:\ORACLE\ASMDISK\DISK5

这样磁盘组dg1的容量就加大了.

更多细节:http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_1006.htm#SQLRF01113