solaris 10_oracle10g asm_create_alter_diskgroup相关命令

SQL> create diskgroup dg2 external redundancy disk '/dev/rdsk/c0d1s5';---建立磁盘组,如果不加name选项,系统会自动生成一个值,对应v$asm_disk的name

Diskgroup created.

SQL> alter diskgroup dg2 add disk '/dev/rdsk/c0d1s0' name dg2_new_disk;   ---向磁盘组添加磁盘(报这个错可能这个磁盘已被使用)
alter diskgroup dg2 add disk '/dev/rdsk/c0d1s0' name dg2_new_disk
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15201: disk /dev/rdsk/c0d1s0 contains a valid RDBMS file


SQL> alter diskgroup dg2 add disk '/dev/rdsk/c0d1s6' name dg2_new_disk;---新增磁盘到磁盘组成功,注意name后跟有的v$asm_disk的name值,不是实际对应的format分区

Diskgroup altered.

SQL> select a.name,a.path from v$asm_disk a where a.group_number in(select b.group_number from v$asm_diskgroup b where b.name='DG2');
 ---查看以上磁盘组的磁盘信息(path就是磁盘对应的format分区信息)
NAME
------------------------------
PATH
--------------------------------------------------------------------------------
DG2_0001
/dev/rdsk/c0d1s3

DG2_0000
/dev/rdsk/c0d1s5

DG2_NEW_DISK
/dev/rdsk/c0d1s6


SQL> alter diskgroup dg2 drop disk '/dev/rdsk/c0d1s6';    ---此处报错是disk后跟v$asm_disk的name值,而非format分区
alter diskgroup dg2 drop disk '/dev/rdsk/c0d1s6'
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15054: disk "/DEV/RDSK/C0D1S6" does not exist in diskgroup "DG2"


SQL> /
alter diskgroup dg2 drop disk '/dev/rdsk/c0d1s6'
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15054: disk "/DEV/RDSK/C0D1S6" does not exist in diskgroup "DG2"


SQL> alter diskgroup dg2 drop disk '/dev/rdsk/c0d1s6' force;
alter diskgroup dg2 drop disk '/dev/rdsk/c0d1s6' force
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15054: disk "/DEV/RDSK/C0D1S6" does not exist in diskgroup "DG2"


SQL> alter diskgroup dg2 drop diskalter diskgroup dg2 drop disk '/dev/rdsk/c0d1s5';              
alter diskgroup dg2 drop diskalter diskgroup dg2 drop disk '/dev/rdsk/c0d1s5'
                         *
ERROR at line 1:
ORA-00905: missing keyword


SQL> alter diskgroup dg2 drop disk '/dev/rdsk/c0d1s5';
alter diskgroup dg2 drop disk '/dev/rdsk/c0d1s5'
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15054: disk "/DEV/RDSK/C0D1S5" does not exist in diskgroup "DG2"


SQL> select a.name,a.path from v$asm_disk a where a.group_number in(select b.group_number from v$asm_diskgroup b where b.name='DG2');

NAME
------------------------------
PATH
--------------------------------------------------------------------------------
DG2_0001
/dev/rdsk/c0d1s3

DG2_0000
/dev/rdsk/c0d1s5

DG2_NEW_DISK
/dev/rdsk/c0d1s6


SQL> alter diskgroup dg2 drop disk dg2_new_disk;--成功删除从磁盘组中去除一个磁盘

Diskgroup altered.

SQL> select a.name,a.path from v$asm_disk a where a.group_number in(select b.group_number from v$asm_diskgroup b where b.name='DG2');

NAME
------------------------------
PATH
--------------------------------------------------------------------------------
DG2_0001
/dev/rdsk/c0d1s3

DG2_0000
/dev/rdsk/c0d1s5


SQL> drop diskgroup dg2 including contents;---删除磁盘组

Diskgroup dropped.

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

转载于:http://blog.itpub.net/9240380/viewspace-620561/