Oracle asm磁盘中新加磁盘
1. 新分LUN到主机上，使用fdisk -l进行检查，以下命令可以检查磁盘的scsi_id号。
scsi_id -u -g /dev/sd*
2. 重启udev进程/sbin/start_dev
3. 检查磁盘情况
sqlplus / as sysasm;
SQL> col name for a20;
SQL> col path for a20;
SQL> select name,path from v$asm_disk;
NAME PATH
-------------------- --------------------
DATAC1_0000 /dev/sddlmaa
DATAC1_0001 /dev/sddlmab
DATAC1_0002 /dev/sddlmac
/dev/sddlmad
4. 添加新磁盘
alter diskgroup datac1 add disk '/dev/sddlmad';
5.加入完成后检查
SQL> col name for a20;
SQL> col path for a20;
SQL> select name,path from v$asm_disk;
NAME PATH
-------------------- --------------------
DATAC1_0000 /dev/sddlmaa
DATAC1_0001 /dev/sddlmab
DATAC1_0002 /dev/sddlmac
DATAC1_0003 /dev/sddlmad
scsi_id -u -g /dev/sd*
2. 重启udev进程/sbin/start_dev
3. 检查磁盘情况
sqlplus / as sysasm;
SQL> col name for a20;
SQL> col path for a20;
SQL> select name,path from v$asm_disk;
NAME PATH
-------------------- --------------------
DATAC1_0000 /dev/sddlmaa
DATAC1_0001 /dev/sddlmab
DATAC1_0002 /dev/sddlmac
/dev/sddlmad
4. 添加新磁盘
alter diskgroup datac1 add disk '/dev/sddlmad';
5.加入完成后检查
SQL> col name for a20;
SQL> col path for a20;
SQL> select name,path from v$asm_disk;
NAME PATH
-------------------- --------------------
DATAC1_0000 /dev/sddlmaa
DATAC1_0001 /dev/sddlmab
DATAC1_0002 /dev/sddlmac
DATAC1_0003 /dev/sddlmad
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/21374452/viewspace-2145894/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
