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


Prerequisites

  • You must have already done one of the following:
    •  linked a dSource from a source database, as described in Linking an Oracle Data Source
      or
    • 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.

Procedure

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

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

  6. Optional: Selectto open LogSync timeline.

  7. Select to provision from a point of time within a snapshot. You can select by date or time.

  8. Click  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 BaseInstance 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

      SID

      Database Name

      Mount Base

      Instance Number (RAC Only)

      Instance Name (RAC Only)

  9. 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.
  10. Review the information for Installation HomeDatabase Unique NameSID, and Database Name. Edit as necessary.
  11. 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.
  12. 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.
  13. 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  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.

  14. Click Next.
  15. Select a Target Group for the VDB.
  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. Select a Snapshot Policy for the VDB.
  19. Click Next.
  20. Enter any operations that should be run at Hooks during the provisioning process.
    For more information, see Customizing Oracle Management with Hook Operations.
  21. Click Next.
  22. Click Submit.

When provisioning starts, you can review the 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
Description
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 SCNTo open the SCN entry field select the Actions (...) menu for your selected snapshot and select View by SCN. 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, select Open LogSync from the Actions (...) menu.

Provisioning By LogSync
Description
Provision by TimeSelect Open LogSync control to view the time range within that snapshot. Select the clock icon and then select Time to the point to the time from which you want to provision. You can also enter a date and time directly.
Provision by SCNSelect View SCN to view the range of SCNs within that snapshot. 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

Prerequisites

  • Disable the VDB before you edit the instance configuration.

Procedure

After provisioning:

  1. Click the group containing the VDB.
  2. Click the VDB.
  3. Disable the VDB in order to make changes to instance configuration.
  4. Under Configuration > Source 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
  5. Click the check button to save changes.
  6. Enable the VDB to apply the the instance configuration changes.

Related Links