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
1. Overview of Storage Foundation for Databases
Section II. Deploying Oracle with Veritas InfoScale products
Section III. Configuring Storage Foundation for Database (SFDB) tools
1. Configuring and managing the Storage Foundation for Databases repository database
2. Configuring authentication for Storage Foundation for Databases (SFDB) tools
Section IV. Improving Oracle database performance
Section V. Using point-in-time copies
Section VI. Optimizing storage costs for Oracle
Section VII. Managing Oracle disaster recovery
1. Using Storage Foundation for Databases (SFDB) tools in a replicated environment
2. Using volume snapshots in a replicated environment
Section VIII. Storage Foundation for Databases administrative reference
Section IX. Reference

vxsfadm command reference

vxsfadm is a command line utility that can be used to perform various point-in-time copy operations such as FlashSnap, FileSnap, space-optimized snapshots, and Database Storage Checkpoints for Oracle databases. This utility uses the underlying features of Storage Foundation to perform these operations.

Note:

SFDB tools do not support taking point-in-time copies while structural changes to the database are in progress, such as adding or dropping tablespaces and adding or dropping data files. However, once a point-in-time copy is taken, a clone can be created at any time, regardless of the status of the database.

The vxsfadm utility is supported in multiple database configurations including:

Oracle single instance
Oracle single instance with off-host
Oracle single instance in a highly available setup (VCS cluster)
Oracle single instance with Storage Foundation Cluster File System High Availability
Oracle RAC with Storage Foundation for Oracle RAC
Oracle in a replicated setup with Veritas Volume Replicator or Oracle Data Guard

The syntax of the vxsfadm command is as follows:

vxsfadm -s <service_type> -a <application-name> -o <operation>
[ -c config-file ]
[ -r repository-host ]
[ service-specific parameters ]
[ application-specific parameters ]

vxsfadm -s <service-type> -a application-name> -o list
[ service-specific parameters ]
[ application-specific parameters ]

vxsfadm -s <service-type> -a application-name> -o setdefaults
[ service-specific parameters ]
[ application-specific parameters ]

The following are the vxsfadm parameters.

-s service_type	Specifies the service type for the point-in-time copy operation. Supported service types are: flashsnap: Volume-level snapshots sos: Space-optimized volume-level snapshots filesnap: File-level snapshots checkpoint: File system checkpoints
-o operation	Specifies the point-in-time copy operation that is being performed. The supported operations vary for the different service types. For more information on the operations supported for a service type, refer to the respective vxsfadm man page. The following operations are common to all service types: -o list: Lists all the configurations/services for the specified application. If service_type is specified then all existing configurations for the specified service_type are displayed. -o setdefaults: Generates the default configuration that can be saved to a file and then it can be used for the remainder of the operations.
-a application_name	Specifies the application for which the point-in-time-copy operation is being performed.
-c config_file	All the command line options specific to applications apart from service_type, application_name, and operation can be provided in the configuration file. The information in the configuration file should be in the format PARAMETER_NAME=VALUE. For information about the parameters supported for a service, refer to the respective vxsfadm man page.
-r repository-host	Specifies the host of the SFDB repository for off-host operations.
service-specific parameters	These parameters are required by a service for processing. The most important service-specific parameter is --service_name. For example, if you want to create a third-mirror break-off snapshot (flashsnap), the service_name parameter is flashsnap_name and you can specify a unique identifier for this parameter as follows: --flashsnap_name=dailysnap. This identifier can be used for all operations performed on that copy. These parameters can be provided in the configuration file or they can be exported in the environment. For more information, refer to the vxsfadm man pages.
application-specific parameters	These parameters are required by application for processing. The most important application-specific parameter is the one that uniquely identifies an application instance. For example, if there are two Oracle databases running on a system, oracle_sid and oracle_home parameters uniquely identify the application instance. These parameter are used for all the point-in-time copy operations for the specific application instance. These parameters can be provided in the configuration file or they can be exported in the environment. For more information, refer to the vxsfadm man pages.

Note:

The vxsfadm parameters specified on the command line override the parameters specified in the configuration file and the parameters exported in the environment. The parameters specified in the configuration file override the parameters exported in the environment.

You can use vxsfadm logs and error messages for troubleshooting.

See Resources for troubleshooting SFDB tools.

For more information, refer to the following man pages:

vxsfadm-flashsnap(1M), vxsfadm-checkpoint(1M)

vxsfadm-sos(1M), vxsfadm-filesnap(1M)
vxsfadm-oracle-flashsnap(1M), vxsfadm-oracle-sos(1M),
vxsfadm-oracle-checkpoint(1M), vxsfadm-oracle-filesnap(1M)