ASM删盘后无法再建DISKGROUP

从不干坏事 2018-03-14 02:39:12 


以下为ASM DG的详细信息：



GROUP_NUMBER NAME      MOUNT_S HEADER_STATU MODE_ST STATE      TOTAL_MB    FREE_MB NAME      PATH		AU_SIZE TYPE

------------ --------- ------- ------------ ------- -------- ---------- ---------- --------- --------------- ---------- ------

	   2 FLASH     CACHED  MEMBER	    ONLINE  NORMAL	  10236       9678 FLASH     ORCL:FLASH 	1048576 EXTERN

	   1 DATA      CACHED  MEMBER	    ONLINE  NORMAL	  10236       9840 MYASMD1   ORCL:MYASMD1	1048576 NORMAL

	   1 DATA      CACHED  MEMBER	    ONLINE  NORMAL	  10236       9840 MYASMD2   ORCL:MYASMD2	1048576 NORMAL

	   1 DATA      CACHED  MEMBER	    ONLINE  DROPPING	  10236      10202 MYASMD3   ORCL:MYASMD3	1048576 NORMAL

	   4 T1        CACHED  MEMBER	    ONLINE  NORMAL	  10236      10143 MYASMD4   ORCL:MYASMD4	1048576 EXTERN

	   3 RACBASE   CACHED  MEMBER	    ONLINE  NORMAL	  10236       6102 RACBASE   ORCL:RACBASE	1048576 EXTERN



其中磁盘ORCL:MYASMD4是在DATA组删除以后重建的DISK GROUP，磁盘ORCL:MYASMD3同样的操作，我再对这块盘进行重建DISK GROUP的时候就报错了：



SQL> create diskgroup t2 external redundancy disk 'ORCL:MYASMD3';

create diskgroup t2 external redundancy disk 'ORCL:MYASMD3'

*

ERROR at line 1:

ORA-15018: diskgroup cannot be created

ORA-15029: disk 'ORCL:MYASMD3' is already mounted by this instance


RAC双节点环境，另外一个节点的ASM和这个磁盘一样的情况，不存在另外一个节点已挂载。
...全文
593 9 打赏 收藏 转发到动态 举报
写回复
用AI写文章
9 条回复
切换为时间正序
请发表友善的回复…
发表回复
从不干坏事 2018-03-17
  • 打赏
  • 举报
 回复
把DG T1删除了释放了磁盘（10G），然后分成小盘（1G*3和7G*1），把三块1G小盘把DATA DG替换掉，成功 如下： 

SQL> DROP DISKGROUP T1 INCLUDING CONTENTS;

Diskgroup dropped.

SQL> ALTER DISKGROUP DATA UNDROP DISKS;

Diskgroup altered.
GROUP_NUMBER NAME      FAILGROUP MOUNT_S HEADER_STATU MODE_ST STATE	 TOTAL_MB    FREE_MB NAME      PATH		  AU_SIZE TYPE
------------ --------- --------- ------- ------------ ------- -------- ---------- ---------- --------- --------------- ---------- ------
	   2 FLASH     FLASH	 CACHED  MEMBER       ONLINE  NORMAL	    10236	9678 FLASH     ORCL:FLASH	  1048576 EXTERN
	   1 DATA      MYASMD1	 CACHED  MEMBER       ONLINE  NORMAL	    10236	9840 MYASMD1   ORCL:MYASMD1	  1048576 NORMAL
	   1 DATA      MYASMD2	 CACHED  MEMBER       ONLINE  NORMAL	    10236	9840 MYASMD2   ORCL:MYASMD2	  1048576 NORMAL
	   1 DATA      MYASMD3	 CACHED  MEMBER       ONLINE  NORMAL	    10236      10177 MYASMD3   ORCL:MYASMD3	  1048576 NORMAL
	   3 RACBASE   RACBASE	 CACHED  MEMBER       ONLINE  NORMAL	    10236	6036 RACBASE   ORCL:RACBASE	  1048576 EXTERN
SQL> select a.group_number,a.failgroup,a.mount_status,a.header_status,a.mode_status,a.state,a.total_mb,a.free_mb,a.name,a.path from v$asm_disk a;

GROUP_NUMBER FAILGROUP MOUNT_S HEADER_STATU MODE_ST STATE      TOTAL_MB    FREE_MB NAME      PATH
------------ --------- ------- ------------ ------- -------- ---------- ---------- --------- ---------------
	   0	       CLOSED  PROVISIONED  ONLINE  NORMAL	      0 	 0	     ORCL:DATA2
	   0	       CLOSED  PROVISIONED  ONLINE  NORMAL	      0 	 0	     ORCL:MYASMD41
	   0	       CLOSED  PROVISIONED  ONLINE  NORMAL	      0 	 0	     ORCL:MYASMD42
	   0	       CLOSED  PROVISIONED  ONLINE  NORMAL	      0 	 0	     ORCL:MYASMD43
	   2 FLASH     CACHED  MEMBER	    ONLINE  NORMAL	  10236       9678 FLASH     ORCL:FLASH
	   1 MYASMD1   CACHED  MEMBER	    ONLINE  NORMAL	  10236       9927 MYASMD1   ORCL:MYASMD1
	   1 MYASMD2   CACHED  MEMBER	    ONLINE  NORMAL	  10236       9926 MYASMD2   ORCL:MYASMD2
	   1 MYASMD3   CACHED  MEMBER	    ONLINE  NORMAL	  10236       9929 MYASMD3   ORCL:MYASMD3
	   3 RACBASE   CACHED  MEMBER	    ONLINE  NORMAL	  10236       6036 RACBASE   ORCL:RACBASE
SQL> ALTER DISKGROUP DATA ADD DISK 'ORCL:MYASMD41' NAME NEWFG41,'ORCL:MYASMD42' NAME NEWFG42,'ORCL:MYASMD43' NAME NEWFG43 DROP DISK MYASMD1,MYASMD2,MYASMD3;

Diskgroup altered.

--下面为磁盘替换过程：
GROUP_NUMBER NAME      FAILGROUP MOUNT_S HEADER_STATU MODE_ST STATE	 TOTAL_MB    FREE_MB NAME      PATH		  AU_SIZE TYPE
------------ --------- --------- ------- ------------ ------- -------- ---------- ---------- --------- --------------- ---------- ------
	   2 FLASH     FLASH	 CACHED  MEMBER       ONLINE  NORMAL	    10236	9678 FLASH     ORCL:FLASH	  1048576 EXTERN
	   1 DATA      MYASMD1	 CACHED  MEMBER       ONLINE  DROPPING	    10236	9947 MYASMD1   ORCL:MYASMD1	  1048576 NORMAL
	   1 DATA      MYASMD2	 CACHED  MEMBER       ONLINE  DROPPING	    10236	9946 MYASMD2   ORCL:MYASMD2	  1048576 NORMAL
	   1 DATA      MYASMD3	 CACHED  MEMBER       ONLINE  DROPPING	    10236	9949 MYASMD3   ORCL:MYASMD3	  1048576 NORMAL
	   3 RACBASE   RACBASE	 CACHED  MEMBER       ONLINE  NORMAL	    10236	6036 RACBASE   ORCL:RACBASE	  1048576 EXTERN
	   1 DATA      NEWFG41	 CACHED  MEMBER       ONLINE  NORMAL	     1019	 997 NEWFG41   ORCL:MYASMD41	  1048576 NORMAL
	   1 DATA      NEWFG42	 CACHED  MEMBER       ONLINE  NORMAL	     1019	 997 NEWFG42   ORCL:MYASMD42	  1048576 NORMAL
	   1 DATA      NEWFG43	 CACHED  MEMBER       ONLINE  NORMAL	     1019	 997 NEWFG43   ORCL:MYASMD43	  1048576 NORMAL

--下面为已经替换成功：
GROUP_NUMBER NAME      FAILGROUP MOUNT_S HEADER_STATU MODE_ST STATE	 TOTAL_MB    FREE_MB NAME      PATH		  AU_SIZE TYPE
------------ --------- --------- ------- ------------ ------- -------- ---------- ---------- --------- --------------- ---------- ------
	   2 FLASH     FLASH	 CACHED  MEMBER       ONLINE  NORMAL	    10236	9678 FLASH     ORCL:FLASH	  1048576 EXTERN
	   3 RACBASE   RACBASE	 CACHED  MEMBER       ONLINE  NORMAL	    10236	6036 RACBASE   ORCL:RACBASE	  1048576 EXTERN
	   1 DATA      NEWFG41	 CACHED  MEMBER       ONLINE  NORMAL	     1019	 710 NEWFG41   ORCL:MYASMD41	  1048576 NORMAL
	   1 DATA      NEWFG42	 CACHED  MEMBER       ONLINE  NORMAL	     1019	 710 NEWFG42   ORCL:MYASMD42	  1048576 NORMAL
	   1 DATA      NEWFG43	 CACHED  MEMBER       ONLINE  NORMAL	     1019	 711 NEWFG43   ORCL:MYASMD43	  1048576 NORMAL
但是，当我对新的磁盘继续单磁盘删除的时候，始终还是DROPPING状态，无法删除： 

SQL> alter diskgroup data drop disk NEWFG43;

Diskgroup altered.

GROUP_NUMBER NAME      MOUNT_S HEADER_STATU MODE_ST STATE      TOTAL_MB    FREE_MB NAME      PATH		AU_SIZE TYPE
------------ --------- ------- ------------ ------- -------- ---------- ---------- --------- --------------- ---------- ------
	   2 FLASH     CACHED  MEMBER	    ONLINE  NORMAL	  10236       9678 FLASH     ORCL:FLASH 	1048576 EXTERN
	   3 RACBASE   CACHED  MEMBER	    ONLINE  NORMAL	  10236       6036 RACBASE   ORCL:RACBASE	1048576 EXTERN
	   1 DATA      CACHED  MEMBER	    ONLINE  NORMAL	   1019        623 NEWFG41   ORCL:MYASMD41	1048576 NORMAL
	   1 DATA      CACHED  MEMBER	    ONLINE  NORMAL	   1019        623 NEWFG42   ORCL:MYASMD42	1048576 NORMAL
	   1 DATA      CACHED  MEMBER	    ONLINE  DROPPING	   1019        985 NEWFG43   ORCL:MYASMD43	1048576 NORMAL
从不干坏事 2018-03-16
  • 打赏
  • 举报
 回复
DISKGROUP T1也是从DATA里面剥离出来的，我再次尝试删除和创建新的DISKGROUP 结果还是不行 

SQL> alter diskgroup data drop disk MYASMD3;
alter diskgroup data drop disk MYASMD3
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15071: ASM disk "MYASMD3" is already being dropped


SQL> create diskgroup t2 external redundancy disk 'ORCL:MYASMD3';
create diskgroup t2 external redundancy disk 'ORCL:MYASMD3'
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-15029: disk 'ORCL:MYASMD3' is already mounted by this instance
从不干坏事 2018-03-16
  • 打赏
  • 举报
 回复
好几天了，这个磁盘一直是DROPPING状态
好记忆不如烂笔头abc 2018-03-15
  • 打赏
  • 举报
 回复
上一条回错贴了
好记忆不如烂笔头abc 2018-03-15
  • 打赏
  • 举报
 回复
目录权限变了。把整个oracle安装目录权限添加everyone完全控制，然后再操作吧。
好记忆不如烂笔头abc 2018-03-15
  • 打赏
  • 举报
 回复
没删掉，等同步完，释放了才可以加到其它组
学海无涯-回头是岸 2018-03-14
  • 打赏
  • 举报
 回复
没删掉吧，还在。。。。。
minsic78 2018-03-14
  • 打赏
  • 举报
 回复
这MYASMD3不是还在DATA磁盘组里吗？
liu志坚 2018-03-14
  • 打赏
  • 举报
 回复
MYASMD3   没有从data DG里面删除成功吧？
ASM实例+ASM数据库安装（Win8+Ora10）
ASM实例+ASM数据库安装（Win8+Ora10） 1 第一篇 创建未格式化的磁盘分区 1 1.1 打开压缩卷窗口 1 1.2 输入卷大小 3 1.3 选择挂载目录 4 1.4 格式化分区选项 5 1.5汇总信息 6 1.6分区完成后磁盘情况 7 1.7挂载目录...
【故障】ASM diskgroup dismount with \"Waited 15 secs for write IO to PST\"
NULL 博文链接：https://askerain.iteye.com/blog/2295744
oracle rac to rac adg 生产案例，某三甲医院部署场景
集群名称 ASM diskgroup（vote） ASM diskgroup （database managefile） ASM diskgroup （recovery manage） 生产库集群 +OCR_OVTE +DATA +ARCH 容灾库集群 +OCR_OVTE +DGDATA +DGARCH 集群名称 数据存放路径 ...
dg迁移存储和数据dg修改normal冗余.txt
asm diskgroup迁移存储和数据diskgroup修改normal冗余
jansu-dev#Oracle-Learning-Notes#ASM的connect的和mounted的区别1
title: ASM的connect的和mounted的区别解释问题：为什么查看v$asm_diskgroup的state有时是mounted有时connect
基础和管理

17,377

社区成员

95,128

社区内容

发帖
与我相关
我的任务
社区描述
Oracle 基础和管理
社区管理员
  • 基础和管理社区
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章