--para linux com asmlib
--dentro do asm, verifique os paths e discos que compoem os seus DGs
SQL> set lines 132 pages 1000 trimspool on
column path format a30
select NAME, PATH, TOTAL_MB, FREE_MB, TOTAL_MB-FREE_MB as UTIL_MB,
round(((TOTAL_MB-FREE_MB)/TOTAL_MB)*100,2) PCTUTIL
from v$asm_disk order by name;SQL> SQL> 2 3
NAME PATH TOTAL_MB FREE_MB UTIL_MB PCTUTIL
------------------------------ ------------------------------ ---------- ---------- ---------- ----------
MANVOL1 ORCL:MANVOL1 272383 89385 182998 67.18
MANVOL2 ORCL:MANVOL2 272383 89403 182980 67.18
--segundo passo é identificar os discos atuais, execute os comando abaixo com root
[oracle@bdMANprd01:MANprd disks]$/etc/init.d/oracleasm listdisks
MANVOL1
MANVOL2
/etc/init.d/oracleasm querydisk /dev/*, alguns discos virão marcados como ASM disk, os demais são de so e não nos interessa --*/
ex:
[root@bdMANprd01 ~]# /etc/init.d/oracleasm querydisk /dev/* --*/
Unable to open device "/dev/bus": Block device required
Unable to open device "/dev/cciss": Block device required
Unable to open device "/dev/console": Block device required
Unable to open device "/dev/core": Block device required
Unable to open device "/dev/cpu": Block device required
Unable to open device "/dev/disk": Block device required
Disk "/dev/dm-0" is not marked an ASM disk
Disk "/dev/dm-1" is not marked an ASM disk
Disk "/dev/dm-2" is not marked an ASM disk
Disk "/dev/dm-3" is not marked an ASM disk
Disk "/dev/dm-4" is not marked an ASM disk
Disk "/dev/dm-5" is marked an ASM disk with the label "MANVOL1"
Disk "/dev/dm-6" is marked an ASM disk with the label "MANVOL2"
Disk "/dev/dm-7" is not marked an ASM disk
Unable to open device "/dev/emcpower": Block device required
Disk "/dev/emcpowerh" is not marked an ASM disk
Disk "/dev/emcpowerh1" is marked an ASM disk with the label "MANVOL1"
Disk "/dev/emcpoweri" is not marked an ASM disk
Disk "/dev/emcpoweri1" is marked an ASM disk with the label "MANVOL2"
Disk "/dev/emcpowerk" is not marked an ASM disk
Disk "/dev/emcpowerk1" is not marked an ASM disk
Disk "/dev/root" is not marked an ASM disk
Unable to open device "/dev/rtc": Block device required
Disk "/dev/sda" is not marked an ASM disk
Disk "/dev/sda1" is marked an ASM disk with the label "MANVOL1"
Disk "/dev/sdb" is not marked an ASM disk
Disk "/dev/sdb1" is marked an ASM disk with the label "MANVOL2"
Disk "/dev/sdc" is not marked an ASM disk
Disk "/dev/sdc1" is not marked an ASM disk
Disk "/dev/sdd" is not marked an ASM disk
Disk "/dev/sdd1" is marked an ASM disk with the label "MANVOL1"
Disk "/dev/sde" is not marked an ASM disk
Disk "/dev/sde1" is marked an ASM disk with the label "MANVOL2"
Disk "/dev/sdf" is not marked an ASM disk
Disk "/dev/sdf1" is not marked an ASM disk
--apos o reboot, que é necessário para apresentar os novos discos e validar a criação das novas partições, como root, crie os novos discos:
/etc/init.d/oracleasm createdisk MANVOL1001 /dev/mapper/mpath0p1
/etc/init.d/oracleasm createdisk MANVOL1002 /dev/mapper/mpath1p1
No asm esses novos discos irão aparecer como candidatos, basta adiciona-los ao DG e está pronto.
Nenhum comentário:
Postar um comentário