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
Troubleshooting SmartTier for Oracle
If the SmartTier for Oracle commands fail as in the following example, review the tsdb_debug.log.
The tsdb_debug.log is located at:
/var/vx/vxdba/logs/tsdb_debug.log
For example, when the following message appears after issuing a dbdst_addvol command review the tsdb_debug.log:
$ /opt/VRTS/bin/dbdst_addvol -S BLM21 -M /dev/vx/dsk/nobody_data1/ \ data1vol -v new_vol1:fast_storage,new_vol2:slow_storage,new_vol3:slow_storage SFORA dbdst_addvol ERROR V-81-6222 Could not add volume new_vol1 to vset
The tsdb_debug.log file contains information that resembles the following:
# view /var/vx/vxdba/logs/tsdb_debug.log 1216606 Tue May 13 10:11:05 2008 /opt/VRTS/bin/dbdst_addvol -S BLM21 -M /dev/vx/dsk/nobody_data1/data1vol -v new _vol1:fast_storage,new_vol2:slow_storage, new_vol3:slow_storage 1216606 Tue May 13 10:11:09 2008 RACmaster = system1 1216606 Tue May 13 10:11:09 2008 system1:/opt/VRTSdbed/common/.dba/tsdb_setup.sh -g nobody_data1 -o addvol -d\ data1vol - v new_vol1 -m /oradata1 -t vxfs.placement_class.FAST_STORAGE 1216606 Tue May 13 10:11:09 2008 command failed, ret=1
1216606 Tue May 13 10:11:09 2008 tsdb_setup.sh arguments -g nobody_data1 -o addvol -d data1vol -v new_vol1 -m /or adata1 -t vxfs.placement_class.FAST_STORAGE 05/13/08@17:08:11 size of volume new_vol1 is 204800 VxVM vxvset ERROR V-5-1-10035 Volume set data1vol contains volume(s) in snapshot chain. This can cause inconsistencies in the snapshot hierarchy. Specify "-f" option to force the operation. ^^^^ NOTE: here is the reason for the failure, barried in this log file: ^^^^ /var/vx/vxdba/logs/tsdb_debug.log Can not add to data1vol, ERR 1 ERROR:1