Please enter search query.
Search <book_title>...
Veritas InfoScale™ 8.0.2 Storage and Availability Management for Oracle Databases - AIX, Linux, Solaris
Last Published:
2023-06-12
Product(s):
InfoScale & Storage Foundation (8.0.2)
Platform: 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
Example for creating a snapplan with mapped mount option enabled
Example for creating a snapplan with mapped mount option enabled.
$/opt/VRTS/bin/dbed_vmchecksnap -S PROD \ -H /oracle/product/orahome -f snap2 -o setdefaults -t host2 -m SFDB vxsfadm WARNING V-81-0000 dbed_vmchecksnap will be deprecated in the next release SFDB vxsfadm WARNING V-81-0000 As an altername use /opt/VRTS/bin/vxsfadm Snapplan snap2 for PROD SNAPSHOT_VERSION=5.0 PRIMARY_HOST=host1 SECONDARY_HOST=host2 PRIMARY_DG=proddg ORACLE_SID=PROD ARCHIVELOG_DEST=/arch SNAPSHOT_ARCHIVE_LOG=yes SNAPSHOT_MODE=online SNAPSHOT_PLEX_TAG=dbed_flashsnap SNAPSHOT_DG_PREFIX=SNAP_ SNAPSHOT_VOL_PREFIX=SNAP_ SNAPSHOT_MIRROR=1 PRODdg:data_vol=/tmp/datadst PRODdg:arch_vol=/tmp/archdst
Example output for an environment when -m option is used in dbed_vmchecksnap :
$ /opt/VRTS/bin/dbed_vmchecksnap -S slave -H $ORACLE_HOME \ -f snapplan3 -o setdefaults -t mensa -m SFDB vxsfadm WARNING V-81-0000 dbed_vmchecksnap will be deprecated in the next release SFDB vxsfadm WARNING V-81-0000 As an altername use /opt/VRTS/bin/vxsfadm Snapplan snapplan3 for slave SNAPSHOT_VERSION=5.0 PRIMARY_HOST=mensa SECONDARY_HOST=mensa PRIMARY_DG=datadg1:datadg2:archdg1 ORACLE_SID=PROD ARCHIVELOG_DEST=/arch SNAPSHOT_ARCHIVE_LOG=yes SNAPSHOT_MODE=online SNAPSHOT_PLEX_TAG=dbed_flashsnap SNAPSHOT_DG_PREFIX=SNAP_ SNAPSHOT_VOL_PREFIX=SNAP_ SNAPSHOT_MIRROR=1 archdg1:arch1vol1= datadg1:data1vol2= datadg1:data1vol1= datadg2:data1vol1= datadg2:data1vol2=
Edit the snapplan and add the mountpoints to the dg:volume pairs before you validate the snapplan. The mountpoints entered would be the location where the clone database would be mounted after a dbed_vmclonedb operation.