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 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.