Veritas Velocity™ User's Guide
- Getting to know Velocity
- Setting up Velocity
- Velocity administrator's checklist for setting up Veritas Velocity
- Database administrator's checklist for setting up Veritas Velocity
- Sandbox user's checklist for setting up Veritas Velocity
- How to set up the Velocity Storage Server
- Deploying the Velocity Storage Server image on a virtual machine
- Velocity Appliance initial configuration requirements
- Configuring network and storage settings for the Velocity Storage Server in a virtual environment
- Registering the Velocity Storage Server
- Joining the Velocity Storage Server to the Active Directory domain
- Adding a Certificate Authority signed certificate to the Velocity Storage Server
- How to set up the Velocity Client
- Deleting a Velocity Client
- Configuring a proxy server for Velocity
- Required and optional ports for Velocity
- Installing the NetBackup Client on the Velocity Storage Server
- Setting up the Velocity on-premises management server
- How to set up the Velocity on-premises management server
- Deploying the Velocity on-premises management server image on a virtual machine
- Configuring the network settings for the Velocity on-premises management server
- Configuring Active Directory/LDAP settings on the Velocity on-premises management server
- Adding users to the Velocity on-premises management server
- Upgrading the Velocity on-premises management server
- Upgrading Velocity
- How to upgrade to Velocity version 2.9
- Finding the Velocity component version numbers
- Downloading and transferring software updates to the Velocity Storage Server
- Removing previous upgrade files
- Upgrading the Velocity Storage Server
- Upgrading the Velocity Client for Linux
- Upgrading the Velocity Client for Windows
- Upgrading the Velocity Client for Solaris
- Velocity Storage Server
- About the Velocity Storage Server
- Viewing physical storage usage on the Velocity Storage Server
- About reclaiming storage space on the Veritas Velocity Storage Server
- Increasing meta and data storage capacity on the Velocity Storage Server
- Deregistering a Velocity Storage Server
- How to reset the Velocity Storage Server
- Users and roles
- Oracle database ingestion using Velocity
- How to provide copies of Oracle databases for sandboxes in Velocity
- Adding an Oracle database to ingest into Velocity
- Ingesting an Oracle database into Velocity for the first time
- Ingesting an Oracle database again after the first ingest
- Canceling an Oracle database ingestion
- How to use copy preparation to mask or sanitize sensitive data
- Masking sensitive data manually in database copies
- Masking sensitive data in database copies by using a script
- Masking sensitive data manually in database copies that are already ingested
- Masking sensitive data by using a script in database copies that are already ingested
- Disabling copy preparation for Oracle database copies
- Ingesting an Oracle database into Velocity from the command line
- About setting custom initialization parameters for a sandbox for an Oracle database copy
- Editing default options for the ingest method for Oracle databases
- Oracle database ingestion using NetBackup CoPilot
- Microsoft SQL Server database ingestion using Velocity
- Automatic ingestion of NetBackup deduplicated backups
- About using NetBackup deduplicated backups to create Velocity sandboxes
- How to set up automatic ingestion of NetBackup deduplicated backups
- Supported Oracle policy options for automatic ingestions of NetBackup deduplicated backups
- Supported SQL Server policy options for automatic ingestions of NetBackup deduplicated backups
- Adding an Oracle database source to automatically ingest NetBackup deduplicated backups
- Adding a SQL Server database source to automatically ingest NetBackup deduplicated backups
- Database sources and copies
- About database sources and copies
- Viewing details of an Oracle database source
- Viewing details of a SQL Server database source
- Changing the nickname or description of a database source
- Deleting a database source from Velocity
- About scheduling ingestions for a database source
- Viewing the ingestion schedule for a database source
- Adding an ingestion schedule to a database source
- Editing the ingestion schedule for a database source
- Deleting the ingestion schedule for a database source
- Restarting scheduled database ingestions after changing the system time or time zone on the Velocity Storage Server
- Retention periods for database sources and copies
- Viewing database copies
- Viewing the number of sandboxes that were created from a database copy
- Viewing the status of database copies
- Deleting database copies
- Sandboxes
- About sandboxes
- Creating a sandbox from an Oracle database copy
- Starting an Oracle database instance manually
- Creating a sandbox from a SQL Server database copy
- Starting a SQL database manually
- Finding your sandbox
- Viewing details about your sandboxes
- Deleting a sandbox
- Managing sandboxes when you restart the host Oracle Database server
- Unmounting a sandbox from an Oracle host server
- Database recovery
- Alerts and logs
- Managing the Velocity physical appliance
- Configuring network address settings on the Velocity physical appliance
- About IPv4-IPv6-based network support on the Velocity physical appliance
- About NIC1 (eth0) port usage on the Velocity physical appliance
- Creating a network interface bond (NIC bond) on the Velocity physical appliance
- VLAN tagging on the Velocity physical appliance
- Configuring static routes on the Velocity physical appliance
- Configuring DNS and host name mapping on the Velocity physical appliance
- Setting the host name for the Velocity physical appliance
- Using a proxy server with the Velocity physical appliance
- About WAN optimization on the Velocity physical appliance
- About the maximum transmission unit size on the Velocity physical appliance
- Setting the date and time on the Velocity physical appliance
- About the Veritas Remote Management Console on the Velocity physical appliance
- About Velocity physical appliance storage
- About users on the Velocity physical appliance
- About Velocity physical appliance checkpoints
- About factory reset on the Velocity physical appliance
- Configuring network address settings on the Velocity physical appliance
- Monitoring the Velocity physical appliance
- Velocity physical appliance security
- About Velocity physical appliance user account privileges
- About the Velocity physical appliance intrusion detection system
- About Velocity physical appliance operating system security
- About data security on the Velocity physical appliance
- About data integrity on the Velocity physical appliance
- About the Velocity physical appliance ports
- Recommended IPMI settings on the Velocity physical appliance
- Velocity REST APIs
- Getting started with Velocity REST APIs
- Authenticate a user for the Velocity REST APIs
- Get Velocity Storage Servers
- Create a share
- Find the share ID
- Find the share location
- Create a snapshot
- Find the snapshot ID
- Create a sandbox
- Find the sandbox ID
- Get a sandbox
- Delete a share
- Delete a snapshot
- Delete a sandbox
- Get templates (shares)
- Get snapshots
- List all sandboxes
- Best practices
- Troubleshooting
- NFS export paths where ingested Oracle Database sources are stored are inaccessible
- NFS export path is not created during a database ingestion
- Database ingestion fails with the Oracle error 'diskgroup {xx} space exhausted'
- After restart of the vpfsd service, links to the applications are broken
- Sandbox creation fails on an Oracle Database server
- Sandbox creation fails for a SQL Server database copy
- Sandbox creation fails after you use the --adGroups argument when you configure the Velocity Client for Windows
- Sandbox creation may take longer than usual on Oracle Database 12c
- A sandbox cannot be deleted from an Oracle Database server because the mount point is busy
- Error occurs when registering the Velocity Client; provide the Oracle DBA with access to the Velocity registration files
- Error occurs when a new sandbox name has the same name as a deleted sandbox
- Ingestions and sandboxes are stuck 'In Progress' after the Velocity Storage Server is restarted
- Glossary
- Section I. Velocity shell menu commands
- Introduction
- Appendix A. Main > Manage > Storage
- Appendix B. Main > Manage > Cloud
- Appendix C. Main > Manage > Software
- Appendix D. Main > Monitor
- Appendix E. Main > Network
- Network > Configure
- Network > Date
- Network > DNS
- Network > Gateway
- Network > Hostname
- Network > Hosts
- Network > IPv4
- Network > IPv6
- Network > NetStat
- Network > NTPServer
- Network > LinkAggregation
- Network > VLAN
- Network > WANOptimization
- Network > Ping
- Network > Proxy
- Network > SetProperty
- Network > Show
- Network > TimeZone
- Network > TraceRoute
- Network > Unconfigure
- Appendix F. Main > Settings
- Appendix G. Main > Support
Ingesting an Oracle database into Velocity from the command line
Velocity provides an application named ingest_dba that you can run from the command line to ingest an Oracle database from an Oracle server to an NFS mount path on the Velocity Storage Server. The ingest_dba application performs a differential, incrementally updated ingest (RMAN incremental level 1) to ingest an Oracle database to an NFS path.
Note:
This topic does not apply to using NetBackup to ingest databases.
On the first ingest of an Oracle database, Velocity performs an image copy backup of the database. On subsequent ingests of the same database, Velocity backs up only changed data blocks from individual database pages. These incremental changes are rolled forward and merged into the data files on the NFS mount path on the Velocity Storage Server. The first backup that runs with the full parameter is a full backup, and all subsequent backups are level 1 incrementals. To see all available parameters for the ingest_dba application, use the -h parameter to view the help.
Velocity also provides an automated method to ingest databases.
See How to provide copies of Oracle databases for sandboxes in Velocity.
Note:
In an ASM environment, the ingest_dba application automatically detects databases on ASM storage, dynamically creates the destination ASM disk group, and mounts it in the local ASM instance.
When you run the script, the database can be in either an open state or a mounted state.
Databases that are ingested are listed on the Database Sources window on the Velocity Console.
Table: What to do before you use the command line to ingest a database
Before you run the ingest_dba application, review the following options: | More information |
|---|---|
Review the best practices for improving the performance of the Velocity ingest process. | See Improving the performance of Veritas Velocity for Oracle Database. |
Decide if you want to customize the You can edit the default options in the | See Editing default options for the ingest method for Oracle databases. |
To ingest from an Oracle database that is hosted on ASM to a regular file system that is hosted on the Velocity Storage Server, you must set the 'StorageType' option to 'FS' in the If you use the ingest method on the Velocity Console, then you must save the ingest without running it, set the 'StorageType' Option to 'FS', and then run the ingest. | See Editing default options for the ingest method for Oracle databases. |
Decide if you want to use a custom parameter file to control the startup behavior of a sandbox. When a database is ingested to Velocity, the custom parameter file is stored with the database copy. Then, the custom parameter file is automatically applied to a sandbox when it is created from the database copy. | See About setting custom initialization parameters for a sandbox for an Oracle database copy. |
You must do the following before you run the application:
Ensure that the Velocity Storage Server is registered with the Velocity Console.
Ensure that the Velocity Client is configured.
To run the application, you must have the following rights and assignments:
On the host Oracle Database server:
You must be an
oracleuser who belongs to theoinstallgroup and thedbagroup.When the Oracle DBA ingests an Oracle database that uses ASM storage, the DBA must be part of the Oracle Grid Infrastructure user group. Otherwise, the
ingest_dbaapplication prompts you to enter the password for the Oracle Grid Infrastructure user when the destination ASM disk group is created, mounted, and dismounted.
In Velocity, you must have at least a DBA role.
Note:
Refer to your Oracle documentation for best practices on how to configure backups for an Oracle RAC environment.
To ingest an Oracle database into Velocity by using the command line
- From the Velocity Console, in the left pane, click Database Sources.
- On the Database Sources dialog, click +, and then click Add Database to Ingest.
- On the Choose Method dialog, select whether you want to use Velocity or NetBackup to ingest this database source.
- On the Add a Database Source dialog, enter the hostname or IP address of the Oracle database server that hosts the database that you want to add to Velocity.
- Click + to add the hostname or IP address to the Added Hosts list.
- To specify a database in a RAC environment, enter each node name or IP address one at a time. Then, click + to add each node to the Added Hosts list.
- (Optional) For the option Enable Copy Preparation, click Yes if you want to change data in a database before users can access the database copies from their sandboxes.
- Enter the name of the Oracle database that you want to add to Velocity.
- (Optional) Enter a name for the Oracle database that is meaningful or easy to remember.
- (Optional) Enter a description of the Oracle database that is meaningful or easy to remember.
- Click Save to save the database information that you added and return to the Database Sources window without starting the ingest process.
- On the Oracle host server, log in as an
oracleuser who belongs to theoinstallgroup and thedbagroup. - Type the following command to change the directory to the NFS mount path on the Oracle Server:
cd /<NFS mount path>
Where NFS mount path is the path name that displays in the Database Source Details dialog.
To find the NFS mount path, on the Velocity Console, in the left pane, click Database Sources, select the database source that you want to ingest, and then click Details.
- Type one of the following commands to run the ingest application:
To run the default for the first ingest and for all subsequent ingests
/tools/bin/ingest_dba
To start a full backup
/tools/bin/ingest_dba --full
Note:
If necessary, you can cancel an ingest process after you have started it.
- If you are prompted, enter the Oracle Grid Infrastructure user password.
After the application has run, to view the database that was ingested into Velocity, sign in to the Velocity Console, and then in the left pane, click Database Sources.