Exadata · Oracle

When is the last time you changed a flashdisk or harddisk on Exadata ?

Why is this question is important for a DBA ? Actually the results are pretty surprising when you execute the query and see the last inserted date of a harddisk or a flashdisk. In another way, that information shows you the time you changed a faulty harddisk or flashdisk on the exadata. If you deleted your alert history on that cell, this information may give you a quick idea. Also It gives you an idea when the system is first installed đŸ™‚ Assuming not most of the disks are replaced.

[root@testdbadm01 ~]#  dcli -g cellnodes.txt  -l root "cellcli -e list physicaldisk  attributes name,diskType,physicalInsertTime " | sort -k 4
testdb01-priv: 20:0             HardDisk        2013-03-26T11:23:53+02:00       
testdb01-priv: 20:10            HardDisk        2013-03-26T11:23:53+02:00       
testdb01-priv: 20:11            HardDisk        2013-03-26T11:23:53+02:00       
testdb01-priv: 20:1             HardDisk        2013-03-26T11:23:53+02:00       
testdb01-priv: 20:2             HardDisk        2013-03-26T11:23:53+02:00       
testdb01-priv: 20:3             HardDisk        2013-03-26T11:23:53+02:00       
testdb01-priv: 20:4             HardDisk        2013-03-26T11:23:53+02:00       
testdb01-priv: 20:5             HardDisk        2013-03-26T11:23:53+02:00       
testdb01-priv: 20:7             HardDisk        2013-03-26T11:23:53+02:00       
testdb01-priv: 20:8             HardDisk        2013-03-26T11:23:53+02:00       
testdb01-priv: 20:9             HardDisk        2013-03-26T11:23:53+02:00       
testdb01-priv: FLASH_1_0        FlashDisk       2013-03-26T11:23:53+02:00       
testdb01-priv: FLASH_1_1        FlashDisk       2013-03-26T11:23:53+02:00       
testdb01-priv: FLASH_1_2        FlashDisk       2013-03-26T11:23:53+02:00       
. 
. 
. 
testdb07-priv: FLASH_4_0        FlashDisk       2013-03-26T12:05:59+02:00       
testdb07-priv: FLASH_4_1        FlashDisk       2013-03-26T12:05:59+02:00       
testdb07-priv: FLASH_4_2        FlashDisk       2013-03-26T12:05:59+02:00       
testdb07-priv: FLASH_4_3        FlashDisk       2013-03-26T12:05:59+02:00       
testdb07-priv: FLASH_5_0        FlashDisk       2013-09-20T11:10:31+03:00       
testdb07-priv: FLASH_5_1        FlashDisk       2013-09-20T11:10:31+03:00       
testdb07-priv: FLASH_5_2        FlashDisk       2013-09-20T11:10:31+03:00       
testdb07-priv: FLASH_5_3        FlashDisk       2013-09-20T11:10:31+03:00       
testdb06-priv: FLASH_5_0        FlashDisk       2013-10-10T16:30:15+03:00       
testdb06-priv: FLASH_5_1        FlashDisk       2013-10-10T16:30:15+03:00       
testdb06-priv: FLASH_5_2        FlashDisk       2013-10-10T16:30:15+03:00       
testdb06-priv: FLASH_5_3        FlashDisk       2013-10-10T16:30:15+03:00       
testdb01-priv: 20:6             HardDisk        2013-11-18T09:45:08+02:00       
testdb06-priv: FLASH_1_0        FlashDisk       2013-11-22T16:13:33+02:00       
testdb06-priv: FLASH_1_1        FlashDisk       2013-11-22T16:13:33+02:00       
testdb06-priv: FLASH_1_2        FlashDisk       2013-11-22T16:13:33+02:00       
testdb06-priv: FLASH_1_3        FlashDisk       2013-11-22T16:13:33+02:00       

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s