Searching...
Filters
SmallMediumLarge
Home Print Show Topic URL Previous Next

Creating a sandbox from an Oracle database copy

Velocity Help

You can create a sandbox whenever you want a different database copy, or when you want to refresh a database copy.

The database files for the database copy are stored on the Velocity Storage Server, on an NFS export path. When you specify an Oracle Database server as the sandbox host, the sandbox is automatically mounted as an NFS share on that Oracle Database server. Then, the Oracle software can access the database files in the NFS export path and create and start the database for the sandbox.

You are prompted to provide the following information:

  • The time and date of the database copy that you want to use in the sandbox.

  • The Oracle Database server that you want to access the sandbox.

  • Optional configuration details for the sandbox.

Requirements

Ensure that the following prerequisites are set up before you create a sandbox:

  • The Velocity Client is configured on the host Oracle Database server.

    See Configuring the Velocity Client for Linux

  • The Oracle host server is running a supported configuration.

    See the Velocity Software Compatibility List at the following URL:

    https://www.veritas.com/support/en_US/article.000125365

  • Before you create a sandbox, ensure that the host Oracle Database server has any required patches.

  • You must create a sandbox on a host server on which a version of Oracle is installed that is the same as the ingested database. Alternatively, to use an existing Oracle home from this host, enter it in the Custom Oracle Home Path field when you create the sandbox.

To create a sandbox from an Oracle database copy

  1. From the Velocity Console, in the left pane, click Sandboxes, and then on the Sandboxes dialog, click +.

  2. On the Choose Database dialog, do one of the following:

    To get the latest database copy

    Select a database.

    To choose a specific date and time of a database copy

    Select a database, click the down arrow, and then select a date and time from the calendar.

    The following icon indicates that the database copy contains test data instead of production data:

    DataPrepIcon.png

  3. Click Next.

  4. On the Configure Host dialog, specify the details of the Oracle Database server that you want to host the sandbox:

  5. Click Next.

  6. On the Review Settings dialog, ensure that your selections are correct, and then click Create.

    After the sandbox is successfully created, you can start using the database copy from your sandbox.