Veritas Storage Foundation™ 5.0.1 for Oracle RAC Installation, Configuration, and Administrator's Guide Extracts for the HP Serviceguard Storage Management Suite on HP-UX 11i v3

Two Host Configuration ............................................................................................................53
Host and Storage Requirements.................................................................................................54
Creating a Snapshot Mirror of a Volume or Volume Set Used by the Database.............................54
Upgrading Existing Volumes to Use Veritas Volume Manager 5.0.................................................57
Summary of Database Snapshot Steps.................................................................................................60
Creating a Snapplan (dbed_vmchecksnap)..........................................................................................65
Creating Multi-mirror Snapshots....................................................................................................68
Establishing a mandatory archive destination...........................................................................69
Validating a Snapplan (dbed_vmchecksnap).......................................................................................69
Displaying, Copying, and Removing a Snapplan (dbed_vmchecksnap).............................................71
Displaying a Snapplan.....................................................................................................................71
Copying a Snapplan........................................................................................................................72
Removing a Snapplan......................................................................................................................72
Creating a Snapshot (dbed_vmsnap)....................................................................................................72
Backing Up the Database from Snapshot Volumes (dbed_vmclonedb)...............................................74
Mounting the Snapshot Volumes and Backing Up.........................................................................75
Cloning a Database (dbed_vmclonedb)................................................................................................76
Using Database FlashSnap to Clone a Database.............................................................................76
Shutting Down the Clone Database and Unmounting File Systems..............................................80
Restarting a Clone Database............................................................................................................80
Recreating Oracle Tempfiles ...........................................................................................................81
Resynchronizing the Snapshot to Your Database ................................................................................81
Removing a Snapshot Volume..............................................................................................................82
6 Investigating I/O Performance for SGeRAC: Storage Mapping............................85
About Storage Mapping in SGeRAC....................................................................................................85
Understanding Storage Mapping.........................................................................................................85
Verifying Veritas Storage Mapping Setup............................................................................................86
Using vxstorage_stats...........................................................................................................................86
Displaying Storage Mapping Information......................................................................................87
Displaying I/O Statistics Information...................................................................................................87
Using dbed_analyzer............................................................................................................................88
Obtaining Storage Mapping Information for a List of Tablespaces................................................89
Oracle File Mapping (ORAMAP).........................................................................................................89
Mapping Components.....................................................................................................................90
Storage Mapping Views..................................................................................................................91
Verifying Oracle File Mapping Setup..............................................................................................91
Enabling Oracle File Mapping.........................................................................................................91
Accessing Dynamic Performance Views.........................................................................................92
Using Oracle Enterprise Manager...................................................................................................93
About Arrays for Storage Mapping and Statistics..........................................................................93
A Troubleshooting SGeRAC...........................................................................................95
About Troubleshooting SGeRAC..........................................................................................................95
Running Script for Engineering Support Analysis.........................................................................95
Troubleshooting Tips............................................................................................................................95
Troubleshooting Oracle.........................................................................................................................95
Oracle Log Files...............................................................................................................................95
Oracle Notes....................................................................................................................................96
Troubleshooting SGeRAC Checkpoint.................................................................................................96
SGeRAC Checkpoint Feature Requires DBA Group to Have MLOCK Privileges.........................96
Table of Contents 5