Přidán nový LUN
[root@czorapra01 ~]# ls -ltr /dev/sd*
brw-r—– 1 root disk 8, 96 Jun 15 10:20 /dev/sdg
[root@node1 ~]# lsscsi [7:0:0:3] disk IBM VirtualDisk 1070 /dev/sdd [7:0:0:4] disk IBM VirtualDisk 1070 /dev/sde [7:0:0:5] disk IBM VirtualDisk 1070 /dev/sdf [7:0:0:6] disk IBM VirtualDisk 1070 /dev/sdg
Formátování
[root@node1 ~]# fdisk /dev/sdg Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel Building a new DOS disklabel. Changes will remain in memory only, until you decide to write them. After that, of course, the previous content won't be recoverable. Command (m for help): n Command action e extended p primary partition (1-4) Partition number (1-4): 1 First cylinder (1-18396, default 1): Using default value 1 Last cylinder or +size or +sizeM or +sizeK (1-18396, default 18396): Using default value 18396 Command (m for help): w The partition table has been altered!
Calling ioctl() to re-read partition table. Syncing disks.
[root@node1 ~]# ls -ltr /dev/sd* ... brw-r----- 1 root disk 8, 96 Jun 15 11:55 /dev/sdg brw-r----- 1 root disk 8, 97 Jun 15 11:55 /dev/sdg1
Označení
[root@node1 ~]# /etc/init.d/oracleasm listdisks ASM_DATA01 ASM_DATA02 ASM_DATA03 ASM_FRA02 OCR_VOTE01
[root@node1 ~]# /etc/init.d/oracleasm createdisk ASM_DATA04 /dev/sdg1 Marking disk "ASM_DATA04" as an ASM disk: [ OK ]
SQL> select group_number,name from v$asm_diskgroup;
GROUP_NUMBER NAME ------------ ---------- 1 FRA 2 OCR_VOTE 3 ORADATA
SQL> SELECT name, free_mb, total_mb, free_mb/total_mb*100 as percentage FROM v$asm_diskgroup;
NAME FREE_MB TOTAL_MB PERCENTAGE ---------- -------- -------- ---------- FRA 52384 102398 51,1572492 OCR_VOTE 3699 4095 90,3296703 ORADATA 39007 307195 12,6977978 SELECT MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,TOTAL_MB,FREE_MB,NAME,PATH,LABEL FROM V$ASM_DISK;
MOUNT_STAT HEADER_STATU MODE_STATU STATE TOTAL_MB FREE_MB NAME PATH LABEL ---------- ------------ ---------- ---------- -------- -------- ---------- --------------- ---------- CACHED MEMBER ONLINE NORMAL 102398 13004 ASM_DATA01 ORCL:ASM_DATA01 ASM_DATA01 CACHED MEMBER ONLINE NORMAL 102399 12999 ASM_DATA02 ORCL:ASM_DATA02 ASM_DATA02 CACHED MEMBER ONLINE NORMAL 102398 13004 ASM_DATA03 ORCL:ASM_DATA03 ASM_DATA03 CACHED MEMBER ONLINE NORMAL 102398 52384 ASM_FRA02 ORCL:ASM_FRA02 ASM_FRA02 CACHED MEMBER ONLINE NORMAL 4095 3699 OCR_VOTE01 ORCL:OCR_VOTE01 OCR_VOTE01 CLOSED PROVISIONED ONLINE NORMAL 0 0 ORCL:ASM_DATA04 ASM_DATA04
Přidání
SQL> ALTER DISKGROUP ORADATA ADD DISK 'ORCL:ASM_DATA04' NAME ASM_DATA04 SIZE 144302 M; Diskgroup altered.
Rebalance
SQL> select INST_ID, OPERATION, STATE, POWER, SOFAR, EST_WORK, EST_RATE, EST_MINUTES from GV$ASM_OPERATION;
INST_ID OPERA STAT POWER SOFAR EST_WORK EST_RATE EST_MINUTES ---------- ----- ---- ---------- ---------- ---------- ---------- ----------- 2 REBAL WAIT 1 1 REBAL RUN 1 4469 85710 3219 25
INST_ID OPERA STAT POWER SOFAR EST_WORK EST_RATE EST_MINUTES ---------- ----- ---- ---------- ---------- ---------- ---------- ----------- 2 REBAL WAIT 1 1 REBAL RUN 1 85720 85730 2798 0
Kontrola
SQL> SELECT name, free_mb, total_mb, free_mb/total_mb*100 as percentage FROM v$asm_diskgroup;
NAME FREE_MB TOTAL_MB PERCENTAGE ---------- -------- -------- ---------- FRA 52479 102398 51,2500244 OCR_VOTE 3699 4095 90,3296703 ORADATA 183306 451497 40,5996053
SQL> SELECT MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,TOTAL_MB,FREE_MB,NAME,PATH,LABEL FROM V$ASM_DISK;
MOUNT_STAT HEADER_STATU MODE_STATU STATE TOTAL_MB FREE_MB NAME PATH LABEL ---------- ------------ ---------- ---------- -------- -------- ---------- --------------- ---------- CACHED MEMBER ONLINE NORMAL 102398 17325 ASM_DATA01 ORCL:ASM_DATA01 ASM_DATA01 CACHED MEMBER ONLINE NORMAL 102399 17325 ASM_DATA02 ORCL:ASM_DATA02 ASM_DATA02 CACHED MEMBER ONLINE NORMAL 102398 17325 ASM_DATA03 ORCL:ASM_DATA03 ASM_DATA03 CACHED MEMBER ONLINE NORMAL 102398 52479 ASM_FRA02 ORCL:ASM_FRA02 ASM_FRA02 CACHED MEMBER ONLINE NORMAL 4095 3699 OCR_VOTE01 ORCL:OCR_VOTE01 OCR_VOTE01 CACHED MEMBER ONLINE NORMAL 144302 131331 ASM_DATA04 ORCL:ASM_DATA04 ASM_DATA04