Create Flash devices and Flash-based disk group


Exam your current flash-based cell disks

CellCLI> list celldisk attributes name, freeSpace where diskType=FlashDisk;
FD_00_cell  500M
FD_01_cell  500M
FD_02_cell  500M
FD_03_cell  500M

Create Smart Flash Cache with 1G

CellCLI> create flashcache all size=1024m;
Flash cache cell_FLASHCACHE successfully created


So, the available free space on all flash-based cell disks are:
CellCLI> list celldisk attributes name, freeSpace where diskType=FlashDisk;
FD_00_cell 192M
FD_01_cell 192M
FD_02_cell 192M
FD_03_cell 192M

CellCLI> create griddisk all flashdisk prefix=flash
GridDisk flash_FD_00_cell successfully created
GridDisk flash_FD_01_cell successfully created
GridDisk flash_FD_02_cell successfully created
GridDisk flash_FD_03_cell successfully created

Flash grid disks are created across the cells

CellCLI> list griddisk attributes name, size, ASMModeStatus where disktype=flashdisk;
flash_FD_00_cell 192M UNUSED
flash_FD_01_cell 192M UNUSED
flash_FD_02_cell 192M UNUSED
flash_FD_03_cell 192M UNUSED

SQL >  select path, header_status from v$asm_disk
  2* where path like '%flash%'
PATH HEADER_STATU
---------------------------------------------------------------- ------------
o/192.168.10.101/flash_FD_02_cell CANDIDATE
o/192.168.10.101/flash_FD_03_cell CANDIDATE
o/192.168.10.101/flash_FD_01_cell CANDIDATE
o/192.168.10.101/flash_FD_00_cell CANDIDATE

Posted by No comments:
Labels:

Create grid disks and ASM diskgroup

Prepare grid disks- Create set of griddisks on all available hard disks space cell disks

CellCLI> list griddisk
 reco_CD_disk07_cell  active
 reco_CD_disk08_cell  active
 reco_CD_disk09_cell  active
 reco_CD_disk10_cell  active
 reco_CD_disk11_cell  active
 reco_CD_disk12_cell  active

CellCLI> create griddisk all harddisk prefix=data2, size=100m;
Cell disks were skipped because they had no freespace for grid disks: CD_disk07_cell, CD_disk08_cell, CD_disk09_cell, CD_disk10_cell, CD_disk11_cell, CD_disk12_cell.
GridDisk data2_CD_disk01_cell successfully created
GridDisk data2_CD_disk02_cell successfully created
GridDisk data2_CD_disk03_cell successfully created
GridDisk data2_CD_disk04_cell successfully created
GridDisk data2_CD_disk05_cell successfully created
GridDisk data2_CD_disk06_cell successfully created

CellCLI> list griddisk;
 data2_CD_disk01_cell  active
 data2_CD_disk02_cell  active
 data2_CD_disk03_cell  active
 data2_CD_disk04_cell  active
 data2_CD_disk05_cell  active
 data2_CD_disk06_cell  active
 reco_CD_disk07_cell   active
 reco_CD_disk08_cell   active
 reco_CD_disk09_cell   active
 reco_CD_disk10_cell   active
 reco_CD_disk11_cell   active
 reco_CD_disk12_cell   active

CellCLI> list griddisk attributes name, size, ASMModeStatus
 data2_CD_disk01_cell  96M   UNUSED
 data2_CD_disk02_cell  96M   UNUSED
 data2_CD_disk03_cell  96M   UNUSED
 data2_CD_disk04_cell  96M   UNUSED
 data2_CD_disk05_cell  96M   UNUSED
 data2_CD_disk06_cell  96M   UNUSED
 reco_CD_disk07_cell   448M  ONLINE
 reco_CD_disk08_cell   448M  ONLINE
 reco_CD_disk09_cell   448M  ONLINE
 reco_CD_disk10_cell   448M  ONLINE
 reco_CD_disk11_cell   448M  ONLINE
 reco_CD_disk12_cell   448M  ONLINE

Create ASM diskgroup with AU_SIZE=4M as recommended value

SQL> create diskgroup DATA external redundancy disk 'o/*/data2*' attribute 'compatible.rdbms' = '11.2.0.0.0', 'compatible.asm' = '11.2.0.0.0', 'cell.smart_scan_capable' = 'TRUE', 'au_size' = '4M';

Diskgroup created.


SQL> select name, state from v$asm_diskgroup;

NAME     STATE
-------------------------------- -----------
DATA     MOUNTED
FRA     MOUNTED


CellCLI> list griddisk attributes name, size, ASMModeStatus
 data2_CD_disk01_cell  96M   ONLINE
 data2_CD_disk02_cell  96M   ONLINE
 data2_CD_disk03_cell  96M   ONLINE
 data2_CD_disk04_cell  96M   ONLINE
 data2_CD_disk05_cell  96M   ONLINE
 data2_CD_disk06_cell  96M   ONLINE
 reco_CD_disk07_cell   448M  ONLINE
 reco_CD_disk08_cell   448M  ONLINE
 reco_CD_disk09_cell   448M  ONLINE
 reco_CD_disk10_cell   448M  ONLINE
 reco_CD_disk11_cell   448M  ONLINE
 reco_CD_disk12_cell   448M  ONLINE
Posted by No comments:
Labels:

Exadata configuration tasks cell and storage provisioning

To run the performance test on the cell, you use Calibrate:
CellCLI> alter cell shutdown services cellsrv
Stopping CELLSRV services... 
The SHUTDOWN of CELLSRV services was successful.
CellCLI> calibrate;
Calibration will take a few minutes...
Aggregate random read throughput across all hard disk luns: 139 MBPS
Aggregate random read throughput across all flash disk luns: 2720.05 MBPS
Aggregate random read IOs per second (IOPS) across all hard disk luns: 1052
Aggregate random read IOs per second (IOPS) across all flash disk luns: 143248
Controller read throughput: 5477.08 MBPS
Calibrating hard disks (read only) ...
Calibrating flash disks (read only, note that writes will be significantly slower) ...
…….
CALIBRATE stress test is now running...
Calibration has finished.

CellCLI> alter cell validate configuration;
Cell cell successfully altered

CellCLI> list celldisk where freespace !=0
 CD_disk01      normal

CellCLI> create griddisk all harddisk prefix=datagri


CellCLI> drop celldisk CD_disk01_cell;
CellDisk CD_disk01_cell successfully dropped

CellCLI> list celldisk

CellCLI> create celldisk all;
CellDisk CD_disk01  successfully created

CellCLI> list griddisk attributes name where asmdeactivationoutcome !='Yes'

CellCLI> alter griddisk all inactive

CellCLI> list griddisk attributes name where asmdeactivationoutcome !='Yes'


CellCLI> alter griddisk all inactive

To power off Exadata Storage Servers

shutdown -h -y now


CellCLI> list griddisk

CellCLI> list griddisk attributes name, asmmodestatus

Cellcli > alter grid disk all active

CellCLI> list griddisk

CellCLI> alter griddisk all active
CellCLI> list griddisk attributes name, asmmodestatus


CellCLI> list griddisk attributes name, asmmodestatus

CellCLI> list griddisk attributes name, asmmodestatus
CellCLI> list griddisk attributes name, asmmodestatus

CellCLI> list griddisk


Posted by No comments:
Labels:
Subscribe to: Posts (Atom)