Add and drop Disks to ASM Disk Group in Oracle
add and drop disks to asm disk group in oracle | learn more than 100 important question and concepts with learnomate technologies
oracle configurationintermediate
by OracleDba
12 views
add and drop disks to asm disk group in oracle | learn more than 100 important question and concepts with learnomate technologies
12345678910111213
SQL> alter diskgroup DATA add disk '/dev/oracleasm/disks/DATA01';
Diskgroup altered.
SQL> alter diskgroup DATA add disk '/dev/oracleasm/disks/DATA02';
Diskgroup altered.
SQL>
ALTER DISKGROUP DATA ADD DISK '/dev/mapper/asmdata1' NAME DATA_0001 SIZE 102399 M REBALANCE POWER 10;
select DISK_NUMBER,name ,PATH, MOUNT_DATE from v$asm_disk;1234567
select DISK_NUMBER,name ,PATH, MOUNT_DATE from v$asm_disk;
alter diskgroup DATA drop disk DATA_0001;
select * from v$asm_operation;
ALTER DISKGROUP DATA REBALANCE POWER 8 NOWAIT;Please to add comments
No comments yet. Be the first to comment!