ORACL E ASM 环境下添加disk

第一步，在服务器上添加相应的存储的映射
第二步， format
fdisk /dev/sdk
第三部 Create Disk U25
oracleasm createdisk U25 /dev/sdk1
Marking disk "/dev/sdk1" as an ASM disk: [ OK ]
[root@oracle01 init.d]# ./oracleasm listdisks;
U02
U03
U04
U05
U07
U15
U16
U25 <--Here!! [root@oracle01 init.d]# 另一个ORACLE node 同步 [root@oracle02 init.d]# ./oracleasm Usae: ./oracleasm {start|stop|restart|enable|disable|configure|createdisk|deletedisk|querydisk|listdisks|scandisks|status} [root@oracle02 init.d]# ./oracleasm scandisks Scanning system for ASM disks: [ OK ] --时间要久一点-- [root@oracle02 init.d]# [root@oracle02 init.d]# [root@oracle02 init.d]# ./oracleasm listdisks U02 U03 U04 U05 U07 U15 U16 U25 --这里看到成功了 我们这里用EM添加diskgroup 中的disk 从 Log中找到 一下内容 Thu Jul 09 14:50:20 2009 SQL> ALTER DISKGROUP U05 ADD DISK 'ORCL:U25' SIZE 102398 M
NOTE: Assigning number (4,0) to disk (ORCL:U25)
NOTE: requesting all-instance membership refresh for group=4
NOTE: initializing header on grp 4 disk U25
NOTE: cache opening disk 0 of grp 4: U25 label:U25
NOTE: requesting all-instance disk validation for group=4

[oracle@oracle01 ~]$ asmcmd
ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Name
MOUNTED EXTERN N 512 4096 1048576 50244 12876 0 12876 0 U02/
MOUNTED EXTERN N 512 4096 1048576 24644 0 0 0 0 U03/
MOUNTED EXTERN N 512 4096 1048576 51199 10994 0 10994 0 U04/
MOUNTED EXTERN Y 512 4096 1048576 153597 101428 0 101428 0 U05/
MOUNTED EXTERN N 512 4096 1048576 5115 4013 0 4013 0 U07/
ASMCMD>

当然 sqlpols 也是可以的


col name format a20
col path format a20
col mode_status a20
SQL> select name, path, mode_status, state, disk_number from v$asm_disk;

NAME PATH MODE_STATUS STATE DISK_NUMBER
-------------------- -------------------- --------------------- ------------------------ -----------
ORCL:U04 ONLINE NORMAL 2
ORCL:U05 ONLINE NORMAL 3
U02 ORCL:U02 ONLINE NORMAL 0
U03 ORCL:U03 ONLINE NORMAL 0
U07 ORCL:U07 ONLINE NORMAL 0
U15 ORCL:U15 ONLINE NORMAL 1
U16 ORCL:U16 ONLINE NORMAL 2
U25 ORCL:U25 ONLINE NORMAL 0


SQL> select name,total_mb,free_mb from v$asm_diskgroup;

NAME TOTAL_MB FREE_MB
-------------------- ---------- ----------
U02 50244 12876
U03 24644 0
U04 51199 10994
U05 153597 101295
U07 5115 4013