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 =========