VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Contents ix
Prerelease 8 September 2005, 8:55am
Converting From Raw Devices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 143
Chapter 8. Using Storage Checkpoints and Storage Rollback . . . . . . . . . . . . . . . . . . . . . . . . 145
Using Storage Checkpoints and Storage Rollback for Backup and Restore . . . . . . . . . . . . . 146
Understanding Storage Checkpoints and Storage Rollback . . . . . . . . . . . . . . . . . . . . . . . 146
Determining Space Requirements for Storage Checkpoints . . . . . . . . . . . . . . . . . . . . . . . . . . 148
Performance of Storage Checkpoints . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 150
Storage Checkpoint Allocation Policies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 151
Using Storage Checkpoint Allocation Policies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 152
Creating a Storage Checkpoint Allocation policy . . . . . . . . . . . . . . . . . . . . . . . . . . . . 153
Assigning a Storage Checkpoint Allocation policy . . . . . . . . . . . . . . . . . . . . . . . . . . 153
Displaying a Storage Checkpoint Allocation policy . . . . . . . . . . . . . . . . . . . . . . . . . . 155
Updating a Storage Checkpoint Allocation Policy . . . . . . . . . . . . . . . . . . . . . . . . . . . 156
Removing a Storage Checkpoint Allocation Policy . . . . . . . . . . . . . . . . . . . . . . . . . . 157
Converting from Regular VxFS file system to MVS . . . . . . . . . . . . . . . . . . . . . . . . . 157
Backing Up and Recovering the Database Using Storage Checkpoints . . . . . . . . . . . . . . . . . 159
Verifying a Storage Checkpoint Using the Command Line . . . . . . . . . . . . . . . . . . . . . . . 159
Backing Up Using a Storage Checkpoint . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 161
Recovering a Database Using a Storage Checkpoint . . . . . . . . . . . . . . . . . . . . . . . . . . . . 161
Guidelines for Oracle Recovery . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 164
Using the VxDBA Utility or GUI to Perform Storage Checkpoint-Related Operations . . . . 166
Chapter 9. Using the Space Capacity Planning Utility for Storage Checkpoints . . . . . . . . . 167
Planning File System Space for Storage Checkpoints . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 168
Starting the Storage Checkpoint Capacity Planning Utility . . . . . . . . . . . . . . . . . . . . . . . . . . 169
Creating Capacity Planning Schedules . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 171
Displaying Capacity Planning Schedules . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 174
Displaying File System Space Usage Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 175
Removing Capacity Planning Schedules . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 178
Chapter 10. Using Database FlashSnap for Backup and Off-Host Processing . . . . . . . . . . 181