Search <book_title>...

Veritas Velocity™ User's Guide

Last Published: 2017-11-28

Product(s): Velocity (2.8)

Getting to know Velocity
1. Introducing Velocity
2. How to access the Velocity Cloud Console
3. About the Velocity Appliance
4. About the Velocity Storage Server administration interfaces
5. Using the Velocity shell menu
Setting up Velocity
1. Velocity administrator's checklist for setting up Veritas Velocity
2. Database administrator's checklist for setting up Veritas Velocity
3. Sandbox user's checklist for setting up Veritas Velocity
4. How to set up the Velocity Storage Server
5. How to set up the Velocity Client
6. Deleting a Velocity Client
7. Configuring a proxy server for Velocity
8. Required and optional ports for Velocity
9. Installing the NetBackup Client on the Velocity Storage Server
Setting up the Velocity on-premises management server
1. How to set up the Velocity on-premises management server
2. Deploying the Velocity on-premises management server image on a virtual machine
3. Configuring the network settings for the Velocity on-premises management server
4. Configuring Active Directory/LDAP settings on the Velocity on-premises management server
5. Adding users to the Velocity on-premises management server
Upgrading Velocity
1. How to upgrade to Velocity version 2.8
2. Finding the Velocity Storage Server and Velocity Client version numbers
3. Downloading and transferring software updates to the Velocity Storage Server
4. Removing previous upgrade files
5. Upgrading the Velocity Storage Server
6. Upgrading the Velocity Client for Linux
7. Upgrading the Velocity Client for Windows
8. Upgrading the Velocity Client for Solaris
Velocity Storage Server
1. About the Velocity Storage Server
2. Viewing physical storage usage on the Velocity Storage Server
3. About reclaiming storage space on the Veritas Velocity Storage Server
4. Increasing meta and data storage capacity on the Velocity Storage Server
5. Deregistering a Velocity Storage Server
6. How to reset the Velocity Storage Server
Users and roles
1. How to configure users and roles in Velocity
2. Adding users
3. Role-based access control
4. Adding roles
5. Deleting roles
6. Viewing details about all users and roles
7. Assigning users to an existing role
8. Removing users from a role
9. Changing the database sources that are assigned to a role
Oracle database ingestion using Velocity
1. How to provide copies of Oracle databases for sandboxes in Velocity
2. Adding an Oracle database to ingest into Velocity
3. Ingesting an Oracle database into Velocity for the first time
4. Ingesting an Oracle database again after the first ingest
5. Canceling an Oracle database ingestion
6. How to use copy preparation to mask or sanitize sensitive data
7. Ingesting an Oracle database into Velocity from the command line
8. About setting custom initialization parameters for a sandbox for an Oracle database copy
9. Editing default options for the ingest method for Oracle databases
Oracle database ingestion using NetBackup CoPilot
1. How to set up NetBackup CoPilot to ingest Oracle databases into Velocity
2. Ingesting an Oracle database with NetBackup CoPilot
Microsoft SQL Server database ingestion using Velocity
1. How to provide copies of SQL Server databases for sandboxes in Velocity
2. Adding a SQL Server database to ingest into Velocity
3. Ingesting a SQL Server database into Velocity
4. Editing default options for SQL Server database ingestion
5. Canceling a SQL Server database ingestion
Database sources and copies
1. About database sources and copies
2. Viewing details of an Oracle database source
3. Viewing details of a SQL Server database source
4. Changing the nickname or description of a database source
5. Deleting a database source from Velocity
6. About scheduling ingestions for a database source
7. Retention periods for database sources and copies
8. Viewing database copies
9. Viewing the number of sandboxes that were created from a database copy
10. Viewing the status of database copies
11. Deleting database copies
Sandboxes
1. About sandboxes
2. Creating a sandbox from an Oracle database copy
3. Starting an Oracle database instance manually
4. Creating a sandbox from a SQL Server database copy
5. Starting a SQL database manually
6. Finding your sandbox
7. Viewing details about your sandboxes
8. Deleting a sandbox
9. Managing sandboxes when you restart the host Oracle Database server
10. Unmounting a sandbox from an Oracle host server
Database recovery
1. Recovering an Oracle database
Alerts and logs
1. Viewing alerts
2. Creating audit log reports
3. Redirecting the syslog messages
4. Viewing the syslog messages on a Red Hat Enterprise Linux computer
5. Viewing the syslog messages on a Windows computer
Managing the Velocity physical appliance
1. Configuring network address settings on the Velocity physical appliance
2. About the Veritas Remote Management Console on the Velocity physical appliance
3. About Velocity physical appliance storage
  1. Configuring the storage on the Velocity physical appliance
  2. Viewing the storage on the Velocity physical appliance
4. About users on the Velocity physical appliance
5. About Velocity physical appliance checkpoints
  1. Creating a custom checkpoint on the Velocity physical appliance
  2. Restoring the Velocity physical appliance from a checkpoint
6. About factory reset on the Velocity physical appliance
  1. Restoring the Velocity physical appliance to a factory state
Monitoring the Velocity physical appliance
1. About Veritas AutoSupport on the Velocity physical appliance
  1. Setting up AutoSupport on the Velocity physical appliance
2. Setting up email notifications on the Velocity physical appliance
3. Setting up SNMP notifications on the Velocity physical appliance
4. Auditing the SDCS logs on the Velocity physical appliance
  1. About SDCS event type codes and severity codes on the Velocity physical appliance
  2. Changing the SDCS log retention settings on the Velocity physical appliance
5. Testing the Velocity physical appliance hardware
Velocity physical appliance security
1. About Velocity physical appliance user account privileges
  1. Velocity physical appliance user name and password specifications
    1. Password encryption and handling on the Velocity physical appliance
2. About the Velocity physical appliance intrusion detection system
  1. Reviewing SDCS events on the Velocity physical appliance
3. About Velocity physical appliance operating system security
  1. Vulnerability scanning of the Velocity physical appliance
  2. Disabled service accounts on the Velocity physical appliance
4. About data security on the Velocity physical appliance
5. About data integrity on the Velocity physical appliance
6. About the Velocity physical appliance ports
7. Recommended IPMI settings on the Velocity physical appliance
  1. Replacing the default IPMI SSL certificate on the physical appliance
Best practices
1. Improving the performance of Veritas Velocity for Oracle Database
2. Stopping and starting all mounts
3. Protecting the Velocity on-premises management server
Troubleshooting
1. NFS export paths where ingested Oracle Database sources are stored are inaccessible
2. NFS export path is not created during a database ingestion
3. Database ingestion fails with the Oracle error 'diskgroup {xx} space exhausted'
4. After restart of the vpfsd service, links to the applications are broken
5. Sandbox creation fails on an Oracle Database server
6. Sandbox creation fails for a SQL Server database copy
7. Sandbox creation fails after you use the --adGroups argument when you configure the Velocity Client for Windows
8. Sandbox creation may take longer than usual on Oracle Database 12c
9. A sandbox cannot be deleted from an Oracle Database server because the mount point is busy
10. Error occurs when registering the Velocity Client; provide the Oracle DBA with access to the Velocity registration files
11. Error occurs when a new sandbox name has the same name as a deleted sandbox
12. Ingestions and sandboxes are stuck 'In Progress' after the Velocity Storage Server is restarted
Glossary
1. Glossary terms for Velocity
Context-sensitive topics
1. Create Sandbox - Choose Database
2. Create Sandbox - Configure Host
3. Create Sandbox - Review Settings
4. Create Sandbox - Choose Database
5. Create Sandbox - Configure Host
6. Create Sandbox - Review Settings
7. Sandboxes window
8. Sandbox details
9. Sandbox details for an Oracle database copy
10. Sandbox details for a SQL Server database copy
11. Role Wizard - Select User Type
12. Role Wizard - Select Users
13. Role Wizard - Select Sources
14. Role Wizard - Review
15. Copies dialog
16. Database source details
17. Database Sources dialog
18. How to set up the Velocity Client
19. Schedule dialog
Section I. Velocity shell menu commands
1. Introduction
  1. About Velocity commands
2. Appendix A. Main > Manage > Storage
  1. Manage > Storage > Configure
  2. Manage > Storage > Show
3. Appendix B. Main > Manage > Cloud
  1. Main > Manage > Cloud
4. Appendix C. Main > Manage > Software
5. Appendix D. Main > Monitor
6. Appendix E. Main > Network
7. Appendix F. Main > Settings
8. Appendix G. Main > Support

Masking sensitive data manually in database copies

When you enable copy preparation for an Oracle database source, you can mask or sanitize the data manually in the ingested database before sandbox users can access the database copies. Masking or sanitizing the data lets you hide the real data but still provide usable data for test and development purposes. For example, you may want to remove any personal data or sensitive data and insert test data instead.

To mask sensitive data in database copies manually

From the Velocity Cloud Console, in the left pane, click Database Sources.
Click +, and then click Add Database to Ingest.
Select Ingest Oracle to ingest an Oracle database source into Velocity, select whether you want to use Velocity or NetBackup to ingest this database source, and then click Next.
Enter the hostname or IP address of the Oracle database server that you want to add to Velocity.
Click + to add the server name or IP address to the Added Hosts list.
(Optional) 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.
For the option Enable Copy Preparation, click Yes.
Enter the name of the Oracle database that you want to add to Velocity as a source.
Note:
The database name must start with a letter, can contain only letters, numbers, underscores (_), number signs (#), and dollar signs ($), and cannot exceed 30 characters. Refer to your Oracle documentation for other database name requirements.
(Optional) Enter a user-friendly name for the configured ingest job.
(Optional) Enter a description of the Oracle database that is meaningful to you or makes it easy to remember.
(Optional) Enter an NFS mount path, if you do not want to use the default path.
The NFS mount path is the path on the host server where the NFS share is mounted. The default path is /mnt/velocity.
Click Next.
(Optional) To create a recurring schedule for the ingestion, configure the scheduling options, and then click Next.
If you do not want to create a recurring schedule, click Skip.
Note:
You may have to upgrade your Velocity Storage Server to enable scheduling.
See Upgrading the Velocity Storage Server .
(Optional) Select the amount of time you want to retain this database source and all of its subsequent copies.
Note:
After the retention period ends, this database source and all of its copies are removed from the Velocity Storage Server.
See Retention periods for database sources and copies.
If you want to save this database source and its subsequent copies indefinitely, click Skip.
Click Ingest.
To create a sandbox, from the Velocity Cloud Console, in the left pane, click Sandboxes, and then click +.
Select the database for which you enabled copy preparation. By default, Velocity selects the most recent copy of the database that you selected. However, you can browse for older database copies. The date of the selected database copy is circled and highlighted on the calendar.
Click Next.
Enter the information as prompted to create the sandbox. Use the IP address of the secure server on which you want to run your data preparation tools.
See Creating a sandbox from an Oracle database copy.
Note:
The Velocity Client must be configured on the server on which you want to create a sandbox.
See Configuring the Velocity Client for Linux.
Use your data preparation tools to mask or sanitize the data.
After you have changed the data, on the NFS mount path for the sandbox for the database copy, run the following snapshot application:
/tools/scripts/sandbox snapshot
After the snapshot application has completed, type the following command to restart the sandbox:
/tools/scripts/sandbox start
A new database copy with the masked data is available to sandbox users, in Sandboxes. The sandbox users who have access to the database source can create a sandbox from the database copy with the masked or sanitized data.
(Optional) If you make changes to the database copy in the sandbox, run the snapshot application again to make a new copy of the database copy.
Sandbox users can then create a sandbox from the new database copy that contains changes.
The Copy Preparation Date displays the date and time that a copy of the database copy was created.

See How to use copy preparation to mask or sanitize sensitive data.