Veritas Storage Foundation for Oracle RAC Administrator's Guide 5.0 MP3 - Solaris

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



Description



1. Storage Foundation for Oracle RAC overview
About 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
Supported SF Oracle RAC options
Managing databases using SF Oracle RAC
Securing a cluster using SF Oracle RAC
Managing multiple SF Oracle RAC clusters using a common Web console server
Replicating data to a remote site using SF Oracle RAC
2. Configuration best practices
About configuration best practices
Cluster configuration
Basic clustered shared storage cluster
Clusters running in secure mode
Campus, or metropolitan, shared storage cluster
Global cluster
Oracle configuration best practices
Database storage configuration best practices
Database snapshot and backup options
Database FlashSnap for cloning
Storage Checkpoints for recovery
Database storage optimization options
3. Administering SF Oracle RAC and its components
Administering SF Oracle RAC
Setting the PATH variable
Setting the MANPATH variable
Stopping SF Oracle RAC on a single node
Stopping and starting LLT and GAB
Adding LLT links to increase capacity
Turning on the debug messages for the kernel drivers
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
Rebooting nodes in a cluster
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
Adding CFS file systems to VCS configuration
Using cfsmount to mount CFS file systems
Resizing CFS file systems
Verifying the status of CFS file systems
Verifying CFS port
CFS agent log files
Administering CVM
Listing all the CVM shared disks
Establishing CVM cluster membership manually
Manually importing a shared disk group
Manually deporting a shared disk group
Manually starting shared volumes
Evaluating the state of CVM ports
Verifying if CVM is running in an SF Oracle RAC cluster
Verifying CVM membership state
Verifying state of CVM shared disk groups
Verifying activation mode
CVM log files
Administering Oracle
Creating a database
Increasing swap space for Oracle
Stopping CRS
Determining CRS object status
Unregistering Oracle database instances
Configuring virtual IP addresses for CRS
Configuring Oracle group to start and stop CRS objects
Configuring listeners
Starting or stopping Oracle listener
Using srvctl to manage node applications
Starting Oracle Enterprise Manager agent
Clearing Oracle group faults
Starting and stopping Oracle service groups
Administering ODM
Verifying the ODM port
Starting ODM
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
The vxfenswap utility faults when echo or cat is used in .bashrc file
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
Shared disks not visible
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 CFS
Incorrect order in root user's <library> path
Troubleshooting VCSIPC
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
Oracle log files show shutdown called even when not shutdown manually
DBCA fails while creating database
CRS processes fail to startup
CRS fails after restart
Removing Oracle CRS 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
10. 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
Evaluating VCS I/O fencing ports
Verifying normal functioning of VCS I/O fencing
Managing SCSI-3 PGR keys in SF Oracle RAC cluster
Identifying a faulty coordinator LUN
Replacing a faulty coordinator disk without stopping I/O Fencing
Collecting I/O Fencing kernel logs
11. Tunable parameters
About SF Oracle RAC tunable parameters
About LMX tunable parameters
Solaris OS LMX tunable parameters
About VXFEN tunable parameters
Configuring the VXFEN module parameters
To reconfigure the VXFEN module
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_sol.pdf (2.7 MBytes)

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


Terms of use for this information are found in Legal Notices