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
redo logs were restored to an alternate location, use the ALTER DATABASE RECOVER ...
FROM statement during media recovery.
• After storage rollback, perform Oracle recovery, applying some or all of the archived redo
logs.
NOTE: After rolling back the database (including control files and redo logs) to a Storage
Checkpoint, you need to recover the Oracle database instance. Rolling the database forward
is not supported; that is, you cannot apply archived redo logs
— To perform a complete media recovery:
SET AUTORECOVERY ON;
RECOVER DATABASE;
— To perform an incomplete media recovery, use one of the following:
— RECOVER DATABASE UNTIL CANCEL;
— RECOVER DATABASE UNTIL TIME ’yyyy-mm-dd:hh:mm:ss’;
(You can confirm the time of error by checking the ../bdump/alert*.log file.)
— RECOVER DATABASE UNTIL TIME ’yyyy-mm-dd:hh:mm:ss’\ using backup
control file;
— RECOVER DATABASE UNTIL CHANGE scn;
— To open the database after an incomplete media recovery, use the following:
— ALTER DATABASE OPEN RESETLOGS;
— RESETLOGS resets the log sequence. The RESETLOGS option is required after an
incomplete media recovery. After opening the database with the RESETLOGS option,
remove the Storage Checkpoint you just rolled back to as well as any Storage Checkpoints
that were taken before that one. These earlier Storage Checkpoints can no longer be
used for storage rollback. After removing these Storage Checkpoints, be sure to create
a new Storage Checkpoint.
CAUTION: Attempting to roll back to the same Storage Checkpoint more than once can result
in data corruption. After rolling back, be sure to delete the Storage Checkpoint that you rolled
back to and then create a new one.
See your Oracle documentation for complete information on recovery.
Using the Storage Checkpoint Command Line Interface (CLI)
Veritas Storage Foundation for Oracle RAC provides a command line interface to many key
operations. The command line interface lets you incorporate command operations into scripts
and other administrative processes.
Using the Storage Checkpoint Command Line Interface (CLI) 37