Resizing cluster node VMs may be needed for performance or cost reasons. Resizing can be done for one node at a time without causing database downtime.
ATTENTION! The procedure below is mandatory for resizing from a newer instance type (r5b, r6i, m6i, c6i) to an older instance type (r5, m5, c5). An attempt to resize instances while the cluster is stopped (disk groups not mounted) will result in failure to mount the disk groups after the resize. More details available here.
To resize database nodes in a running cluster repeat the following steps on each database node, one node at a time
-
Update SGA and PGA sizing parameters for the databases according to the new VM memory size
-
Skip this step unless you have
vm.nr_hugepages
parameter in/etc/sysctl.conf
manually configured. If you have it manually configured then update the parameters according to the new VM size. Note that starting with Storage Fabric 19.02 HugePages are configured automatically by default and manual change is not required. -
Make sure there are no other nodes that are in offline or re-syncing state. All disk groups must have zero offline disks and Resync = No:
# flashgrid-cluster
-
Stop all local database instances running on the node.
-
Stop Oracle CRS on the node:
# crsctl stop crs
-
Stop the FlashGrid Storage Fabric services on the node:
# flashgrid-node stop
-
Stop the VM using AWS console
-
Resize the VM using AWS console
-
Start the VM using AWS console
-
Wait until all disks are back online and resyncing operations complete on all disk groups. All disk groups must have zero offline disks and Resync = No.
# flashgrid-cluster
-
Start all database instances on the node
-
Proceed to the next node
To resize storage or quorum nodes in a running cluster repeat the following steps on each storage/quorum node, one node at a time
-
Make sure there are no other nodes that are in offline or re-syncing state. All disk groups must have zero offline disks and Resync = No:
# flashgrid-cluster
-
Stop the FlashGrid Storage Fabric services on the node:
# flashgrid-node stop
-
Stop the VM using AWS console
-
Resize the VM using AWS console
-
Start the VM using AWS console
-
Wait until all disks are back online and resyncing operations complete on all disk groups. All disk groups must have zero offline disks and Resync = No.
# flashgrid-cluster
- Proceed to the next node
Keyword: EC2 instance upgrade