Blog

le 17/06/2019
Mathieu Picque
Exadata, Oracle, Oracle 12c

Création de Diskgroup sous Exadata

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.

Mathieu Picque

Voir tous ses articles