Oracle RAC, ASM, Exadata, Cloud, and More..: Exadata storage objects

Hierarch of Exadata Storage Objects:

DISK-> LUN-> CELLDISK -> GRIDDISK-> ASM DISK

celladmin@cell ~]$ cellcli
CellCLI: Release 11.2.2.1.0 - Production on Thu Jan 10 15:43:39 PST 2013

Copyright (c) 2007, 2009, Oracle. All rights reserved.
Cell Efficiency Ratio: 17M

CellCLI> list cell detail
         name:                   cell
         bmcType:                absent
         cellVersion:            OSS_MAIN_LINUX_101005
         cpuCount:               1
         fanCount:               1/1
         fanStatus:              normal
         id:                     3c4bc34b-9acd-4a98-a910-c660c9c76c03
         interconnectCount:      1
         interconnect1:          eth0
         iormBoost:              0.0
         ipaddress1:             192.168.10.101/24
         kernelVersion:          2.6.18-194.el5
         makeModel:              Fake hardware
         metricHistoryDays:      7
         offloadEfficiency:      17.3M
         powerCount:             1/1
         powerStatus:            normal
         status:                 online
         temperatureReading:     0.0
         temperatureStatus:      normal
         upTime:                 3 days, 6:22
         cellsrvStatus:          running
         msStatus:               running
         rsStatus:               running

CellCLI> list physicaldisk
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/FLASH01       /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/FLASH01       normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/FLASH02       /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/FLASH02       normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/FLASH03       /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/FLASH03       normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/FLASH04       /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/FLASH04       normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk01        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk01        normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk02        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk02        normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk03        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk03        normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk04        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk04        normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk05        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk05        normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk06        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk06        normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk07        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk07        normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk08        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk08        normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk09        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk09        normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk10        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk10        normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk11        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk11        normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk12        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk12        normal

CellCLI> list lun
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/FLASH01       /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/FLASH01       normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/FLASH02       /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/FLASH02       normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/FLASH03       /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/FLASH03       normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/FLASH04       /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/FLASH04       normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk01        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk01        normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk02        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk02        normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk03        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk03        normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk04        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk04        normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk05        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk05        normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk06        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk06        normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk07        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk07        normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk08        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk08        normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk09        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk09        normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk10        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk10        normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk11        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk11        normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk12        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk12        normal

CellCLI> list lun where disktype=harddisk
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk01        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk01        normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk02        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk02        normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk03        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk03        normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk04        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk04        normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk05        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk05        normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk06        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk06        normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk07        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk07        normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk08        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk08        normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk09        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk09        normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk10        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk10        normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk11        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk11        normal
         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk12        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk12        normal

CellCLI> list lun where name like '.*disk01' detail
         name:                   /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk01
         cellDisk:               CD_disk01_cell
         deviceName:             /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk01
         diskType:               HardDisk
         id:                     /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk01
         isSystemLun:            FALSE
         lunAutoCreate:          FALSE
         lunSize:                500M
         physicalDrives:         /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk01
         raidLevel:              "RAID 0"
         status:                 normal

CellCLI> list celldisk CD_disk01_cell detail
         name:                   CD_disk01_cell
         comment:
         creationTime:           2012-09-04T18:12:55-07:00
         deviceName:             /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk01
         devicePartition:        /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk01
         diskType:               HardDisk
         errorCount:             0
         freeSpace:              0
         id:                     00000139-93fc-a83d-0000-000000000000
         interleaving:           none
         lun:                    /opt/oracle/cell11.2.2.1.0_LINUX_101005/disks/raw/disk01
         raidLevel:              "RAID 0"
         size:                   496M
         status:                 normal

CellCLI> list griddisk where celldisk=CD_disk01_cell detail
         name:                   data2_CD_disk01_cell
         availableTo:
         cellDisk:               CD_disk01_cell
         comment:
         creationTime:           2012-09-04T23:46:14-07:00
         diskType:               HardDisk
         errorCount:             0
         id:                     00000139-952d-dd5d-0000-000000000000
         offset:                 48M
         size:                   448M
         status:                 active

SQL> select name, path, state, total_mb from v$asm_disk
2 where name like '%DATA2_CD_DISK01_CELL%';

NAME PATH STATE TOTAL_MB
------------------------------ ---------------------------------------------------------------- -------- ----------
DATA2_CD_DISK01_CELL o/192.168.10.101/data2_CD_disk01_cell NORMAL 448

SQL> select a.name disk, b.name diskgroup
2 from v$asm_disk a, v$asm_diskgroup b
3 where b.group_number = a.group_number
4 and a.name like '%DATA2_CD_DISK01_CELL%';

DISK DISKGROUP
------------------------------ ------------------------------
DATA2_CD_DISK01_CELL DATA

Oracle RAC, ASM, Exadata, Cloud, and More..

Exadata storage objects

No comments:

Post a Comment