Cet article a pour but de vous présenter la méthode pour créer 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
$ cellcli list griddisk where name like '<NOM_GROUPE_DISQUE>.*' attributes name, size
Création des Griddisk
Vous allez devoir créer un griddisk par celldisk.
Syntaxe :
CREATE GRIDDISK <NomGriddisk> cellDisk=<Celldisk>, size=<Taille>, availableTo='<BaseDevantAccéderAuFuturDG>’;
Se connecter aux 3 cells.
NE PAS COMMENCER AVANT D’ÊTRE CONNECTÉ AUX 3 CELLS !!!!
Utiliser cellcli.
CELL 1 :
CREATE GRIDDISK DATA14_CD_00_celadm01 cellDisk=CD_00_celadm01, size=348G, availableTo='+ASM,BDD1,BDD2'; CREATE GRIDDISK DATA14_CD_01_celadm01 cellDisk=CD_01_celadm01, size=348G, availableTo='+ASM,BDD1,BDD2'; CREATE GRIDDISK DATA14_CD_02_celadm01 cellDisk=CD_02_celadm01, size=348G, availableTo='+ASM,BDD1,BDD2'; CREATE GRIDDISK DATA14_CD_03_celadm01 cellDisk=CD_03_celadm01, size=348G, availableTo='+ASM,BDD1,BDD2'; CREATE GRIDDISK DATA14_CD_04_celadm01 cellDisk=CD_04_celadm01, size=348G, availableTo='+ASM,BDD1,BDD2'; CREATE GRIDDISK DATA14_CD_05_celadm01 cellDisk=CD_05_celadm01, size=348G, availableTo='+ASM,BDD1,BDD2'; CREATE GRIDDISK DATA14_CD_06_celadm01 cellDisk=CD_06_celadm01, size=348G, availableTo='+ASM,BDD1,BDD2'; CREATE GRIDDISK DATA14_CD_07_celadm01 cellDisk=CD_07_celadm01, size=348G, availableTo='+ASM,BDD1,BDD2'; CREATE GRIDDISK DATA14_CD_08_celadm01 cellDisk=CD_08_celadm01, size=348G, availableTo='+ASM,BDD1,BDD2'; CREATE GRIDDISK DATA14_CD_09_celadm01 cellDisk=CD_09_celadm01, size=348G, availableTo='+ASM,BDD1,BDD2'; CREATE GRIDDISK DATA14_CD_10_celadm01 cellDisk=CD_10_celadm01, size=348G, availableTo='+ASM,BDD1,BDD2'; CREATE GRIDDISK DATA14_CD_11_celadm01 cellDisk=CD_11_celadm01, size=348G, availableTo='+ASM,BDD1,BDD2';
CELL 2 :
CREATE GRIDDISK DATA14_CD_00_celadm02 cellDisk=CD_00_celadm02, size=348G, availableTo='+ASM,BDD1,BDD2'; CREATE GRIDDISK DATA14_CD_01_celadm02 cellDisk=CD_01_celadm02, size=348G, availableTo='+ASM,BDD1,BDD2'; CREATE GRIDDISK DATA14_CD_02_celadm02 cellDisk=CD_02_celadm02, size=348G, availableTo='+ASM,BDD1,BDD2'; CREATE GRIDDISK DATA14_CD_03_celadm02 cellDisk=CD_03_celadm02, size=348G, availableTo='+ASM,BDD1,BDD2'; CREATE GRIDDISK DATA14_CD_04_celadm02 cellDisk=CD_04_celadm02, size=348G, availableTo='+ASM,BDD1,BDD2'; CREATE GRIDDISK DATA14_CD_05_celadm02 cellDisk=CD_05_celadm02, size=348G, availableTo='+ASM,BDD1,BDD2'; CREATE GRIDDISK DATA14_CD_06_celadm02 cellDisk=CD_06_celadm02, size=348G, availableTo='+ASM,BDD1,BDD2'; CREATE GRIDDISK DATA14_CD_07_celadm02 cellDisk=CD_07_celadm02, size=348G, availableTo='+ASM,BDD1,BDD2'; CREATE GRIDDISK DATA14_CD_08_celadm02 cellDisk=CD_08_celadm02, size=348G, availableTo='+ASM,BDD1,BDD2'; CREATE GRIDDISK DATA14_CD_09_celadm02 cellDisk=CD_09_celadm02, size=348G, availableTo='+ASM,BDD1,BDD2'; CREATE GRIDDISK DATA14_CD_10_celadm02 cellDisk=CD_10_celadm02, size=348G, availableTo='+ASM,BDD1,BDD2'; CREATE GRIDDISK DATA14_CD_11_celadm02 cellDisk=CD_11_celadm02, size=348G, availableTo='+ASM,BDD1,BDD2';
CELL 3 :
CREATE GRIDDISK RECO14_CD_00_celadm03 cellDisk=CD_00_celadm03, size=115G, availableTo='+ASM,BDD1,BDD2'; CREATE GRIDDISK DATA14_CD_01_celadm03 cellDisk=CD_01_celadm03, size=348G, availableTo='+ASM,BDD1,BDD2'; CREATE GRIDDISK DATA14_CD_02_celadm03 cellDisk=CD_02_celadm03, size=348G, availableTo='+ASM,BDD1,BDD2'; CREATE GRIDDISK DATA14_CD_03_celadm03 cellDisk=CD_03_celadm03, size=348G, availableTo='+ASM,BDD1,BDD2'; CREATE GRIDDISK DATA14_CD_04_celadm03 cellDisk=CD_04_celadm03, size=348G, availableTo='+ASM,BDD1,BDD2'; CREATE GRIDDISK DATA14_CD_05_celadm03 cellDisk=CD_05_celadm03, size=348G, availableTo='+ASM,BDD1,BDD2'; CREATE GRIDDISK DATA14_CD_06_celadm03 cellDisk=CD_06_celadm03, size=348G, availableTo='+ASM,BDD1,BDD2'; CREATE GRIDDISK DATA14_CD_07_celadm03 cellDisk=CD_07_celadm03, size=348G, availableTo='+ASM,BDD1,BDD2'; CREATE GRIDDISK DATA14_CD_08_celadm03 cellDisk=CD_08_celadm03, size=348G, availableTo='+ASM,BDD1,BDD2'; CREATE GRIDDISK DATA14_CD_09_celadm03 cellDisk=CD_09_celadm03, size=348G, availableTo='+ASM,BDD1,BDD2'; CREATE GRIDDISK DATA14_CD_10_celadm03 cellDisk=CD_10_celadm03, size=348G, availableTo='+ASM,BDD1,BDD2'; CREATE GRIDDISK DATA14_CD_11_celadm03 cellDisk=CD_11_celadm03, size=348G, availableTo='+ASM,BDD1,BDD2';
Création du Diskgroup
[oracle@serveur01: /home/oracle] $ sqlplus / as sysasm SQL*Plus: Release 12.2.0.1.0 Production on Mon Dec 17 17:08:21 2018 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production SQL> CREATE DISKGROUP DATA HIGH REDUNDANCY DISK 'o/*/DATA14*' ATTRIBUTE 'au_size' = '4M', 'content.type' = 'data', 'cell.smart_scan_capable'='TRUE', 'compatible.rdbms'='11.2.0.4.0', 'compatible.asm'='12.1.0.2.0';
A vous d’adapter les paramètres pour votre Diskgroup.
Sur deuxième nœud :
[oracle@serveur02: /home/oracle] $ sqlplus / as sysasm SQL*Plus: Release 12.2.0.1.0 Production on Mon Dec 17 17:08:21 2018 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production SQL> alter diskgroup DATA mount; Diskgroup altered.
Vérifications
[oracle@serveur01: /home/oracle] $ asmcmd lsdg DATA State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED HIGH N 512 512 4096 4194304 10321920 10321128 573440 3249229 0 N DATA /
En espérant que cela vous aura été utile. 😉
Et si vous souhaitez vous former sur Exadata, découvrez notre Formation Exadata Administration.