This topic describes how to provision a virtual database (VDB) from a dSource or another VDB.


  • You must have already done one of the following:
    •  linked a dSource from a source database, as described in Linking an Oracle Data Source
    • created a VDB from which you want to provision another VDB
  • You will need to have the correct OS User privileges on the target environment, as described in Requirements for Oracle Target Hosts and Databases.
  • If you want to use customized database configuration settings, first create a VDB Config Template as described in Customizing Oracle VDB Configuration Settings.
  • If you are creating a VDB from a dSource linked to an encrypted database, make sure you have copied the wallet file to the target environment, as described in Provisioning a VDB from an Encrypted Oracle Database.

VDB Configuration Templates

It is recommended that you always create a VDB Configuration Template prior to provisioning a Virtual Database. This will allow you to customize your parameters for the initial provisioning, and ensure that subsequent changes are reflected on the VDB when refresh and rewind operations are run. See Customizing Oracle VDB Configuration Settings for more information.


  1. Login to the Delphix Admin application.
  2. In the Datasets panel on the left-hand side, click the group containing the dSource or VDB from which you want to provision.
  3. Click the Object.
  4. Click the TimeFlow tab.
  5. Select a  snapshot.
    For more information on provisioning options, see Provisioning by Snapshot and LogSync in this topic.

    You can take a snapshot of the dSource from which to provision. To do so, click the  Configuration tab and click the  Camera  icon.

  6. Optional: Slide the LogSync slider to open the snapshot timeline, and then move the arrow along the timeline to provision from a point of time within a snapshot.

    You can provision from the most recent log entry by opening the snapshot timeline, and then clicking the red Arrow icon next to the LogSync Slider.

  7. Click Provision and the Provision VDB wizard will open:
    1. For Oracle Single Instance the fields Installation HomeDatabase Unique NameSIDDatabase NameMount Base, and Environment User will auto-populate with information from the parent.
    2. For Oracle RAC the fields Installation HomeDatabase Unique NameSIDDatabase NameMount Base, Instance Number, Instance Name and Environment User will auto-populate with information from the parent.

      Editable Fields in the VDB Provision Wizard

      The following fields are editable:

      Installation Home (need to have an additional compatible target)

      Database Unique Name


      Database Name

      Mount Base

      Instance Number (RAC Only)

      Instance Name (RAC Only)

  8. If you need to add a new target environment for the VDB, click the green Plus icon next to the Filter Target field, and follow the instructions in Adding an Oracle Single Instance or RAC Environment.
  9. Review the information for Installation HomeDatabase Unique NameSID, and Database Name. Edit as necessary.
  10. Review the Mount Base and Environment User. Edit as necessary.
    The Environment User must have permissions to write to the specified Mount Base, as described in Requirements for Oracle Target Hosts and Databases. You may also want to create a new writeable directory in the target environment with the correct permissions and use that as the Mount Base for the VDB.
  11. Select Provide Privileged Credentials if you want to use login credentials on the target environment that are different from those associated with the Environment User.
  12. Click Advanced to customize the VDB online log size and log groups, archivelog mode, local_listener parameter (TCP/IPC protocol addresses), additional VDB configuration settings or file mappings, or custom environment variables.
    For more information, see 2017-07-05_21-10-44_Customizing VDB online redo logs, Customizing Oracle VDB Configuration SettingsCustomizing VDB File Mappings, and Customizing Oracle VDB Environment Variables.


    If you are provisioning to a target environment that is running a Linux OS, you will need to compare the SGA_TARGET configuration parameter with the shared memory size in /dev/shm. The shared memory configured on the target host should match the SGA memory target. You can check the Linux OS shared memory size with the command  df-k /dev/shm and the SGA_TARGET  configuration parameter by opening the Advanced settings, and then finding the value for SGA_TARGET under VDB Configuration Templates.

  13. Click Next.
  14. Select a Target Group for the VDB.
    If necessary, click the green Plus icon to add a new group.
  15. Select a Snapshot Policy for the VDB.
    If necessary, click the green Plus icon to create a new policy.
  16. Enable Auto VDB Restart to allow the VDB to be automatically restarted when target host reboot is detected by Delphix.
  17. Click  Next .
  18. Enter any operations that should be run at Hooks during the provisioning process.
    For more information, see Customizing Oracle Management with Hook Operations.
  19. Click Next.
  20. Click Finish.

When provisioning starts, you can review progress of the job by selecting the VDB and clicking on the Status tab, or by selecting Manage/Dashboards and viewing the Job History panel. Alternatively you could see this in the Actions Sidebar.  When provisioning is complete, the VDB will be included in the group you designated and listed in the  Datasets panel. If you select the VDB in the  Datasets panel and click the Configuration tab, you can view information about the database and its Data Management settings.

Provisioning by Snapshot or LogSync

When provisioning by snapshot, you can provision to the start of any particular snapshot, either by time or SCN.
Provisioning By Snapshot
Provision by TimeYou can provision to the start of any snapshot by selecting that snapshot card from the TimeFlow view or by entering a value in the time entry fields below the snapshot cards. The values you enter will snap to the beginning of the nearest snapshot.
Provision by SCNYou can use the Slide to Provision by SCN control to open the SCN entry field. Here, you can type or paste in the SCN to which you want to provision. After entering a value, it will "snap" to the start of the closest appropriate snapshot.

When provisioning by LogSync information, you can provision to any point in time, or to any SCN, within a particular snapshot. The TimeFlow view for a dSource shows multiple snapshots by default. To view the LogSync data for an individual snapshot, use the Slide to Open LogSync control at the top of an individual snapshot card.

Provisioning By LogSync
Provision by TimeUse the Slide to Open LogSync control to view the time range within that snapshot. Drag the red triangle to the point in time from which you want to provision. You can also enter a date and time directly.
Provision by SCNUse the Slide to Open LogSync and Slide to Provision by SCN controls to view the range of SCNs within that snapshot. Drag the red triangle to the LSN from which you want to provision. You can also type or paste in the specific SCN to which you want to provision. Note that if the SCN does not exist, you will see an error when you provision.

Adding or Removing RAC VDB Cluster Node After a VDB is Provisioned


  • Disable the VDB before you edit the instance configuration.


After provisioning:

  1. Click the group containing the VDB.
  2. Click the VDB.
  3. Click the Configuration tab.
  4. Disable the VDB in order to make changes to instance configuration.
  5. Under Source Instances click the edit button  and edit the following: 
    1. Instance Number for each corresponding instance   
    2. Instance Name 
    3. Check or uncheck the cluster nodes you want for this RAC VDB

    Adding/Removing RAC VDB Cluster

  6. Click the check button to save changes.
  7. Enable the VDB to apply the the instance configuration changes.

Related Links