13.jpg (20.93 KB, 下载次数: 13)
2008-5-27 16:12 上传
确认:
SQL> CREATE DISKGROUP DISK_GROUP4 NORMAL REDUNDANCY
FAILGROUP FAILGROUP2 DISK 'D:ASM DISKDISK_FILE_DISK8' NAME DISK8 SIZE 16 M ,'D:ASM DISKDISK_FILE_DISK9' NAME DISK9 SIZE 16 M
FAILGROUP FAILGROUP1 DISK 'D:ASM DISKDISK_FILE_DISK10' NAME DISK10 SIZE 16 M ,'D:ASM DISKDISK_FILE_DISK7' NAME DISK7 SIZE 16 M ;
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-15041: diskgroup space exhausted
磁盘组的空间不够大.
我又新建了4个50M的磁盘文件,重新创建磁盘组:
SQL> CREATE DISKGROUP DISK_GROUP4 NORMAL REDUNDANCY FAILGROUP FG2 DISK 'D:ASM DISKDISK_FILE_DISK13' NAME DISK13 SIZE 50 M ,'D:ASM DISKDISK_FILE_DISK14' NAME DISK14 SIZE 50 M FAILGROUP FG1 DISK 'D:ASM DISKDISK_FILE_DISK11' NAME DISK11 SIZE 50 M ,'D:ASM DISKDISK_FILE_DISK12' NAME DISK12 SIZE 50 M ;
磁盘组已创建。
14.jpg (27.28 KB, 下载次数: 15)
2008-5-27 16:12 上传
我们可以看到两个故障组内,磁盘的数据大小一致.
15.jpg (31.49 KB, 下载次数: 13)
2008-5-27 16:12 上传
ASMCMD> lsdg disk_group4
State Type Rebal Unbal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Name
MOUNTED NORMAL N N 512 4096 1048576 200 94 50 22 0 DISK_GROUP4/
我们看到这个磁盘组还没有存储数据,就占用了106M的空间.
SQL> select group_number,name,type,total_mb,free_mb from v$asm_diskgroup;
GROUP_NUMBER NAME TYPE TOTAL_MB FREE_MB
------------ ----------------- ------------ ---------- ----------
1 DISK_GROUP1 EXTERN 6144 4790
2 DISK_GROUP2 EXTERN 6144 4884
3 RMAN_GROUP EXTERN 2046 421
4 DISK_GROUP4 NORMAL 200 94
SQL> select group_number,disk_number,name,failgroup,create_date,path from v$asm_disk where group_number=4;
GROUP_NUMBER DISK_NUMBER NAME FAILGROUP CREATE_DATE PATH
------------ ----------- ----------------- --------- ------------------- ----------------------------------------
4 2 DISK11 FG1 2008-05-27 14:52:26 D:ASM DISKDISK_FILE_DISK11
4 3 DISK12 FG1 2008-05-27 14:52:26 D:ASM DISKDISK_FILE_DISK12
4 0 DISK13 FG2 2008-05-27 14:52:26 D:ASM DISKDISK_FILE_DISK13
4 1 DISK14 FG2 2008-05-27 14:52:26 D:ASM DISKDISK_FILE_DISK14
尝试把之前的四个磁盘加进来:
[本帖最后由 赵宇 于 2008-5-27 16:13 编辑]