Chapter 7: Initializing Database Devices

disk resize syntax

disk resize has the following syntax:

disk resize
    name = “device_name”,
    size = additional_space

Where device_name is the name of the device you are increasing and additional_space is the additional disk space you are adding to this device.

You must have already initialized the device with disk init.
device_name must refer to a valid logical device name.
The minimum size for disk resize is 1MB or one allocation unit, whichever is greater.
You must disable mirroring while the resize operation is in progress. You can reestablish mirroring when the resize operation is complete.

The new size of the device is the sum of the old device size plus the size specified in the disk resize command.