本地测试环境,搭建两节点RAC。asmca创建几个diskgroup,有一个遇到问题。
节点1,正常:
SQL> select path, name, mount_status, header_status, mode_status, state from v$asm_disk;
PATH NAME MOUNT_S HEADER_STATU MODE_ST STATE
------------------------------ ------------------------------ ------- ------------ ------- --------
/dev/AAAdisks/SSSSSSSSSS01 DG_DDDD_AAAAA_0000 CACHED MEMBER ONLINE NORMAL
/dev/AAAdisks/BBBBBBBBB01 DG_XXX_AAAAA_0000 CACHED MEMBER ONLINE NORMAL
节点2, 异常,name是空值:
SQL> select path, name, mount_status, header_status, mode_status, state from v$asm_disk;
PATH NAME MOUNT_S HEADER_STATU MODE_ST STATE
------------------------------ ------------------------------ ------- ------------ ------- --------
/dev/AAAdisks/SSSSSSSSSS01 CLOSED MEMBER ONLINE NORMAL
/dev/AAAdisks/BBBBBBBBB01 DG_XXX_AAAAA_0000 CACHED MEMBER ONLINE NORMAL
修复方法为:
1. drop diskgroup DG_DDDD_AAAAA including contents;
2. dd if=/dev/null of=/dev/AAAdisks/SSSSSSSSSS01 bs=1024 count=5000
3. reboot system
4. asmca -silent -createDiskGroup -diskGroupName DG_DDDD_AAAAA -disk '/dev/AAAdisks/SSSSSSSSSS01' -redundancy EXTERNAL -au_size 4
OK