Veritas™ Storage Foundation: Storage and Availability Management for Oracle Databases

Article:DOC5229  |  Created: 2012-01-27  |  Updated: 2013-05-23  |  Article URL http://www.symantec.com/docs/DOC5229
Article Type
Documentation

Description



Veritas™ Storage Foundation: Storage and Availability Management for Oracle Databases

Contents

I. Storage Foundation solutions for Oracle databases
1. Overview of Storage Foundation for Databases
Introducing Storage Foundation and High Availability Solutions for Oracle
About Veritas File System
About Veritas Volume Manager
About Veritas Dynamic Multi-Pathing
About Veritas Cluster Server
About Veritas Cluster Server agents
About Veritas Operations Manager
Feature support across Veritas Storage Foundation and High Availability Solutions 6.0 products
About Storage Foundation and High Availability Solutions
II. Deploying an Oracle database in the Storage Foundation environment
2. Deployment options for Oracle in a Storage Foundation environment
Oracle deployment options in a Storage Foundation environment
About single instance Oracle in a Storage Foundation environment
About single instance Oracle with off-host in a Storage Foundation environment
About single instance Oracle and HA configuration in a Storage Foundation environment
About single instance Oracle in a SF Cluster File System HA environment
About Oracle RAC in a Storage Foundation for Oracle RAC environment
About Oracle in a replicated Storage Foundation environment
Deploying Oracle and Storage Foundation in a virtualization environment
Deploying Oracle with Storage Foundation SmartMove and Thin Provisioning
3. Deploying single instance Oracle with Storage Foundation
Tasks for deploying Oracle databases
Planning your Oracle storage
About selecting a volume layout for deploying Oracle
Setting up disk group for deploying Oracle
Creating volumes for deploying Oracle
Creating VxFS file system for deploying Oracle
Mounting the file system for deploying Oracle
Installing Oracle and creating database
4. Deploying single instance Oracle with off-host with Storage Foundation
Requirements for an off-host database configuration
5. Deploying single instance Oracle with High Availability
Tasks for deploying Oracle in an HA configuration
Configuring VCS to make the database highly available
6. Deploying Oracle with Veritas Volume Replicator (VVR) for disaster recovery
About deploying Oracle with Veritas Volume Replicator (VVR) for disaster recovery
Tasks for deploying Oracle with Veritas Volume Replicator (VVR) for disaster recovery
Setting up the primary node for deploying Oracle
Setting up the secondary node for deploying Oracle
Configuring Veritas Volume Replicator (VVR) between primary and secondary nodes for deploying Oracle
III. Configuring Storage Foundation for Database (SFDB) tools
7. Configuring and managing the Storage Foundation for Databases repository database
About the Storage Foundation for Databases (SFDB) repository
Requirements for Storage Foundation for Databases (SFDB) tools
Storage Foundation for Databases (SFDB) tools availability
Configuring the Storage Foundation for Databases (SFDB) tools repository
Backing up and restoring the Storage Foundation for Databases (SFDB) repository
Updating the Storage Foundation for Databases (SFDB) repository after adding a node
Updating the Storage Foundation for Databases (SFDB) repository after removing a node
Removing the Storage Foundation for Databases (SFDB) repository after removing the product
8. Upgrading and migrating Storage Foundation for Databases (SFDB) tools
About upgrading Storage Foundation for Databases (SFDB) tools
Using SFDB tools after upgrading Oracle to 11.2.0.2
9. Configuring authentication for Storage Foundation for Databases (SFDB) tools
Configuring vxdbd for SFDB tools authentication
Adding nodes to a cluster that is using authentication for SFDB tools
Authorizing users to run SFDB commands
IV. Improving Oracle performance
10. About database accelerators
About Storage Foundation and High Availability Solutions products database accelerators
11. Improving database performance with Veritas Extension for Oracle Disk Manager
About Oracle Disk Manager in SFHA environment
Setting up Veritas Extension for Oracle Disk Manager in SFHA environment
Configuring the Veritas extension for Oracle Disk Manager in an SFHA environment
How to prepare existing database storage for Oracle Disk Manager in SFHA environment
Converting Quick I/O files to Oracle Disk Manager files in SFHA environment
Verifying that Oracle Disk Manager is configured in SFHA environment
Disabling the Oracle Disk Manager feature in SFHA environment
12. Improving database performance with Veritas Cached Oracle Disk Manager
About Cached ODM in SFHA environment
Configuring Cached ODM in SFHA environment
Administering Cached ODM settings with Cached ODM Advisor in SFHA environment
13. Improving database performance with Veritas Quick I/O
About Quick I/O
Creating Oracle database files as Quick I/O files using qiomkfile
Preallocating space for Quick I/O files using the setext command
Accessing regular VxFS files as Quick I/O files
Converting Oracle files to Quick I/O files
About sparse files
Handling Oracle temporary tablespaces and Quick I/O
Displaying Quick I/O status and file attributes
Extending a Quick I/O file
Using Oracle's AUTOEXTEND with Quick I/O files
Recreating Quick I/O files after restoring a database
Disabling Quick I/O
Creating Quick I/O files in Solaris local zone
14. Improving database performance with Veritas Cached Quick I/O
About Cached Quick I/O
Tasks for setting up Cached Quick I/O
Enabling Cached Quick I/O on a file system
Determining candidates for Cached Quick I/O
Enabling and disabling Cached Quick I/O for individual files
V. Managing Oracle point-in-time copies
15. Understanding point-in-time copy methods
About point-in-time copies
When to use point-in-time copies
About Storage Foundation point-in-time copy technologies
Point-in-time copy solutions supported by SFDB tools
About snapshot modes supported by Storage Foundation for Databases (SFDB) tools
Volume-level snapshots
Storage Checkpoints
About FileSnaps
16. Considerations for Oracle point-in-time copies
Considerations for database layouts
Supported Oracle configurations
Behavior of clone databases
17. Administering third-mirror break-off snapshots
Database FlashSnap for cloning
Preparing hosts and storage for Database FlashSnap
Creating a clone of an Oracle database by using Database FlashSnap
Resynchronizing mirror volumes with primary volumes
Recovering the database manually
Cloning a database on the secondary host
18. Administering space-optimized snapshots
Planning to create an instant space-optimized snapshot
Preparing a legacy volume for the creation of an instant snapshot
Creating a shared cache object
Creating a clone of an Oracle database by using space-optimized snapshots
Recovering the database manually by using space-optimized snapshots
19. Administering Storage Checkpoints
About Storage Checkpoints
Database Storage Checkpoints for recovery
Creating a Database Storage Checkpoint
Deleting a Database Storage Checkpoint
Mounting a Database Storage Checkpoint
Unmounting a Database Storage Checkpoint
Creating a database clone using a Database Storage Checkpoint
Restoring data files from a Database Storage Checkpoint
Gathering data for offline-mode Database Storage Checkpoints
20. Administering FileSnap snapshots
Preparing to use FileSnap
Creating a clone of an Oracle database by using FileSnap
Destroying a database clone created by using FileSnap
Destroying a FileSnap snapshot
Restoring database files from a FileSnap snapshot
Viewing the list of snapshots and clones created by using FileSnap
21. Backing up and restoring with Netbackup in an SFHA environment
About Veritas NetBackup
About using Veritas NetBackup for backup and restore for Oracle
About using Veritas NetBackup to backup and restore Oracle Disk Manager files
Using Veritas NetBackup to backup and restore Quick I/O files for Oracle
Using NetBackup in an SFHA Solutions product environment
VI. Optimizing storage costs for Oracle
22. Understanding storage tiering with SmartTier
About SmartTier
SmartTier building blocks
How SmartTier works
How SmartTier for Oracle works
SmartTier in a High Availability (HA) environment
23. Configuring and administering SmartTier
Configuring SmartTier for Oracle
Optimizing database storage using SmartTier for Oracle
Running reports using SmartTier for Oracle
Extent balancing in a database environment using SmartTier for Oracle
Running sub-file database object reports using SmartTier for Oracle
Optimizing sub-file database object placement using SmartTier for Oracle
24. SmartTier for Oracle use cases
SmartTier for Oracle file-based use cases
SmartTier for Oracle sub-file use cases
25. Compressing files and databases to optimize storage costs
Compressed files and databases
VII. Managing Oracle disaster recovery
26. Using Storage Foundation for Databases (SFDB) tools in a replicated environment
About using SF Databases tools with Veritas Volume Replicator (VVR)
Using ODM, Cached ODM, Quick IO, and Cached IO for the Oracle database in a Veritas Volume Replicator (VVR) environment
Using Storage Foundation for Databases (SFDB) tools in a Veritas Volume Replicator (VVR) environment
About deploying Storage Foundation for Databases (SFDB) tools with Oracle Data Guard
27. Using space-optimized snapshots in a replicated environment
Considerations for using space-optimized snapshots with VVR
Configuring hosts to use space-optimized snapshots with VVR
Considerations for using vxsfadm after replication role transfer
VIII. Storage Foundation for Databases administrative reference
28. Storage Foundation for Databases command reference
vxsfadm command reference
FlashSnap reference
Space-optimized snapshots reference
FileSnap reference
Database Storage Checkpoints reference
29. Tuning for Storage Foundation for Databases
Additional documentation
About tuning VxVM
About tuning VxFS
About tuning Oracle databases
About tuning AIX Virtual Memory Manager
About tuning HP-UX
About tuning Solaris for Oracle
30. Troubleshooting SFDB tools
About troubleshooting Storage Foundation for Databases (SFDB) tools
About the vxdbd daemon
Troubleshooting vxdbd
Resources for troubleshooting SFDB tools
Troubleshooting SmartTier for Oracle
Upgrading Veritas Storage Foundation for Databases (SFDB) tools from 5.0MP2 to 6.0 (2003131)
Upgrading Veritas Storage Foundation for Databases (SFDB) tools from 5.0x to 6.0 (2184482)
Upgrading in an HP Serviceguard environment (2116455)
31. Manual recovery of Oracle database
Manual recovery of a clone database
Manual recovery after a restore operation
32. Storage Foundation for Databases command reference for previous releases
About SFDB commands backward compatibility
Veritas Storage Foundation for Databases (SFDB) tools features which are no longer supported
Preparing storage for Database FlashSnap
About creating database snapshots
FlashSnap commands
Guidelines for Oracle recovery
Database Storage Checkpoint Commands
IX. Reference
A. Integrating Storage Foundation Application Edition with Oracle Enterprise Manager
About Symantec Plug-ins for Oracle Enterprise Manager
Requirements for Symantec Plug-ins for Oracle Enterprise Manager
Deploying the Storage Foundation Plug-in for Oracle Enterprise Manager
Deploying the Veritas Cluster Server Plug-in for Oracle Enterprise Manager
Adding instances for monitoring in the VCS Plug-in for OEM
Adding instances for monitoring in the Storage Foundation Plug-in for OEM
Viewing Storage Foundation Plug-in for OEM reports
Viewing Veritas Cluster Server Plug-in for OEM reports
Troubleshooting the SFHA Plug-ins for OEM
B. VCS Oracle agents
VCS agents for Oracle
C. Sample configuration files for clustered deployments
About sample configuration files
Sample configuration file for Storage Foundation for High Availability
Sample configuration file for Storage Foundation for Clustered File System HA
Sample configuration file for Storage Foundation for Oracle RAC
D. Database FlashSnap status information
About Database FlashSnap status information
Database FlashSnap Snapshot status information from the CLI
E. 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

Attachments

sf_adv_ora_60_unix.pdf (7.7 MBytes)

Legacy ID



uxrt-60_sf_adv_ora_60_v69496589


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


Terms of use for this information are found in Legal Notices