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
Verifying that Oracle Disk Manager is configured in SFHA environment
Before verifying that Oracle Disk Manager is configured, make sure that the following conditions are met:
AIX Prerequisites |
|
Linux Prerequisites |
|
Solaris Prerequisites |
|
To verify that Oracle Disk Manager is configured
- Verify that the ODM feature is included in the license:
# /opt/VRTS/bin/vxlicrep | grep ODM
QLOGODM = Enabled ODM = Enabled
The output verifies that ODM is enabled.
Note:
Verify that the license key containing the ODM feature is not expired. If the license key has expired, you will not be able to use the ODM feature.
- Check that the
VRTSodm
package is installed:Solaris:
# pkginfo VRTSodm
AIX:
# lslpp -L VRTSodm
Linux:
# rpm -qa | grep VRTSodm
or
# rpm -qi VRTSodm
- Check that the Veritas ODM library,
libodm64.so
orlibodm.so
is present; for example:For AIX, use # ls -lL /opt/VRTSodm/lib/libodm64.so.
For Linux, use # ls -lL /opt/VRTSodm/lib/libodm64.so.
For Solaris, use # ls -lL /usr/lib/sparcv9/libodm.so.
To verify that Oracle Disk Manager is running
- Start the Oracle database.
- Check that the instance is using the Oracle Disk Manager function:
# cat /dev/odm/stats # echo $? 0
- Verify that the Oracle Disk Manager is loaded:
Solaris:
# modinfo | grep ODM | grep VRTS 293 7b6d2000 18078 30 1 odm (VRTS ODM 7.4.1.0,REV=internal-b)
Linux:
# lsmod | grep odm vxodm 164480 1 fdd 78976 1 vxodm
AIX:
You can use the genkld or the genkex commands:
# genkld | grep odm or # genkex | grep odm d05a3100 22182 /usr/lib/libodm.a[shr.o] 90000001c0ec000 1675 /ora_base/db_home/lib/libodm12.so 900000000bbf000 1059e /opt/VRTSodm/lib/libodm64.so 90000000043d300 24167 /usr/lib/libodm.a[shr_64.o] bash-3.2# genkex | grep odm f1000000c037a000 27000 /usr/lib/drivers/vxodm.ext_71
- In the alert log, verify the Oracle instance is running. The log should contain output similar to the following:
Oracle instance running with ODM: Veritas 7.4.1.0000 ODM Library, Version 2.0