Converting a VxFS file system to a VxFS multi-volume file system for Database Dynamic Storage Tiering using dbdst_convert
Prev Appendix B. Storage Foundation for Databases (SFDB) tools command line interface Next

Converting a VxFS file system to a VxFS multi-volume file system for Database Dynamic Storage Tiering using dbdst_convert

To convert your existing VxFS file system to a VxFS multi-volume file system, you must convert a single volume to a volume set.

When you convert to a volume set using the dbdst_convert command, the original volume will be renamed to a new volume name. The mount device name will become the new volume set name. Creating the new volume set name with the mount device name nullifies the need to rename the mount device in various locations.

Before converting to a volume set, make sure the following conditions have been met:

Prerequisites

  • The database must be shutdown.

  • Create at least one additional volume.

Usage notes

  • You must convert the single-volume file system on which you plan to implement Database Dynamic Storage Tiering.

  • The file system can be mounted or unmounted when you run the dbdst_convert command.

  • If the file system has n volumes, volumes 1 through n - 1 will be placed in the storage class "PRIMARY" and volume n will be placed in the storage class "SECONDARY."

  • The volumes specified when running the conversion must be in the same disk group as the mount device.

To convert a mount device from a single volume device to a volume set

  1. Use the dbdst_convert command as follows:

    $ /opt/VRTS/bin/dbdst_convert -S $ORACLE_SID -M mount_device -v \
volume_name,volume_name

  2. Bring database objects online.

For example, to convert a volume-based oradata file system to a Database Dynamic Storage Tiering-ready volume set file system on mount device /dev/vx/dsk/oradg/oradata, use the dbdst_convert command as follows:

$ /opt/VRTS/bin/dbdst_convert -S PROD -M /dev/vx/dsk/oradg/oradata -v \
new_vol1,new_vol2

After conversion, you will have a volume set named oradata containing three volumes (oradata_b4vset, new_vol1, and new_vol2). The file system will have two storage classes defined as PRIMARY and SECONDARY. The volumes will be assigned as follows:

Prev Up Next
Setting up storage classes for Database Dynamic Storage Tiering using dbdst_admin Home Classifying volumes into a storage class for Database Dynamic Storage Tiering using dbdst_classify