Veritas Storage Foundation for Oracle RAC Administrator's Guide 5.0.1 - HP-UX

Article:DOC3069  |  Created: 2010-09-23  |  Updated: 2010-09-23  |  Article URL http://www.symantec.com/docs/DOC3069
Article Type
Documentation



Description



Table of Contents:
1. Overview of Veritas Storage Foundation for Oracle RAC
About Veritas Storage Foundation for Oracle RAC
Benefits of SF Oracle RAC
How SF Oracle RAC works (high-level perspective)
Component products and processes of SF Oracle RAC
Communication infrastructure
Cluster interconnect communication channel
Low-level communication: port relationship between GAB and processes
Cluster Volume Manager (CVM)
Cluster File System (CFS)
Oracle Disk Manager
Veritas Cluster Server
Oracle RAC
RAC extensions
About preventing data corruption with I/O fencing
About SCSI-3 Persistent Reservations
About I/O fencing operations
About I/O fencing communication
About database management using SF Oracle RAC
Database snapshot and backup options
Database FlashSnap for cloning
Storage Checkpoints for recovery
Database storage optimization options
2. Administering SF Oracle RAC and its components
Administering SF Oracle RAC
Setting the PATH variable
Setting the MANPATH variable
Stopping SF Oracle RAC manually on a single node
Stopping and starting LLT and GAB
Adding LLT links to increase capacity
Administering VCS
Viewing available Veritas devices and drivers
Loading Veritas drivers into memory
Configuring VCS to start Oracle with a specified Pfile
Verifying VCS configuration
Starting and stopping VCS
Administering I/O fencing
About I/O fencing
How I/O fencing works in different event scenarios
About I/O fencing utilities
About vxfentsthdw utility
About vxfenadm utility
About vxfenclearpre utility
About vxfenswap utility
Administering CFS
Using cfsmount to mount CFS file systems
Resizing CFS file systems
Verifying the status of CFS file systems
Verifying CFS port
Administering CVM
Establishing CVM cluster membership manually
Manually importing a shared disk group
Manually deporting a shared disk group
Evaluating the state of CVM ports
Verifying if CVM is running in an SF Oracle RAC cluster
Verifying CVM membership state
Verifying the state of CVM shared disk groups
Verifying the activation mode
Administering Oracle
Creating a database
Increasing swap space for Oracle
Stopping Oracle Clusterware
Determining Oracle Clusterware object status
Configuring virtual IP addresses for Oracle Clusterware
Configuring Oracle group to start and stop Oracle Clusterware objects
Configuring listeners
Starting or stopping Oracle listener
Starting and stopping Oracle service groups
Starting or stopping Voting disks
Administering ODM
Verifying the ODM port
Starting ODM
Stopping ODM
3. Configuring and managing the repository database for Oracle
About the repository database
Setting up the repository database using the sfua_db_config script
Creating and configuring the repository database
Checking the SFDB repository with sfua_db_config
Setting administrative permissions
Runtime management tasks for the repository
Backing up and restoring the repository with sfua_rept_adm
Monitoring free space for the SFDB repository
Adding a new system to a SF Oracle RAC configuration
4. Using Storage Checkpoints and Storage Rollback
About Storage Checkpoints and Storage Rollback in SF Oracle RAC
Using Storage Checkpoints and Storage Rollback for backup and restore
Storage Checkpoints
Storage Rollbacks
Storage Checkpoints and Storage Rollback process
Determining space requirements for Storage Checkpoints
Storage Checkpoint Performance
Backing up and recovering the database using Storage Checkpoints
Specify the Storage Checkpoint option
Verifying a Storage Checkpoint
Backing up using a Storage Checkpoint
Recovering a database using a Storage Checkpoint
Guidelines for Oracle recovery
Back up all control files before Storage Rollback
Ensure that the control files are not rolled back
Ensure that all archived redo logs are available
Media recovery procedures
Using the Storage Checkpoint Command Line Interface (CLI)
Commands Overview
Command Line Interface examples
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
Creating and working with Storage Checkpoint allocation policies using dbed_ckptpolicy
Performing Storage Rollback using dbed_ckptrollback
Removing Storage Checkpoints using dbed_ckptremove
Cloning the Oracle instance using dbed_clonedb
5. Using Database FlashSnap for backup and off-host processing
About Veritas Database FlashSnap
Solving typical database problems with Database FlashSnap
Database FlashSnap applications
Using Database FlashSnap
Using Database FlashSnap commands
Using the Database FlashSnap online option
Planning to use Database FlashSnap
Selecting the snapshot mode
Preparing hosts and storage for Database FlashSnap
Setting up hosts
Creating a snapshot mirror of a volume or volume set used by the database
Upgrading existing volumes to use Veritas Volume Manager 5.0
About creating database snapshots
Online database snapshots
Tasks before creating a snapshot
Creating a snapshot
Tasks after creating a snapshot
FlashSnap commands
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. Using Database Dynamic Storage Tiering
About Database Dynamic Storage Tiering
Database Dynamic Storage Tiering building blocks
Database Dynamic Storage Tiering in a High Availability (HA) environment
Dynamic Storage Tiering policy management
Relocating files
Relocating tablespaces
Relocating table partitions
Using preset policies
Configuring Database Dynamic Storage Tiering
Database Dynamic Storage Tiering command requirements
Defining database parameters
Setting up storage classes
Converting a VxFS file system to a VxFS multi-volume file system
Classifying volumes into a storage class
Displaying free space on your storage class
Adding new volumes to a storage class
Removing volumes from a storage class
Extent balancing in a database environment
Extent balancing file system
Creating an extent balanced file system
Running Database Dynamic Storage Tiering reports
Viewing modified allocation policies
Viewing audit reports
Oracle Database Dynamic Storage Tiering use cases
Migrating partitioned data and tablespaces
Scheduling the relocation of archive and Flashback logs
7. Investigating I/O performance using storage mapping
About Storage Mapping in SF Oracle RAC
Understanding Storage Mapping
Verifying Veritas Storage Mapping set up
Using the vxstorage_stats command
Displaying Storage Mapping information
Displaying I/O statistics information
Using the dbed_analyzer command
Obtaining Storage Mapping information for a list of tablespaces
About arrays for Storage Mapping and statistics
Oracle File Mapping (ORAMAP)
Mapping components
Storage Mapping views
Verifying Oracle file mapping set up
Enabling Oracle file mapping
Accessing dynamic performance views
Using Oracle Enterprise Manager
8. Troubleshooting SF Oracle RAC
About troubleshooting SF Oracle RAC
Running scripts for engineering support analysis
Troubleshooting tips
Troubleshooting I/O fencing
SCSI reservation errors during bootup
The vxfentsthdw utility fails when SCSI TEST UNIT READY command fails
Node is unable to join cluster while another node is being ejected
System panics to prevent potential data corruption
Clearing keys after split brain using vxfenclearpre command
Registered keys are lost on the coordinator disks
Replacing defective disks when the cluster is offline
Troubleshooting CVM
Shared disk group cannot be imported
Error importing shared disk groups
Unable to start CVM
CVMVolDg not online even though CVMCluster is online
Troubleshooting the repository database
sfua_db_config script command options
Switching the repository database from one node to another
Troubleshooting Database Dynamic Storage Tiering commands
Troubleshooting VCSIPC
VCSIPC wait warning messages in Oracle trace/log files
VCSIPC errors in Oracle trace/log files
Troubleshooting interconnects
Restoring communication between host and disks after cable disconnection
Troubleshooting Oracle
Oracle user must be able to read /etc/llttab File
Error when starting an Oracle instance
Clearing Oracle group faults
Oracle log files show shutdown called even when not shutdown manually
Resolving ASYNCH_IO errors
Oracle Clusterware processes fail to startup
Oracle Clusterware fails after restart
Removing Oracle Clusterware if installation fails
Troubleshooting the Virtual IP (VIP) Configuration
OCR and Vote disk related issues
Troubleshooting ODM
File System configured incorrectly for ODM shuts down Oracle
9. Prevention and recovery strategies
Prevention and recovery strategies
Verification of GAB ports in SF Oracle RAC cluster
Examining GAB seed membership
Manual GAB membership seeding
Verifying normal functioning of VCS I/O fencing
Managing SCSI-3 PR keys in SF Oracle RAC cluster
Identifying a faulty coordinator LUN
Listing all the CVM shared disks
10. Tunable parameters
About SF Oracle RAC tunable parameters
About LMX tunable parameters
LMX tunable parameters
About VXFEN tunable parameters
Configuring the VXFEN module parameters
A. Database FlashSnap status information
About Database FlashSnap status information
Database FlashSnap status information from the GUI
Snapshot status information from the GUI
Snapshot database status information from the GUI
Database FlashSnap Snapshot status information from the CLI
Snapshot status information from the CLI
Snapshot database status information from the CLI
B. Using third party software to back up files
About using third party software to back up files
Using third party software to back up files
Backing up and restoring Oracle Disk Manager files using Oracle RMAN
C. Error messages
About error messages
LMX error messages
LMX critical error messages
LMX non-critical error messages
VxVM error messages
VXFEN driver error messages
VXFEN driver informational message
Node ejection informational messages

Attachments

sfrac_admin_hpux_501.pdf (2.6 MBytes)

Article URL http://www.symantec.com/docs/DOC3069


Terms of use for this information are found in Legal Notices