As downtime (planned and unplanned) trends lower and SLAs continue to increase, it is important to be able maximize online operations as much as possible. In this article, we will be looking at performing a storage upgrade or refresh online, which is possible if you are running on Oracle Automatic Storage Management (ASM).
In order to keep this simple, let’s assume that our database is running on one ASM disk group: DATA. That disk group is composed of one ASM disk: SPINNING. We’re going to create a new disk, FLASH, on our brand new, all-flash storage array. In the example below, you’ll see us migrate from SPINNING to FLASH with no downtime at all.