Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
You can drop and re-create flash disks and flash cache on Exadata cellnodes online.
You will need this process if the flash cache is not in the normal state after the flash modules have changed. T
he status of flash disks may not be normal after flash module replacement.
To view the status of Flash disks;
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 | [root@oracel01 ~]# cellcli CellCLI: Release 11.2.3.3.0 - Production on Fri Sep 23 11:44:46 EEST 2016 Copyright (c) 2007, 2013, Oracle. All rights reserved. Cell Efficiency Ratio: 13,622 CellCLI> list physicaldisk 20:0 E0RRL6 normal 20:1 E0Q6VY normal 20:2 E0R2NR normal 20:3 E4CKCK normal 20:4 E0RAFP normal 20:5 E0RGND normal 20:6 E1ABV1 normal 20:7 E0RALR normal 20:8 E0R1LF normal 20:9 E0R5A1 normal 20:10 E0RANE normal 20:11 E0RAHN normal FLASH_1_0 1031M0413C normal FLASH_1_1 1031M042PM normal FLASH_1_2 1027M03NN8 normal FLASH_1_3 1027M03NN9 normal FLASH_2_0 1027M03LDQ normal FLASH_2_1 1034M04583 normal FLASH_2_2 1031M04138 normal FLASH_2_3 1034M04581 normal FLASH_4_0 1116M08JYA normal FLASH_4_1 1116M08JR2 normal FLASH_4_2 1116M08JKT normal FLASH_4_3 1116M08JMK normal FLASH_5_0 1116M08GXN normal FLASH_5_1 1116M08GXL normal FLASH_5_2 1103M06JVR normal FLASH_5_3 1116M08GXD normal |
To query the Flash cache status;
1 2 | CellCLI> list flashcache oracel02_FLASHCACHE warning - degraded |
If the flash cahce status as above is not normal, you will need to drop and re-create it. You can follow the steps below.
Drop Operations
First we drop the flash cache.
1 2 | CellCLI> drop flashcache Flash cache oracel02_FLASHCACHE successfully dropped |
Then drop the flash log.
1 2 | CellCLI> drop flashlog Flash log oracel02_FLASHLOG successfully dropped |
Finally, we drop the flash disks. We need to drop with force option.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | CellCLI> drop celldisk all flashdisk force CellDisk FD_00_oracel02 successfully dropped CellDisk FD_01_oracel02 successfully dropped CellDisk FD_02_oracel02 successfully dropped CellDisk FD_03_oracel02 successfully dropped CellDisk FD_04_oracel02 successfully dropped CellDisk FD_05_oracel02 successfully dropped CellDisk FD_06_oracel02 successfully dropped CellDisk FD_07_oracel02 successfully dropped CellDisk FD_08_oracel02 successfully dropped CellDisk FD_09_oracel02 successfully dropped CellDisk FD_10_oracel02 successfully dropped CellDisk FD_11_oracel02 successfully dropped CellDisk FD_12_oracel02 successfully dropped CellDisk FD_13_oracel02 successfully dropped CellDisk FD_14_oracel02 successfully dropped CellDisk FD_15_oracel02 successfully dropped |
Create Operations
First, we create flash disks.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | CellCLI> create celldisk all flashdisk CellDisk FD_00_oracel02 successfully created CellDisk FD_01_oracel02 successfully created CellDisk FD_02_oracel02 successfully created CellDisk FD_03_oracel02 successfully created CellDisk FD_04_oracel02 successfully created CellDisk FD_05_oracel02 successfully created CellDisk FD_06_oracel02 successfully created CellDisk FD_07_oracel02 successfully created CellDisk FD_08_oracel02 successfully created CellDisk FD_09_oracel02 successfully created CellDisk FD_10_oracel02 successfully created CellDisk FD_11_oracel02 successfully created CellDisk FD_12_oracel02 successfully created CellDisk FD_13_oracel02 successfully created CellDisk FD_14_oracel02 successfully created CellDisk FD_15_oracel02 successfully created |
Then we create the flash log;
1 2 | CellCLI> create flashlog all Flash log oracel02_FLASHLOG successfully created |
Then we create the flash cache;
1 2 | CellCLI> create flashcache all Flash cache oracel02_FLASHCACHE successfully created |
Now, we need to see the Flash cache status as normal.
1 2 | CellCLI> list flashcache oracel02_FLASHCACHE normal |
