Step 4 - Review Storage Configuration

Review the following odaadmcli commands that provide information about Oracle Database Appliance configuration.

Command: odaadmcli show disk

Description: This command is helpful for getting a view into the device mapping and current state of the hard disks.  The output lists the drives in the ODA X7-2-HA.

$ sudo odaadmcli show disk  

              NAME                  PATH                   TYPE                     STATE                  STATE_DETAILS
              e0_pd_00              /dev/sdbv              HDD                      ONLINE                 Good          
              e0_pd_01              /dev/sdbw              HDD                      ONLINE                 Good          
              e0_pd_02              /dev/sdbx              HDD                      ONLINE                 Good          
              e0_pd_03              /dev/sdby              HDD                      ONLINE                 Good          
              e0_pd_04              /dev/sdbz              HDD                      ONLINE                 Good          
              e0_pd_05              /dev/sdca              HDD                      ONLINE                 Good          
              e0_pd_06              /dev/sdcb              HDD                      ONLINE                 Good          
              e0_pd_07              /dev/sdcc              HDD                      ONLINE                 Good          
              e0_pd_08              /dev/sdcd              HDD                      ONLINE                 Good          
              e0_pd_09              /dev/sdce              HDD                      ONLINE                 Good          
              e0_pd_10              /dev/sdcf              HDD                      ONLINE                 Good          
              e0_pd_11              /dev/sdcg              HDD                      ONLINE                 Good          
              e0_pd_12              /dev/sdch              HDD                      ONLINE                 Good          
              e0_pd_13              /dev/sdci              HDD                      ONLINE                 Good          
              e0_pd_14              /dev/sdcj              HDD                      ONLINE                 Good          
              e0_pd_15              /dev/sdck              SSD                      ONLINE                 Good          
              e0_pd_16              /dev/sdcl              SSD                      ONLINE                 Good          
              e0_pd_17              /dev/sdcm              SSD                      ONLINE                 Good          
              e0_pd_18              /dev/sdcn              SSD                      ONLINE                 Good          
              e0_pd_19              /dev/sdco              SSD                      ONLINE                 Good          
              e0_pd_20              /dev/sdcp              SSD                      ONLINE                 Good          
              e0_pd_21              /dev/sdcq              SSD                      ONLINE                 Good    
              e0_pd_22              /dev/sdcr              SSD                      ONLINE                 Good          
              e0_pd_23              /dev/sdcs              SSD                      ONLINE                 Good

Command:  odaadmcli show diskgroup

Description: Lists Oracle ASM disk groups configured on Oracle Database Appliance. 

DATA is where the database data files are stored.

FLASH is where the hot files or small databases can be placed to improve performance

RECO is where the backups, archive logs, and redo logs of the database are stored.

REDO is where the redo logs of the database are stored.

$ sudo odaadmcli show diskgroup  

DiskGroups
----------
DATA
FLASH
RECO
REDO

Command: odaadmcli show fs

Description: Lists the details of the Oracle Database Appliance X8-2 file systems, including total Space, Free Space, Disk Group, and other details.  

The sample output displayed in the simulator may not match exactly with the sample output on an actual appliance. For more details, refer to the Oracle Database Appliance documentation library for the latest release.

$ sudo odaadmcli show fs  

 Type     Total Space      Free Space  Total DG Space   Free DG Space  Diskgroup Mount Point             
 ext3          30109M          25254M               -               -            /                       
 ext3            476M            405M               -               -            /boot                   
 ext3          60347M          22117M               -               -            /opt                    
 ext3         100665M          72839M               -               -            /u01                    
 acfs           5120M           4625M      112116480M      111977204M       DATA /opt/oracle/dcs/commonstore

Command: odaadmcli show raidsyncstatus

Description: Lists the status of the boot disk HW RAID.

$  sudo odaadmcli show raidsyncstatus 

Raid Type  Raid Device      Partitions      RaidStatus Recovery        RecoveryPercentage
 S/W Raid          md0      sdb2 sda2            UU       No                       N/A
 S/W Raid          md1      sdb3 sda3            UU       No                       N/A

Command: odaadmcli show storage

Description: The following command displays the storage controllers and drives.

$ sudo odaadmcli show storage  


==== BEGIN STORAGE DUMP ========
Host Description: Oracle Corporation:ORACLE SERVER X7-2
Total number of controllers: 2
              Id         = 0
              Serial Num = 500605b00d3e88c0
              Vendor     = LSI Logic
              Model      = ORCL-EXT-SAS3
              FwVers     = 13.00.00.00
              strId      = mpt3sas:3b:00.0
              Id         = 1
              Serial Num = 500605b00d3e8450
              Vendor     = LSI Logic
              Model      = ORCL-EXT-SAS3
              FwVers     = 13.00.00.00
              strId      = mpt3sas:5e:00.0

Total number of expanders: 2
              Id         = 0
              Serial Num = 50800200022f163f
              Vendor     = ORACLE
              Model      = DE3-24C
              FwVers     = 0306
              strId      = Secondary
              WWN        = 50800200022e41be
              Id         = 1
              Serial Num = 50800200022f163f
              Vendor     = ORACLE
              Model      = DE3-24C
              FwVers     = 0306
              strId      = Primary
              WWN        = 50800200022e447e

Total number of PDs: 24
              /dev/sdaa       HGST              HDD 9796gb slot:  0  exp:  0   H7210A520SUN010T
              /dev/sdab       HGST              HDD 9796gb slot:  1  exp:  0   H7210A520SUN010T
              /dev/sdac       HGST              HDD 9796gb slot:  2  exp:  0   H7210A520SUN010T
              /dev/sdad       HGST              HDD 9796gb slot:  3  exp:  0   H7210A520SUN010T
              /dev/sdae       HGST              HDD 9796gb slot:  4  exp:  0   H7210A520SUN010T
              /dev/sdaf       HGST              HDD 9796gb slot:  5  exp:  0   H7210A520SUN010T
              /dev/sdag       HGST              HDD 9796gb slot:  6  exp:  0   H7210A520SUN010T
              /dev/sdah       HGST              HDD 9796gb slot:  7  exp:  0   H7210A520SUN010T
              /dev/sdai       HGST              HDD 9796gb slot:  8  exp:  0   H7210A520SUN010T
              /dev/sdaj       HGST              HDD 9796gb slot:  9  exp:  0   H7210A520SUN010T
              /dev/sdak       HGST              HDD 9796gb slot: 10  exp:  0   H7210A520SUN010T
              /dev/sdal       HGST              HDD 9796gb slot: 11  exp:  0   H7210A520SUN010T
              /dev/sdam       HGST              HDD 9796gb slot: 12  exp:  0   H7210A520SUN010T
              /dev/sdan       HGST              HDD 9796gb slot: 13  exp:  0   H7210A520SUN010T
              /dev/sdao       HGST              HDD 9796gb slot: 14  exp:  0   H7210A520SUN010T
              /dev/sdap       HGST              SSD 3200gb slot: 15  exp:  0   HBCAC2DH2SUN3.2T
              /dev/sdaq       HGST              SSD 3200gb slot: 16  exp:  0   HBCAC2DH2SUN3.2T
              /dev/sdar       HGST              SSD 3200gb slot: 17  exp:  0   HBCAC2DH2SUN3.2T
              /dev/sdas       HGST              SSD 3200gb slot: 18  exp:  0   HBCAC2DH2SUN3.2T
              /dev/sdat       HGST              SSD 3200gb slot: 19  exp:  0   HBCAC2DH2SUN3.2T
              /dev/sdau       HGST              SSD  800gb slot: 20  exp:  0   HBCAC2DH4SUN800G
              /dev/sdav       HGST              SSD  800gb slot: 21  exp:  0   HBCAC2DH4SUN800G
              /dev/sdaw       HGST              SSD  800gb slot: 22  exp:  0   HBCAC2DH4SUN800G
              /dev/sdax       HGST              SSD  800gb slot: 23  exp:  0   HBCAC2DH4SUN800G
==== END STORAGE DUMP =========