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
- Introducing Storage Foundation High Availability (SFHA) Solutions for Oracle
- About Veritas File System
- About Veritas Volume Manager
- About Dynamic Multi-Pathing (DMP)
- About Cluster Server
- About Cluster Server agents
- About Veritas InfoScale Operations Manager
- Feature support for Oracle across Veritas InfoScale 8.0.2 products
- Use cases for Veritas InfoScale products
- Overview of Storage Foundation for Databases
- Section II. Deploying Oracle with Veritas InfoScale products
- Deployment options for Oracle in a Storage Foundation environment
- Oracle deployment options in a Storage Foundation environment
- Oracle single instance in a Storage Foundation environment
- Single instance Oracle with off-host in a Storage Foundation environment
- Single instance Oracle in a highly available cluster with Storage Foundation High Availability
- Single instance Oracle in a parallel cluster with SF Cluster File System HA environment
- About Oracle RAC in a Storage Foundation for Oracle RAC environment
- About Oracle in a replicated Storage Foundation environment
- Deploying Oracle and Storage Foundation in a virtualization environment
- Deploying Oracle with Storage Foundation SmartMove and Thin Provisioning
- Deploying Oracle with Storage Foundation
- Tasks for deploying Oracle databases
- Planning your Oracle storage
- About selecting a volume layout for deploying Oracle
- Setting up disk group for deploying Oracle
- Creating volumes for deploying Oracle
- Creating VxFS file system for deploying Oracle
- Mounting the file system for deploying Oracle
- Installing Oracle and creating database
- 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
- About the Storage Foundation for Databases (SFDB) repository
- Requirements for Storage Foundation for Databases (SFDB) tools
- Storage Foundation for Databases (SFDB) tools availability
- Configuring the Storage Foundation for Databases (SFDB) tools repository
- Backing up and restoring the Storage Foundation for Databases (SFDB) repository
- 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
- 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
- Setting up Veritas Extension for Oracle Disk Manager in SFHA environment
- Configuring the Veritas Extension for Oracle Disk Manager in SFHA environment
- How to prepare existing database storage for Oracle Disk Manager in SFHA environment
- Verifying that Oracle Disk Manager is configured in SFHA environment
- Disabling the Oracle Disk Manager feature in SFHA 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 a basic report of the current read activity by using Cached ODM Advisor in SFHA environment
- Generating summary reports of historical activity by using Cached ODM Advisor in SFHA environment
- Generating historical activity reports on individual datafiles by using Cached ODM Advisor in SFHA environment
- Enabling and disabling Cached ODM on data files by using Cached ODM Advisor in SFHA environment
- Display the Cached ODM states of the database files by using Cached ODM Advisor in SFHA environment
- Show Cached ODM statistics by using Cached ODM Advisor in SFHA environment
- Displaying ODM I/O statistics 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
- Creating Oracle 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
- Creating Quick I/O files in Solaris local zone
- Improving database performance with Cached Quick I/O
- Section V. Using point-in-time copies
- Understanding point-in-time copy methods
- About point-in-time copies
- When to use point-in-time copies
- About Storage Foundation point-in-time copy technologies
- Point-in-time copy solutions supported by SFDB tools
- About snapshot modes supported by Storage Foundation for Databases (SFDB) tools
- 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
- Planning to create an instant space-optimized snapshot
- Preparing a legacy volume for the creation of an instant snapshot
- Creating a shared cache object
- Creating a clone of an Oracle database by using space-optimized snapshots
- Creating multiple clones using FlashSnap snapshots
- Recovering the clone database manually
- Administering Storage Checkpoints
- About Storage Checkpoints
- Database Storage Checkpoints for recovery
- Creating a Database Storage Checkpoint
- Deleting a Database Storage Checkpoint
- Mounting a Database Storage Checkpoint
- Unmounting a Database Storage Checkpoint
- Creating a database clone using a Database Storage Checkpoint
- Restoring database from a Database Storage Checkpoint
- Gathering data for offline-mode Database Storage Checkpoints
- 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
- SmartTier for Oracle command requirements
- Defining database parameters
- Configuring storage classes
- Converting a Veritas File System (VxFS) to a VxFS multi-volume file system
- Classifying volumes into a storage class
- Displaying free space on your storage class
- Adding new volumes to a storage class
- Removing volumes from a storage class
- Optimizing database storage using SmartTier for Oracle
- Running reports using SmartTier for Oracle
- Extent balancing in a database environment using SmartTier for Oracle
- Running sub-file database object reports using SmartTier for Oracle
- Optimizing sub-file database object placement 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
- About the Compression Advisor tool
- Compressing Oracle archive logs using Compression Advisor
- Displaying compression candidate data files using Compression Advisor
- Compressing Oracle data files using Compression Advisor
- Displaying compressed data files using Compression Advisor
- Uncompressing Oracle data files using Compression Advisor
- Compression Advisor command reference
- 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
- Additional documentation
- About tuning Veritas Volume Manager (VxVM)
- About tuning VxFS
- About tuning Oracle databases
- About tuning AIX Virtual Memory Manager
- About tuning Solaris for Oracle
- Troubleshooting SFDB tools
- About troubleshooting Storage Foundation for Databases (SFDB) tools
- About the vxdbd daemon
- Troubleshooting vxdbd
- Resources for troubleshooting SFDB tools
- Troubleshooting SmartTier for Oracle
- Upgrading Storage Foundation for Databases (SFDB) tools from 5.0.x to 8.0.2 (2184482)
- Troubleshooting Reverse Resynchronization
- Manual recovery of Oracle database
- Storage Foundation for Databases command reference for the releases prior to 6.0
- About SFDB commands backward compatibility
- Storage Foundation for Databases (SFDB) tools features which are no longer supported
- 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)
- Resynchronizing the snapshot to your database
- Removing a snapshot volume
- Guidelines for Oracle recovery
- Database Storage Checkpoint Commands
- Creating or updating the repository using dbed_update
- Creating Storage Checkpoints using dbed_ckptcreate
- Displaying Storage Checkpoints using dbed_ckptdisplay
- Mounting Storage Checkpoints using dbed_ckptmount
- Unmounting Storage Checkpoints using dbed_ckptumount
- Performing Storage Rollback using dbed_ckptrollback
- Removing Storage Checkpoints using dbed_ckptremove
- Cloning the Oracle instance using dbed_clonedb
- 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 procedure to create a snapshot mirror of a volume
This example shows the steps involved in creating a snapshot mirror for the volume data_vol belonging to the disk group PRODdg.
Note:
You must be logged in as superuser (root) to issue the commands in the following procedure.
To create a snapshot mirror of the volume data_vol
- Prepare the volume data_vol for mirroring:
# vxsnap -g PRODdg prepare data_vol alloc=PRODdg01,PRODdg02
- Verify that FastResync is enabled:
# vxprint -g PRODdg -F%fastresync data_vol
on
- Verify that a DCO and a DCO log are attached to the volume:
# vxprint -g PRODdg -F%hasdcolog data_vol
on
- Create a snapshot mirror of data_vol:
# vxsnap -g PRODdg addmir data_vol alloc=PRODdg02
- List the data plexes:
# vxprint -g PRODdg -F%name -e"pl_v_name in \"data_vol\""
data_vol-01
data_vol-02
- Choose the plex that is in the SNAPDONE state. Use the vxprint -g diskgroup command to identify the plex that is in the SNAPDONE state.
- Identify the plex name in the above step and set the dbed_flashsnap tag for it:
# vxedit -g PRODdg set putil2=dbed_flashsnap data_vol-02
- Verify that the dbed_flashsnap tag has been set to the desired data plex, data_vol-02:
# vxprint -g PRODdg -F%name -e"pl_v_name in \"data_vol\" \ && p2 in \"dbed_flashsnap\"" data_vol-02
- To verify that the snapshot volume was created successfully, use the vxprint -g dg command as follows:
# vxprint -g PRODdg
# vxprint -g flashdgso
TY NAME ASSOC KSTATE LENGTH PLOFFS STATE TUTIL0 PUTIL0 dg flashdgso flashdgso - - - - - - dm hdisk5 hdisk5 - 10411776 - - - - dm hdisk6 hdisk6 - 10411776 - - - - dm hdisk8 hdisk8 - 10411776 - - - - dm hdisk10 hdisk10 - 10411776 - - - - dm hdisk14 hdisk14 - 10411776 - - - - dm hdisk17 hdisk17 - 10411776 - - - - v archvol fsgen ENABLED 10237952 - ACTIVE - - pl archvol-01 archvol ENABLED 10237952 - ACTIVE - - sd hdisk6-01 archvol-01 ENABLED 10237952 0 - - - pl archvol-02 archvol ENABLED 10237952 - SNAPDONE - - sd hdisk8-01 archvol-02 ENABLED 10237952 0 - - - dc archvol_dco archvol - - - - - - v archvol_dcl gen ENABLED 1120 - ACTIVE - - pl archvol_dcl-01 archvol_dcl ENABLED 1120 - ACTIVE - - sd hdisk14-01 archvol_dcl-01 ENABLED 1120 0 - - - pl archvol_dcl-02 archvol_dcl DISABLED 1120 - DCOSNP - - sd hdisk8-02 archvol_dcl-02 ENABLED 1120 0 - - - v datavol fsgen ENABLED 10237952 - ACTIVE - - pl datavol-01 datavol ENABLED 10237952 - ACTIVE - - sd hdisk5-01 datavol-01 ENABLED 10237952 0 - - - pl datavol-02 datavol ENABLED 10237952 - SNAPDONE - - sd hdisk10-01 datavol-02 ENABLED 10237952 0 - - - dc datavol_dco datavol - - - - - - v datavol_dcl gen ENABLED 1120 - ACTIVE - - pl datavol_dcl-01 datavol_dcl ENABLED 1120 - ACTIVE - - sd hdisk17-01 datavol_dcl-01 ENABLED 1120 0 - - - pl datavol_dcl-02 datavol_dcl DISABLED 1120 - DCOSNP - - sd hdisk10-02 datavol_dcl-02 ENABLED 1120 0 - - -
TY NAME ASSOC KSTATE LENGTH PLOFFS STATE TUTIL0 PUTIL0 dg PRODdg PRODdg - - - - - - dm PRODdg01 Disk_1 - 71117760 - - - - dm PRODdg02 Disk_2 - 71117760 - - - - dm PRODdg03 Disk_3 - 71117760 - - - -
TY NAME ASSOC KSTATE LENGTH PLOFFS STATE TUTIL0 PUTIL0 dg PRODdg PRODdg - - - - - - dm PRODdg01 c1t2d0s2 - 35358848 - - - - dm PRODdg02 c1t3d0s2 - 17674896 - - - - dm PRODdg03 c1t1d0s2 - 17674896 - - - -
v data_vol fsgen ENABLED 4194304 - ACTIVE - - pl data_vol-01 data_vol ENABLED 4194304 - ACTIVE - - sd PRODdg03-01 data_vol-01 ENABLED 4194304 0 - - - pl data_vol-02 data_vol ENABLED 4194304 - SNAPDONE - - sd PRODdg02-01 data_vol-02 ENABLED 4194304 0 - - - dc data_vol_dco data_vol - - - - - - v data_vol_dcl gen ENABLED 560 - ACTIVE - - pl data_vol_dcl-01 data_vol_dcl ENABLED 560 - ACTIVE - - sd PRODdg01-01 data_vol_dcl-01 ENABLED 560 0 - - - pl data_vol_dcl-02 data_vol_dcl DISABLED 560 - DCOSNP - - sd PRODdg02-02 data_vol_dcl-02 ENABLED 560 0 - - -
Identify that the specified plex is in the SNAPDONE state. In this example, it is data_vol-02.
The snapshot mirror is now ready to be used.