1. User's Guide
  2. Using the CellCLI Utility
  3. CellCLI Command Reference
  4. LIST
  5. LIST GRIDDISK

7.7.12.12 LIST GRIDDISK

Purpose

The LIST GRIDDISK command displays attributes for one or more Oracle Exadata Storage Server grid disks determined by the specified attributes and filters.

Syntax

LIST GRIDDISK [ name |  attribute_filters ]  [attribute_list] [DETAIL]

Usage Notes

  • You can use the DESCRIBE GRIDDISK command to view the complete list of GRIDDISK attributes.

  • The asmDeactivationOutcome attribute can be used to determine if a grid disk can be deactivated without loss of data. This attribute is not included in the list of attributes shown by the DESCRIBE GRIDDISK command. When using this attribute, a YES in the output means the grid disk can be deactivated.

  • The asmModeStatus attribute can be used to determine the current usage of a grid disk. This attribute is not included in the list of attributes shown by the DESCRIBE GRIDDISK command. The possible values for this attribute are as follows:

    • ONLINE: Oracle ASM is actively using this grid disk.
    • OFFLINE: Oracle ASM has taken this grid disk offline.
    • DROPPED: Oracle ASM has dropped this grid disk.
    • UNUSED: No Oracle ASM instance has used this grid disk on the storage cell.
    • SYNCING: Oracle ASM has started to set this grid disk to online.
    • UNKNOWN: Oracle ASM instances that use the grid disk are not available to query, or Oracle ASM has rejected the query because it is not in a currently-mounted disk group.

  • When the cachingPolicy attribute is set to none, data on the associated grid disk is not cached on Exadata Smart Flash Cache. Flash cache may still be used for write I/O latency capping and logging.

Examples

Example 7-172 Listing Grid Disk Attributes

This example shows the LIST command with the GRIDDISK object, and the corresponding output. 

CellCLI> LIST GRIDDISK WHERE cellDisk = 'CD_01_cell05' -
         ATTRIBUTES name, status

         DATA_CD_01_cell05        active
         RECO_CD_01_cell05        active

CellCLI> LIST GRIDDISK DATA_CD_01_cell05 DETAIL

         name:                   DATA_CD_01_cell05
         status:                 active
         comment:                
         id:                     00000117-84d9-0096-0000-000000000000
         creationTime:           2009-01-16T17:04:49-06:00
         cellDisk:               CD_01_cell05
         offset:                 0
         availableTo:            CLUSTER-C1
         size:                   10G
         errorCount:             0
         diskType:               HardDisk
         cachedBy:               FD_01_FLASH, FD02_FLASH, FD03_FLASH
         cachingPolicy:          default

CellCLI> LIST GRIDDISK DATA_CD_01_cell05 ATTRIBUTES size

         136.640625G

CellCLI> LIST GRIDDISK WHERE status!=active ATTRIBUTES name

         data_CD_01_1_abcd2x3

CellCLI> LIST GRIDDISK data4_CD_09_cell01 DETAIL

         name:                   data4_CD_09_cell01
         availableTo:            
         cellDisk:               CD_09_cell01
         comment:                
         creationTime:           2009-07-26T17:09:46-07:00
         diskType:               HardDisk
         errorCount:             0
         id:                     00000122-b98a-a47a-0000-000000000000
         offset:                 27.546875G
         size:                   75G
         status:                 active

Example 7-173 Determining if a Grid Disk can be Deactivated

This example shows the asmDeactivationOutcome attribute being used to determine if a grid disk can be deactivated. 

CellCLI> LIST GRIDDISK ATTRIBUTES name, asmDeactivationOutcome

         QUAL_CD_00_cell01       Yes
         PROD_CD_02_cell01       Cannot de-activate due to other offline disks in 
                                 the diskgroup
         TEST_CD_03_cell01       Yes
         DATA_CD_04_cell01       Yes
         DATA_CD_05_cell01       Yes
         DATA_CD_06_cell01       Yes
         RECO_CD_01_cell01       Cannot de-activate due to other offline disks in 
                                 the diskgroup
         DATA_CD_08_cell01       Yes
         DATA_CD_09_cell01       Yes
         DATA_CD_10_cell01       Yes
         DATA_CD_11_cell01       Yes

Example 7-174 Viewing the Current Usage of a Grid Disk

This example shows the asmModeStatus attribute being used to check the current usage of a grid disk. 

CellCLI> LIST GRIDDISK ATTRIBUTES name, asmModeStatus

         QUAL_CD_00_cell01        UNUSED
         RECO_CD_01_cell01        OFFLINE
         PROD_CD_02_cell01        SYNCING
         TEST_CD_03_cell01        UNKNOWN
         DATA_CD_04_cell01        ONLINE
         DATA_CD_05_cell01        ONLINE
         DATA_CD_06_cell01        ONLINE
         DATA_CD_07_cell01        ONLINE
         DATA_CD_08_cell01        ONLINE
         DATA_CD_09_cell01        ONLINE
         DATA_CD_10_cell01        ONLINE
         DATA_CD_11_cell01        ONLINE

Example 7-175 Checking the Status Using the LIST GRIDDISK Command

This example shows the LIST GRIDDISK command being used to check the status of the resize process when the NOWAIT option is used with the ALTER GRIDDISK command. 

CellCLI> LIST GRIDDISK DETAIL

         name:                   gd0
         availableTo:
         cellDisk:               c9standby0
         comment:
         creationTime:           2009-07-09T09:07:36-07:00
         diskType:               HardDisk
         errorCount:             0
         id:                     00000122-6045-173b-0000-000000000000
         resizeStatus:           Resize in progress
         offset:                 48M
         size:                   48M
         status:                 active

Example 7-176 Checking the Status of Secure Erase

This example shows the LIST GRIDDISK command being used to check the status of grid disks that are being erased. 

CellCLI> LIST GRIDDISK
         DATA_CD_00_cell01     active
         DATA_CD_05_cell01     active
         DATA_CD_06_cell01     erase in progress
         DATA_CD_07_cell01     erase in progress

Example 7-177 Listing Devices Used to Cache Grid Disks

This example shows the devices that are currently being used to cache the grid disks.

CellCLI> LIST GRIDDISK ATTRIBUTES name, diskType, size, cachedby

   C_DATA_CD_00_dm01celadm01   HardDisk  3.41796875T   FD_02_dm01celadm01
   C_DATA_CD_01_dm01celadm01   HardDisk  3.41796875T   FD_01_dm01celadm01
   C_DATA_CD_02_dm01celadm01   HardDisk  3.41796875T   FD_00_dm01celadm01
   C_DATA_CD_03_dm01celadm01   HardDisk  3.41796875T   FD_02_dm01celadm01
   C_DATA_CD_04_dm01celadm01   HardDisk  3.41796875T   FD_01_dm01celadm01

Parent topic: LIST