Veritas InfoScale™ 8.0.2 Storage and Availability Management for Oracle Databases - AIX, Linux, Solaris
- Section I. Storage Foundation High Availability (SFHA) management solutions for Oracle databases
- Overview of Storage Foundation for Databases
- About Veritas File System
- Overview of Storage Foundation for Databases
- Section II. Deploying Oracle with Veritas InfoScale products
- Deployment options for Oracle in a Storage Foundation environment
- Deploying Oracle with Storage Foundation
- Setting up disk group for deploying Oracle
- Creating volumes for deploying Oracle
- Creating VxFS file system for deploying Oracle
- Deploying Oracle in an off-host configuration with Storage Foundation
- Deploying Oracle with High Availability
- Deploying Oracle with Volume Replicator (VVR) for disaster recovery
- Deployment options for Oracle in a Storage Foundation environment
- Section III. Configuring Storage Foundation for Database (SFDB) tools
- Configuring and managing the Storage Foundation for Databases repository database
- Configuring the Storage Foundation for Databases (SFDB) tools repository
- Configuring authentication for Storage Foundation for Databases (SFDB) tools
- Configuring and managing the Storage Foundation for Databases repository database
- Section IV. Improving Oracle database performance
- About database accelerators
- Improving database performance with Veritas Extension for Oracle Disk Manager
- About Oracle Disk Manager in the Veritas InfoScale products environment
- 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
- Generating reports of candidate datafiles by using Cached ODM Advisor in SFHA environment
- Generating summary reports of historical activity by using Cached ODM Advisor in SFHA environment
- Generating reports of candidate datafiles by using Cached ODM Advisor in SFHA environment
- Improving database performance with Quick I/O
- About Quick I/O
- Improving database performance with Cached Quick I/O
- Section V. Using point-in-time copies
- Understanding point-in-time copy methods
- Volume-level snapshots
- About Reverse Resynchronization in volume-level snapshots (FlashSnap)
- Storage Checkpoints
- About FileSnaps
- Considerations for Oracle point-in-time copies
- Administering third-mirror break-off snapshots
- Administering space-optimized snapshots
- Creating a clone of an Oracle database by using space-optimized snapshots
- Administering Storage Checkpoints
- Database Storage Checkpoints for recovery
- Administering FileSnap snapshots
- Backing up and restoring with Netbackup in an SFHA environment
- Understanding point-in-time copy methods
- Section VI. Optimizing storage costs for Oracle
- Understanding storage tiering with SmartTier
- Configuring and administering SmartTier
- Configuring SmartTier for Oracle
- Optimizing database storage using SmartTier for Oracle
- Extent balancing in a database environment using SmartTier for Oracle
- Configuring SmartTier for Oracle
- SmartTier use cases for Oracle
- Compressing files and databases to optimize storage costs
- Using the Compression Advisor tool
- Section VII. Managing Oracle disaster recovery
- Section VIII. Storage Foundation for Databases administrative reference
- Storage Foundation for Databases command reference
- Tuning for Storage Foundation for Databases
- About tuning Veritas Volume Manager (VxVM)
- About tuning VxFS
- About tuning Oracle databases
- About tuning Solaris for Oracle
- Troubleshooting SFDB tools
- About troubleshooting Storage Foundation for Databases (SFDB) tools
- About the vxdbd daemon
- Resources for troubleshooting SFDB tools
- Manual recovery of Oracle database
- Storage Foundation for Databases command reference for the releases prior to 6.0
- Preparing storage for Database FlashSnap
- About creating database snapshots
- 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)
- Guidelines for Oracle recovery
- Database Storage Checkpoint Commands
- Section IX. Reference
- Appendix A. VCS Oracle agents
- Appendix B. Sample configuration files for clustered deployments
- Appendix C. Database FlashSnap status information
- Appendix D. Using third party software to back up files
Upgrading existing volumes to use Veritas Volume Manager 8.0.2
The procedure in this section describes how to upgrade a volume created using a version older than VxVM 5.0 so that it can take advantage of FlashSnap and space-optimized snapshots.
Note the following requirements and caveats for this procedure:
The plexes of the DCO volume require persistent storage space on disk to be available. To make room for the DCO plexes, you may need to add extra disks to the disk group, or reconfigure existing volumes to free up space in the disk group. Another way to add disk space is to use the disk group move feature to bring in spare disks from a different disk group.
Existing snapshot volumes created by the vxassist command are not supported. A combination of snapshot volumes created by vxassist and vxsnap are also not supported.
You must be logged in as superuser (root) to issue the commands in the following procedure.
To upgrade an existing volume created with an earlier version of VxVM
- Upgrade the disk group that contains the volume to version 120 or higher before performing the remainder of the procedure described in this section. Use the following command to check the version of a disk group:
# vxdg list diskgroup
To upgrade a disk group to the latest version, use the following command:
# vxdg upgrade diskgroup
- If the volume to be upgraded has a DRL plex or subdisk from an earlier version of VxVM, use the following command to remove this:
# vxassist [-g diskgroup] remove log volume [nlog=n]
Use the optional attribute nlog=n to specify the number, n, of logs to be removed. By default, the vxassist command removes one log.
- For a volume that has one or more associated snapshot volumes, use the following command to reattach and resynchronize each snapshot:
# vxsnap [-g diskgroup] snapback snapvol
If persistent FastResync was enabled on the volume before the snapshot was taken, the data in the snapshot plexes is quickly resynchronized from the original volume. If persistent FastResync was not enabled, a full resynchronization is performed.
- Use the following command to turn off persistent FastResync for the volume:
# vxvol [-g diskgroup] set fastresync=off volume
- Use the following command to dissociate a DCO object from an earlier version of VxVM, DCO volume and snap objects from the volume:
# vxassist [-g diskgroup] remove log volume logtype=dco
- Use the following command on the volume to upgrade it:
# vxsnap [-g diskgroup] prepare volume \ alloc="disk_name1,disk_name2"
Provide two disk names to avoid overlapping the storage of the snapshot DCO plex with any other non-moving data or DCO plexes.
The vxsnap prepare command automatically enables persistent FastResync on the volume and on any snapshots that are generated from it. It also associates a DCO and DCO log volume with the volume to be snapshot.
- To view the existing DCO plexes and see whether there are enough for the existing data plexes, enter:
# vxprint -g diskgroup
There needs to be one DCO plex for each existing data plex.
- If there are not enough DCO plexes for the existing data plexes, create more DCO plexes:
# vxsnap [-g diskgroup] addmir dco_volume_name \ [alloc=disk_name]
where dco_volume_name is the name of the DCO volume you are creating.
- If the plex is in a SNAPDONE state, convert it to an ACTIVE state:
# vxplex [-g diskgroup] convert state=ACTIVE data_plex
- Convert the data plexes to a SNAPDONE state and associate a DCO plex with the data plex that will be used for snapshot operations:
# vxplex [-g diskgroup] -o dcoplex=dco_plex_name convert \ state=SNAPDONE data_plex
where dco_plex_name is the name of the DCO plex you are creating.