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

Article:DOC4503  |  Created: 2011-07-25  |  Updated: 2013-05-23  |  Article URL http://www.symantec.com/docs/DOC4503
Article Type
Documentation


Environment

Description



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

Contents

I. Storage and availability management for Oracle databases
1. Overview of Storage Foundation for Databases (SFDB) tools
About Storage Foundation for Databases (SFDB) tools for Oracle
Storage management features for Storage Foundation products
2. Deploying Storage Foundation for Databases (SFDB) tools
Storage Foundation for Databases (SFDB) tools deployment options
Requirements for Storage Foundation for Databases (SFDB) tools
Deploying Storage Foundation for Databases (SFDB) tools in a Storage Foundation environment
Deploying Storage Foundation for Databases (SFDB) tools in a Storage Foundation HA environment
Deploying Storage Foundation for Databases (SFDB) tools in a SF Cluster File System (HA) environment
Deploying Storage Foundation for Databases (SFDB) tools in a Storage Foundation for Oracle RAC environment
Deploying Storage Foundation for Databases (SFDB) tools in replicated environments
Deploying Storage Foundation for Database (SFDB) tools in a NetBackup environment
Deploying Storage Foundation for Database (SFDB) tools in a Veritas Operations Manager environment
Deploying Storage Foundation for Database (SFDB) tools in a virtualization environment
Deploying Storage Foundation for Database (SFDB) tools with SmartMove and Thin Provisioning
3. Administering Storage Foundation for Databases (SFDB) tools
About administering the Storage Foundation for Databases (SFDB) tools
About the Storage Foundation for Databases (SFDB) repository database
Configuring the Storage Foundation for Databases (SFDB) repository
About upgrading Storage Foundation for Databases (SFDB) tools
Using SFDB tools after upgrading Oracle to 11.2.0.2 (2203228)
Backing up and restoring the Storage Foundation for Databases (SFDB) repository
Migrating an SFHA setup to IPv6
Migrating Storage Foundation for Databases (SFDB) objects from single instance Oracle to Oracle RAC
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
II. Improving performance with database accelerators
4. Overview of database accelerators
About Storage Foundation database accelerators
About Quick I/O
About Cached Quick I/O
About Oracle Disk Manager
About Oracle Disk Manager and Oracle Managed Files
About Cached ODM
5. Improving database performance with Veritas Extension for Oracle Disk Manager
Setting up Veritas Extension for Oracle Disk Manager
Configuring the Veritas extension for Oracle Disk Manager
How to prepare existing database storage for Oracle Disk Manager
Converting Quick I/O files to Oracle Disk Manager files
Verifying that Oracle Disk Manager is configured
Disabling the Oracle Disk Manager feature
6. Improving database performance with Veritas Cached Oracle Disk Manager
Configuring Cached ODM
Administering Cached ODM settings with Cached ODM Manager
7. Improving database performance with Veritas Quick I/O
Creating 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
8. Improving database performance with Veritas 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
III. Making point-in-time copies
9. About point-in-time copies
Database snapshot and backup options
About Veritas Database FlashSnap
How Veritas Database FlashSnap works
About Database Storage Checkpoints and Storage Rollback in SF Enterprise products
10. Using Database FlashSnap for backup and off-host processing
Planning to use Database FlashSnap
Preparing hosts and storage for Database FlashSnap
About creating database snapshots
FlashSnap commands
11. Using Database Storage Checkpoints and Storage Rollback
Using Storage Checkpoints and Storage Rollback for backup and restore
Determining space requirements for Storage Checkpoints
Storage Checkpoint Performance
Backing up and recovering the database using Storage Checkpoints
Guidelines for Oracle recovery
Database Storage Checkpoint Commands
12. 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
IV. Tiering your storage
13. 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
14. Configuring and administering SmartTier
Configuring SmartTier for Oracle
SmartTier policy management
Running SmartTier for Oracle reports
Extent balancing in a database environment
Viewing SmartTier sub-file level reports
Administering SmartTier at the sub-file level
15. SmartTier for Oracle use cases
SmartTier for Oracle file-based use cases
SmartTier for Oracle sub-file use cases
V. Cross-platform migration for Oracle databases using Portable Data Containers
16. Cross-platform migration for Oracle databases using Portable Data Containers
About migrating Oracle databases with Portable Data Containers
Example setup for migrating Oracle databases with Portable Data Containers
Example procedure for migrating Oracle databases with Portable Data Containers
VI. Deploying SFDB tools in a replicated environment
17. Deploying Storage Foundation for Databases (SFDB) tools in a replicated environment
About deploying SF Databases tools with VVR
Using ODM, Cached ODM, Quick IO, and Cached IO for the Oracle database in a VVR environment
Using Storage Foundation for Databases (SFDB) tools in a VVR environment
About deploying Storage Foundation for Databases (SFDB) tools with Oracle Data Guard
VII. Troubleshooting SFDB tools
18. Troubleshooting SFDB tools
About troubleshooting Storage Foundation for Databases (SFDB) tools
About the vxdbd daemon
Troubleshooting Database FlashSnap
Troubleshooting SmartTier for Oracle
Upgrading Veritas Storage Foundation for Databases (SFDB) tools from 5.0MP2 to 5.1SP1 (2003131)
Upgrading Veritas Storage Foundation for Databases (SFDB) tools from 5.0.x to 5.1SP1 (2184482)
Relinking ODM after upgrading from 5.0.x
Upgrading in an HP Serviceguard environment (2116455)
VIII. Reference
A. Deploying Storage Foundation for Databases (SFDB) tools with Oracle Enterprise Manager
About Symantec Plug-ins for Oracle Enterprise Manager
Requirements for Symantec Plug-in support for OEM
Deploying the Storage Foundation Plug-in for OEM
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
Troubleshooting Symantec Plug-ins for OEM
B. 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
C. Database FlashSnap status information
About Database FlashSnap status information
Database FlashSnap Snapshot status information from the CLI
D. 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_51sp1_hpux.pdf (6.5 MBytes)

Legacy ID



uxrt-51sp1_sf_adv_ora_51sp1_v52058045


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


Terms of use for this information are found in Legal Notices