alter diskgroup ZDPRODDATA rebalance power 11;
alter diskgroup ZDPRODDATA drop disk 'DATA26' rebalance power 11;
select * from v$asm_operation;
select * from gv$asm_operation;
alter diskgroup ZDPRODDATA add disk 'ORCL:DATA26' rebalance power 11;
select * from v$asm_operation;
select * from gv$asm_operation;
alter diskgroup ZDPRODDATA rebalance power 1;
/etc/init.d/oracleasm createdisk ASMDISK_NEW_SAN_1 /dev/mapper/mpathbp1
/etc/init.d/oracleasm scandisks
/etc/init.d/oracleasm listdisks
/usr/sbin/oracleasm-discover 'ORCL:*'
show parameter ASM_DISKSTRING
select path from v$asm_disk;
alter diskgroup DATA add disk
'ORCL:ASMDISK_NEW_SAN_1',
'ORCL:ASMDISK_NEW_SAN_2',
'ORCL:ASMDISK_NEW_SAN_3',
'ORCL:ASMDISK_NEW_SAN_4',
'ORCL:ASMDISK_NEW_SAN_5',
'ORCL:ASMDISK_NEW_SAN_6',
'ORCL:ASMDISK_NEW_SAN_7',
'ORCL:ASMDISK_NEW_SAN_8',
'ORCL:ASMDISK_NEW_SAN_9',
'ORCL:ASMDISK_NEW_SAN_10' rebalance power 11;
select * from v$asm_operation;
select * from gv$asm_operation;
alter diskgroup DATA drop disk
ASMDISK_OLD_SAN_1,
ASMDISK_OLD_SAN_2,
ASMDISK_OLD_SAN_3,
ASMDISK_OLD_SAN_4,
ASMDISK_OLD_SAN_5,
ASMDISK_OLD_SAN_6,
ASMDISK_OLD_SAN_7,
ASMDISK_OLD_SAN_8,
ASMDISK_OLD_SAN_9,
ASMDISK_OLD_SAN_10 rebalance power 11;
select * from v$asm_operation;
select * from gv$asm_operation;
alter diskgroup DATA add disk
'ORCL:ASMDISK_NEW_SAN_1',
'ORCL:ASMDISK_NEW_SAN_2',
'ORCL:ASMDISK_NEW_SAN_3',
'ORCL:ASMDISK_NEW_SAN_4',
'ORCL:ASMDISK_NEW_SAN_5',
'ORCL:ASMDISK_NEW_SAN_6',
'ORCL:ASMDISK_NEW_SAN_7',
'ORCL:ASMDISK_NEW_SAN_8',
'ORCL:ASMDISK_NEW_SAN_9',
'ORCL:ASMDISK_NEW_SAN_10'
drop disk
ASMDISK_OLD_SAN_1,
ASMDISK_OLD_SAN_2,
ASMDISK_OLD_SAN_3,
ASMDISK_OLD_SAN_4,
ASMDISK_OLD_SAN_5,
ASMDISK_OLD_SAN_6,
ASMDISK_OLD_SAN_7,
ASMDISK_OLD_SAN_8,
ASMDISK_OLD_SAN_9,
ASMDISK_OLD_SAN_10 rebalance power 11;
select * from v$asm_operation;
select * from gv$asm_operation;
set lines 200 pages 50000
col name for a25
col path for a55
select group_number,disk_number,name,path,total_mb/1024 total_G,path,mode_status,repair_timer from v$asm_disk order by group_number,disk_number;
select group_number,name,type,total_mb, free_mb,state from v$asm_diskgroup_stat;
select group_number,name,type,total_mb, free_mb,state from v$asm_diskgroup;
NOTE:557348.1 - How To Add a New Disk(s) to An Existing Diskgroup on RAC Cluster or Standalone ASM Configuration (Best Practices).
NOTE:837308.1 - Exact Steps To Migrate ASM Diskgroups To Another SAN/Disk-Array/DAS/etc Without Downtime
NOTE:946213.1 - How To Add Back An ASM Disk or Failgroup (Normal or High Redundancy) After A Transient Failure Occurred Or When The DISK_REPAIR_TIME Attribute Expired (10.1 to 12.1)?
NOTE:1638177.1 - Move OCR , Vote File , ASM SPILE to new Diskgroup
NOTE:1918350.1 - Exact Steps to Migrate ASM Diskgroups to Another SAN/Disk-Array/DAS/Etc without Downtime (When ASMLIB Devices Are Involved)
http://www.killdb.com/2013/08/05/asm-rebalance-%e5%8e%9f%e7%90%86/
https://blog.csdn.net/liangliangsmd/article/details/38231621
最新评论
这个牛
放下欲望,男人从来不醉,充分且必要
勇气、责任、自信、创新,为天下先!
软件即数据,软件即服务,软件即管理,软件就是对人类各种社会活动的仿真和记录。软件很重要,但软件不可能凌驾于业务之上,尤其不可能高人一等。