Veritas Storage Foundation™ for Oracle 5.0.1 Administrator's Guide

Chapter 11 Using Database Dynamic Storage Tiering .................... 183
About Database Dynamic Storage Tiering ....................................... 183
Database Dynamic Storage Tiering building blocks ..................... 184
Database Dynamic Storage Tiering in a High Availability (HA)
environment ................................................................. 185
Configuring Database Dynamic Storage Tiering ............................... 186
Database Dynamic Storage Tiering command requirements ......... 186
Defining database parameters ................................................ 187
Setting up storage classes ...................................................... 189
Converting a VxFS file system to a VxFS multi-volume file
system .......................................................................... 191
Classifying volumes into a storage class .................................... 192
Displaying free space on your storage classes ............................ 193
Adding new volumes to a storage class ..................................... 194
Removing volumes from a storage class .................................... 195
Starting or stopping I/O statistic collection ............................... 195
Dynamic Storage Tiering policy management .................................. 196
Relocating files .................................................................... 196
Relocating tablespaces .......................................................... 197
Relocating table partitions ..................................................... 198
Using preset policies ............................................................. 199
Running Database Dynamic Storage Tiering reports ......................... 200
Viewing modified allocation policies ........................................ 200
Viewing audit reports ........................................................... 200
Extent balancing in a database environment .................................... 201
Extent balancing file system ................................................... 202
Database Dynamic Storage Tiering use cases for Oracle ..................... 203
Migrating partitioned data and tablespaces ............................... 203
Scheduling the relocation of archive and Flashback logs .............. 205
Chapter 12 Using the Space Capacity Planning Utility for
Storage Checkpoints ................................................... 209
About planning file system space for Storage Checkpoints ................. 209
Starting the Storage Checkpoint Capacity Planning utility ................. 210
Creating Capacity Planning schedules ........................................... 211
Displaying Capacity Planning schedules ......................................... 214
Displaying file system space usage information ............................... 215
Removing Capacity Planning schedules .......................................... 218
Contents12