ODA: How to Confirm the Remaining Life of SSDs on Oracle Database Appliance

Asset ID:	1-71-2063899.1
Update Date:	2015-10-26
Keywords:

Solution Type Technical Instruction Sure

Solution 2063899.1 : ODA: How to Confirm the Remaining Life of SSDs on Oracle Database Appliance

Applies to:

Oracle Database Appliance - Version All Versions to All Versions [Release All Releases]
Oracle Database Appliance X3-2 - Version All Versions to All Versions [Release All Releases]
Oracle Database Appliance X4-2 - Version All Versions to All Versions [Release All Releases]
Oracle Database Appliance X5-2 - Version All Versions to All Versions [Release All Releases]
Information in this document applies to any platform.

Goal

How to check remaining life of SSD devices on the ODA.

Solution

1. Confirm the name of the SSD -- Comment: _SSDs_ are clearly marked as Type:

[root@oda...]# oakcli show disk

        NAME            PATH            TYPE            STATE           STATE_DETAILS

        e0_pd_00        /dev/sdaw       HDD             ONLINE          Good
        e0_pd_01        /dev/sdax       HDD             ONLINE          Good
        e0_pd_02        /dev/sdaa       HDD             ONLINE          Good
        e0_pd_03        /dev/sdab       HDD             ONLINE          Good
...
...
        e0_pd_20        /dev/sdas       SSD             ONLINE          Good
        e0_pd_21        /dev/sdat       SSD             ONLINE          Good
        e0_pd_22        /dev/sdau       SSD             ONLINE          Good
        e0_pd_23        /dev/sdav       SSD             ONLINE          Good

2. Use the STORDIAG command to determine the endurance percentage of disk life remaining. Review the outputs of the oakcli stordiag command (provided as of version 2.10 and higher).

oakcli stordiag <Name> -- The Name format used from the oakcli show disk is [JBOD#_]<pd_slot#>

[root@oda...]# oakcli stordiag e0_pd_22

Node Name : oda...
Test : Diagnostic Test Description

   1 : OAK Check
        NAME            PATH            TYPE            STATE           STATE_DETAILS
        e0_pd_22        /dev/sdcq       SSD             ONLINE          Good

   2 : ASM Check
        ASM Disk Status                        : group_number   state   mode_s mount_s header_s
        /dev/mapper/SSD_E0_S22_1310266672p1    :         4       NORMAL ONLINE CACHED MEMBER

   3 : Check SSD Media used endurance indicator
      SS Media used endurance indicator:     0% <<<<
        ...
        ...

============

OPTIONALLY

If you are on an older version of the ODA you can use following command:

smartctl -a /dev/<device name of the ssd disk> | grep 'SS Media used endurance indicator'

*** this device name you will get from PATH output from oakcli show disk ****

   NAME            PATH           TYPE            STATE           STATE_DETAILS
...
...
   e0_pd_20        /dev/sdas       SSD             ONLINE          Good
   e0_pd_21        /dev/sdat       SSD             ONLINE          Good

Example:

smartctl -a /dev/sdb | grep 'SS Media used endurance indicator'

The value will be between 0 to 100 and the meaning is self explanatory

[root@odax...~]# smartctl -a /dev/sdas | grep 'SS Media used endurance indicator'

SS Media used endurance indicator: 0% <<<

COMMENT SECTION

STORDIAG Syntax is difference if using V1 vs. X3-2,X4-2 or X5-2 - Use the PATH name provided from output of oakcli show disk

ODA V1 does not include the JBOD# of 0 or 1 when using the command

e.g. oakcli stordiag pd_23

ODA x3-2,X4-2 and X5-2 will include the JBOD# as a prefix to the disk name

e.g. oakcli stordiag e0_pd_20 -- This example would be for JBOD0 ( the first JBOD) and the SSD is in Slot 20

oakcli stordiag e1_pd_20 -- This example would be for an SSD in slot 20 on the Second JBOD

JBOD specification is required for X3-2,X4-2 or X5-2

JBOD or JBOD0 = the first JBOD

JBOD1 = the second / optional JBOD

The X5-2 has two types of SSDs

Special Note:

Unlike ODA V1,X3-2 and X4-2 the ODA X5-2 has two types of SSD:

FLASH SSD Disks (16,17,18,19)
REDO SSD Disks (20,21,22,23)

ODA V1,X3-2 and X4-2

REDO SSD Disks (20,21,22,23)

To determine the disk for FLASH vs. REDO you can use the oakcli show diskgroup command and use the DISK name

oakcli show diskgroup REDO

[root@oda...~]# oakcli show diskgroup REDO

        ASM_DISK        PATH                                            DISK            STATE           STATE_DETAILS

        e0_redo_20      /dev/mapper/SSD_E0_S20_1310192652p1             e0_pd_20        ONLINE          Good
        e0_redo_21      /dev/mapper/SSD_E0_S21_1310181996p1             e0_pd_21        ONLINE          Good
        e0_redo_22      /dev/mapper/SSD_E0_S22_1310266672p1             e0_pd_22        ONLINE          Good
        e0_redo_23      /dev/mapper/SSD_E0_S23_1310192764p1             e0_pd_23        ONLINE          Good

oakcli show diskgroup FLASH

oakcli show diskgroup FLASH

[root@oda...~]# oakcli show diskgroup FLASH

        ASM_DISK        PATH                                            DISK            STATE           STATE_DETAILS

        e0_flash_16     /dev/mapper/SSD_E0_S16_1310055352p1             e0_pd_16        ONLINE          Good
        e0_flash_17     /dev/mapper/SSD_E0_S17_1310118488p1             e0_pd_17        ONLINE          Good
        e0_flash_18     /dev/mapper/SSD_E0_S18_1310113772p1             e0_pd_18        ONLINE          Good
        e0_flash_19     /dev/mapper/SSD_E0_S19_1310116936p1             e0_pd_19        ONLINE          Good

Attachments

This solution has no attachment