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
Table 4-10 Perform Storage Rollback Notes
You may be logged in as either the database administrator or superuser.Prerequisites
The dbed_ckptrollback command rolls an Oracle database back to a specified Storage
Checkpoint. You can perform a Storage Rollback for the entire database, a specific tablespace,
or list of datafiles.
Database rollback for the entire database requires that the database be inactive before Storage
Rollback commences. The dbed_ckptrollback command will not commence if the Oracle
database is active. However, to perform a Storage Rollback of a tablespace or datafile, only the
tablespace or datafile to be rolled back must be offline (not the entire database).
You must run the dbed_update command after upgrading to HP Storage Management suite
for Oracle RAC from a previous release. This will allow you to roll back to a Storage Checkpoint
that was created with an earlier version of this product.
See the dbed_ckptrollback(1M) manual page for more information.
Usage notes
To roll back an Oracle database to a Storage Checkpoint
• Use the dbed_ckptrollback command as follows:
# /opt/VRTS/bin/dbed_ckptrollback -S PROD -H /oracle/product/10g -c
Checkpoint_903937870
To rollback a tablespace to a Storage Checkpoint
• Use the dbed_ckptrollback command with the -T option as follows:
# /opt/VRTS/bin/dbed_ckptrollback -S PROD -H /oracle/product/10g -T
DATA01 -c Checkpoint_903937870
If the Oracle database is running, you must take the tablespace offline before running this
command. If the tablespace is online, the command will fail.
In the case of an instant Storage Checkpoint, rolling back a tablespace does not apply.
To rollback datafiles to a Storage Checkpoint
• Use the dbed_ckptrollback command with the -F option as follows:
# /opt/VRTS/bin/dbed_ckptrollback -S PROD -H /oracle/product/10g -F
/share/oradata1/data01.dbf /share/oradata2/index01.dbf -c
Checkpoint_903937870
If the Oracle database is running, you must take the datafile offline before running this
command. If the datafile is online, the command fails.
In the case of an instant Storage Checkpoint, rolling back datafiles does not apply.
Removing Storage Checkpoints Using dbed_ckptremove
You can use the dbed_ckptremove command to remove a Storage Checkpoint for an Oracle
database at the command line.
Before removing Storage Checkpoints, the following conditions must be met:
Table 4-11 Remove Storage Checkpoints Notes
You may be logged in as either the database administrator or superuser.Prerequisites
The dbed_ckptremove command is used to remove a Storage Checkpoint from the file
system, or file systems, it is associated with. The Storage Checkpoint must have been created
using the dbed_ckptcreate(1M) command.
You must unmount the Storage Checkpoint before you can remove it.
See the dbed_ckptremove(1M) manual page for more information.
Usage notes
Examples of Using the Command Line Interface 45