以下為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和這個磁盤一樣的情況，不存在另外一個節點已掛載。
uj5u.com熱心網友回復：
MYASMD3 沒有從data DG里面洗掉成功吧？uj5u.com熱心網友回復：
這MYASMD3不是還在DATA磁盤組里嗎？uj5u.com熱心網友回復：
沒刪掉吧，還在。。。。。uj5u.com熱心網友回復：
沒刪掉，等同步完，釋放了才可以加到其它組uj5u.com熱心網友回復：
目錄權限變了。把整個oracle安裝目錄權限添加everyone完全控制，然后再操作吧。uj5u.com熱心網友回復：
上一潭訓錯貼了uj5u.com熱心網友回復：
好幾天了，這個磁盤一直是DROPPING狀態uj5u.com熱心網友回復：
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
uj5u.com熱心網友回復：
把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
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/70798.html
標籤：基礎和管理
上一篇：sys用戶建全文索引報錯 Bug No. 1366361
下一篇：oracle資料庫設計問題咨詢