Cet article a pour but de vous présenter la méthode pour agrandrir un diskgroup sur un environnement EXADATA.

Vérifier depuis les cells l’espace disponible :

1) Vérifier l’espace disponible sur les celldisks (attribut freespace)

$ cellcli

list celldisk where name like 'CD.*' attributes name, lun, size, freespace, freespacemap

2) Lister les disques du groupe de disques et augmenter à la taille désirée

$ cellcli

list griddisk where name like '<NOM_GROUPE_DISQUE>.*' attributes name, size

Etat des lieux des disks :

[oracle@serveur01: /home/oracle] $ sqlplus / as sysasm

 
SQL*Plus: Release 12.1.0.2.0 Production on Thu Jan 19 09:42:58 2017

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

set pages 200
set lines 150
SELECT d.name AS asmdisk, d.total_mb, d.mount_status, d.state, dg.name AS diskgroup FROM V$ASM_DISKGROUP dg, V$ASM_DISK d WHERE dg.group_number = d.group_number and dg.name='RECO';

ASMDISK TOTAL_MB MOUNT_S STATE DISKGROUP
------------------------------ ---------- ------- -------- ------------------------------
RECO_CD_00_CELADM01 25600 CACHED NORMAL RECO
RECO_CD_03_CELADM01 25600 CACHED NORMAL RECO
RECO_CD_02_CELADM01 25600 CACHED NORMAL RECO
RECO_CD_05_CELADM01 25600 CACHED NORMAL RECO
RECO_CD_04_CELADM01 25600 CACHED NORMAL RECO
RECO_CD_01_CELADM01 25600 CACHED NORMAL RECO
RECO_CD_05_CELADM02 25600 CACHED NORMAL RECO
RECO_CD_04_CELADM02 25600 CACHED NORMAL RECO
RECO_CD_00_CELADM03 25600 CACHED NORMAL RECO
RECO_CD_04_CELADM03 25600 CACHED NORMAL RECO
RECO_CD_02_CELADM03 25600 CACHED NORMAL RECO
RECO_CD_03_CELADM03 25600 CACHED NORMAL RECO
RECO_CD_01_CELADM03 25600 CACHED NORMAL RECO
RECO_CD_05_CELADM03 25600 CACHED NORMAL RECO
RECO_CD_02_CELADM02 25600 CACHED NORMAL RECO
RECO_CD_03_CELADM02 25600 CACHED NORMAL RECO
RECO_CD_01_CELADM02 25600 CACHED NORMAL RECO
RECO_CD_00_CELADM02 25600 CACHED NORMAL RECO

Préparation des commandes d’agrandissement :

Se connecter aux 3 cells.

select 'alter griddisk '||d.name||' size=40G;' FROM V$ASM_DISKGROUP dg, V$ASM_DISK d WHERE dg.group_number = d.group_number and dg.name='C2DT12' order by d.disk_number;

'ALTERGRIDDISK'||D.NAME||'SIZE=40G;'
-------------------------------------------------------
alter griddisk RECO_CD_00_CELADM03 size=40G;
alter griddisk RECO_CD_04_CELADM03 size=40G;
alter griddisk RECO_CD_02_CELADM03 size=40G;
alter griddisk RECO_CD_03_CELADM03 size=40G;
alter griddisk RECO_CD_01_CELADM03 size=40G;
alter griddisk RECO_CD_05_CELADM03 size=40G;
alter griddisk RECO_CD_02_CELADM02 size=40G;
alter griddisk RECO_CD_03_CELADM02 size=40G;
alter griddisk RECO_CD_01_CELADM02 size=40G;
alter griddisk RECO_CD_00_CELADM02 size=40G;
alter griddisk RECO_CD_05_CELADM02 size=40G;
alter griddisk RECO_CD_04_CELADM02 size=40G;
alter griddisk RECO_CD_04_CELADM01 size=40G;
alter griddisk RECO_CD_01_CELADM01 size=40G;
alter griddisk RECO_CD_02_CELADM01 size=40G;
alter griddisk RECO_CD_05_CELADM01 size=40G;
alter griddisk RECO_CD_00_CELADM01 size=40G;
alter griddisk RECO_CD_03_CELADM01 size=40G;

Agrandissement des grid disks :

Se connecter aux 3 cells.
NE PAS COMMENCER AVANT D’ÊTRE CONNECTÉ AUX 3 CELLS !!!!

Uiliser cellcli

CELL 1 :

alter griddisk RECO_CD_04_CELADM01 size=40G;
alter griddisk RECO_CD_01_CELADM01 size=40G;
alter griddisk RECO_CD_02_CELADM01 size=40G;
alter griddisk RECO_CD_05_CELADM01 size=40G;
alter griddisk RECO_CD_00_CELADM01 size=40G;
alter griddisk RECO_CD_03_CELADM01 size=40G;

CELL 2 :

alter griddisk RECO_CD_02_CELADM02 size=40G;
alter griddisk RECO_CD_03_CELADM02 size=40G;
alter griddisk RECO_CD_01_CELADM02 size=40G;
alter griddisk RECO_CD_00_CELADM02 size=40G;
alter griddisk RECO_CD_05_CELADM02 size=40G;
alter griddisk RECO_CD_04_CELADM02 size=40G;

CELL 3 :

alter griddisk RECO_CD_00_CELADM03 size=40G;
alter griddisk RECO_CD_04_CELADM03 size=40G;
alter griddisk RECO_CD_02_CELADM03 size=40G;
alter griddisk RECO_CD_03_CELADM03 size=40G;
alter griddisk RECO_CD_01_CELADM03 size=40G;
alter griddisk RECO_CD_05_CELADM03 size=40G;

Agrandissement du Diskgroup :

Revenir sur l’instance ASM :

alter diskgroup RECO resize all;

Vérifications :

[oracle@serveur01: /home/oracle] $ asmcmd
ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED HIGH N 512 4096 1048576 3686400 675555 409600 88651 0 N DATA/
MOUNTED HIGH N 512 4096 1048576 737280 364644 81920 94241 0 N RECO/

En espérant que cela vous aura été utile. 😉