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
• Use the vxstorage_stats command with the -i interval and -c countoptions. The
-i intervaloption specifies the interval frequency for displaying updated I/O statistics
and the -c count option specifies the number of times to display statistics:
# /opt/VRTSdbed/bin/vxstorage_stats [-m] [-s] [-i interval -c count
] -f file_name
For example, type the following command to display statistics two times with a time interval
of two seconds:
# /opt/VRTSdbed/bin/vxstorage_stats -s -i2 -c2 -f /data/system01.dbf
Output similar to the following is displayed:
I/O OPERATIONS I/O BLOCKS(512 byte) AVG TIME(ms)
OBJECT READ WRITE B_READ B_WRITE AVG_RD AVG_WR
/oradata/system01.dbf 11917 13102 95336 594402 2.84 278.81
/dev/vx/rdsk/ramdg/oradata 11959 14729 105839 704811 3.11 295.20
vxvm:ramdg/oradata-01 11947 14729 107783 704799 3.14 295.23
/dev/rhdisk13 5974 8366 53663 352207 2.95 246.65
EMC000184502242:02:0c:01 5 733 320 49897 - -
EMC000184502242:31:0c:01 1 1230 8 174752 - -
/dev/rhdisk41 4705 8249 73526 339740 6.01 250.18
EMC000184502242:02:0c:01 5 733 320 49897 - -
EMC000184502242:31:0c:01 1 1230 8 174752 - -
/dev/rhdisk14 3895 6264 91672 295491 11.49 279.42
EMC000184502242:01:0d:01 0 0 0 0 - -
EMC000184502242:32:0d:01 1 1336 8 190456 - -
/dev/rhdisk42 4407 4840 119576 116696 13.12 287.46
EMC000184502242:01:0d:01 0 0 0 0 - -
EMC000184502242:32:0d:01 1 1336 8 190456 - -
Using dbed_analyzer
Effectively performing a parallel backup requires an understanding of which tablespaces reside
on which disks. If two tablespaces reside on the same disk, for example, backing them up in
parallel will not reduce their downtime.
The dbed_analyzer command provides tablespace-to-physical disk mapping information for
all the datafiles in a specified tablespace, list of tablespaces, or an entire database. (In contrast,
the vxstorage_stats command provides this information on a per-file basis only.) In addition,
dbed_analyzer provides information about the amount of disk space they are using.
Table 6-3 dbed_analyzer Command
You must log in as the database administrator (typically, the user ID oracle).Prerequisites
• The -o sort=tbs option provides the layout of the specified tablespaces on the physical
disk as well as the amount of disk space they are using.
• The -o sort=disk option provides the name of the disks containing the specified
tablespaces as well as the amount of disk space the tablespaces are using.
• The -f filename option specifies the name of a file containing a list of the tablespaces for
which to obtain mapping information.
• The -t tablespace option specifies the name of a tablespace for which to obtain mapping
information.
• If -f filename or -t tablespace is not specified then all the tablespaces in the database
will be analyzed.
• For more information, see the dbed_analyzer(1M) online manual page.
Usage Notes
88 Investigating I/O Performance for SGeRAC: Storage Mapping