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
Table Of Contents
- 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
- Table of Contents
- Preface
- 1 Introducing Serviceguard Extension for RAC
- About Serviceguard Extension for RAC
- How Serviceguard Extension for RAC Works (High-Level Perspective)
- Component Products and Processes of SG SMS Serviceguard Cluster File System for RAC
- Communication Infrastructure
- Cluster Interconnect Communication Channel
- Low-level Communication: Port Relationship Between GAB and Processes
- Cluster Volume Manager
- Cluster File System
- Oracle Disk Manager
- Additional Features of Serviceguard Extension for RAC
- 2 Planning SGeRAC Installation and Configuration
- 3 Configuring the Repository Database for Oracle
- 4 Using Storage Checkpoints and Storage Rollback
- About Storage Checkpoints and Storage Rollback in SGeRAC
- Using Storage Checkpoints and Storage Rollback for Backup and Restore
- Determining Space Requirements for Storage Checkpoints
- Performance of Storage Checkpoints
- Backing up and Recovering the Database Using Storage Checkpoints
- Guidelines for Oracle Recovery
- Using the Storage Checkpoint Command Line Interface (CLI)
- Examples of Using the Command Line Interface
- Prerequisites
- Creating or Updating the Repository Using dbed_update
- Creating Storage Checkpoints Using dbed_ckptcreate
- Displaying Storage Checkpoints Using dbed_ckptdisplay
- Mounting Storage Checkpoints Using dbed_ckptmount
- Unmounting Storage Checkpoints Using dbed_ckptumount
- Performing Storage Rollback Using dbed_ckptrollback
- Removing Storage Checkpoints Using dbed_ckptremove
- Cloning the Oracle Instance Using dbed_clonedb
- 5 Using FlashSnap for Backup and Recovery
- About Veritas Database FlashSnap
- Planning to Use Database FlashSnap
- Preparing Hosts and Storage for Database FlashSnap
- Summary of Database Snapshot Steps
- Creating a Snapplan (dbed_vmchecksnap)
- Validating a Snapplan (dbed_vmchecksnap)
- Displaying, Copying, and Removing a Snapplan (dbed_vmchecksnap)
- Creating a Snapshot (dbed_vmsnap)
- Backing Up the Database from Snapshot Volumes (dbed_vmclonedb)
- Cloning a Database (dbed_vmclonedb)
- Resynchronizing the Snapshot to Your Database
- Removing a Snapshot Volume
- 6 Investigating I/O Performance for SGeRAC: Storage Mapping
- A Troubleshooting SGeRAC
NOTE: For SGeRAC database, when you issue the commands, replace $ORACLE_SID with
$ORACLE_SID=instance_name and provide the instance name on which the instance is
running.
In addition, you can also use the Oracle Enterprise Manager GUI to display storage mapping
information after file mapping has occurred. Oracle Enterprise Manager does not display I/O
statistics information.
Verifying Veritas Storage Mapping Setup
Before using the Veritas Storage Mapping option, verify that the features are set up correctly:
To verify that your system is using the Veritas Storage Mapping option
1. Verify that you have a license key for the storage mapping option.
# /opt/VRTS/bin/vxlictest -n "VERITAS Mapping Services" -f
"Found_Edi_map"
Found_Edi_map feature is licensed
2. Verify that the VRTSvxmsa depot is installed.
# swlist VRTSvxmsa
VRTSvxmsa 4.4-REVbuild010-2006.03.07 VxMS
Application Deployment Package
VRTSvxmsa.ADMIN 4.4-REVbuild010-2006.03.07 VERITAS
Federated Mapping Service
VRTSvxmsa.LIBRARIES 4.4-REVbuild010-2006.03.07 libraries
VRTSvxmsa.LOGGING 4.4-REVbuild010-2006.03.07 logging
VRTSvxmsa.PLUGINS 4.4-REVbuild010-2006.03.07 plugins
Using vxstorage_stats
The vxstorage_stats command displays detailed storage mapping information and I/O statistics
about one or more VxFS files. The mapping information and I/O statistics are recorded only for
VxFS files and VxVM volumes.
In vxstorage_stats command output, I/O topology information appears first followed by summary
statistics for each object.
The command syntax is as follows:
/opt/VRTSdbed/bin/vxstorage_stats [-m] [-s] [-i interval -c count] -f
filename
Table 6-2 vxstorage_stats Syntax
You must log in as the database administrator (typically, the user ID oracle) or superuser.Prerequisites
• The -s specified option displays the file statistics for the specified file.
• The -c count option specifies the number of times to display statistics within the interval
specified by -i interval.
• The -i interval option specifies the interval frequency for displaying updated I/O
statistics.
• The -f filename option specifies the file to display I/O mapping and statistics for.
• The -m option displays the I/O topology for the specified file.
• For more information, see the vxstorage_stats(1m) online manual page.
Usage Notes
86 Investigating I/O Performance for SGeRAC: Storage Mapping