磁盘组删磁盘时报 ORA-15032 ORA-15054

最新推荐文章于 2024-04-01 14:59:27 发布

cimi087706

最新推荐文章于 2024-04-01 14:59:27 发布

阅读量454

点赞数

SQL> alter diskgroup backup drop disk '/dev/mapper/backup6'; --删磁盘
alter diskgroup backup drop disk '/dev/mapper/backup6'
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15054: disk "/DEV/MAPPER/BACKUP6" does not exist in diskgroup "BACKUP"

SQL> select name,path,state from v$asm_disk;

NAME PATH STATE
------------------------------ ---------------------------------------- --------
DATA_0005 /dev/mapper/data6p1 NORMAL
DATA_0000 /dev/mapper/data1p1 NORMAL
BACKUP_0000 /dev/mapper/backupp1 NORMAL
BACKUP_0002 /dev/mapper/backup1 NORMAL
DATA_0001 /dev/mapper/data2p1 NORMAL
BACKUP_0003 /dev/mapper/backup2 NORMAL
DATA_0006 /dev/mapper/data5p1 NORMAL
BACKUP_0006 /dev/mapper/backup5 NORMAL
DATA_0002 /dev/mapper/data3p1 NORMAL
BACKUP_0005 /dev/mapper/backup4 NORMAL
BACKUP_0007 /dev/mapper/backup6 NORMAL
CRS_0002 /dev/mapper/crs4p1 NORMAL
BACKUP_0004 /dev/mapper/backup3 NORMAL
CRS_0004 /dev/mapper/crs2p1 NORMAL
CRS_0000 /dev/mapper/crs6p1 NORMAL
CRS_0005 /dev/mapper/crs1p1 NORMAL
CRS_0003 /dev/mapper/crs3p1 NORMAL
CRS_0001 /dev/mapper/crs5p1 NORMAL

SQL> select group_number,name,state,total_mb from v$asm_diskgroup;

GROUP_NUMBER NAME STATE TOTAL_MB
------------ ------------------------------ ----------- ----------
1 BACKUP MOUNTED 1433597
2 CRS MOUNTED 6096
3 DATA MOUNTED 1021961

SQL> alter diskgroup backup drop disk backup_0007;
Diskgroup altered.
SQL> alter diskgroup backup drop disk backup_0006;
Diskgroup altered.

总结：删除磁盘时只能跟磁盘的名字，不能跟path。
SQL> select group_number,name,state,total_mb from v$asm_diskgroup;
GROUP_NUMBER NAME STATE TOTAL_MB
------------ ------------------------------ ----------- ----------
1 BACKUP MOUNTED 1023997
2 CRS MOUNTED 6096
3 DATA MOUNTED 1021961
删除两个磁盘后磁盘大小减少了400G。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22969361/viewspace-1084565/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22969361/viewspace-1084565/