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.
If you want to invoke Datapatch for the VDB, you will need to grant the environment user used for this provision correct sudo privileges on the target environment, as described in Sudo Privilege Requirements for Oracle Environments.
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.
Once a VDB has been provisioned, archive logs, flashback logs, redo logs, and datafiles that are not known to be part of the database will be deleted when a SnapSync is performed on the VDB. As a result, make sure that no files are added to the datafile file system, as this is used by Delphix to store datafiles. Use the external filesystem for other files that are needed to be included in the snapshot that are not datafiles.
For example, creating a second control file on the datafile filesystem is prohibited. Such a file will be removed after SnapSync, rendering the VDB unusable. Similarly, block change tracking must not be enabled on a VDB.
Procedure
Login to the Delphix Management application.
Select Manage > Datasets.
In the Datasets panel on the left-hand side, click the group containing the dSource or VDB from which you want to provision.
Click the TimeFlow tab.
Select a snapshot. For more information on provisioning options.
Info : You can take a snapshot of the dSource from which to provision. To do so, click the Camera icon.
Optional: Selectto open LogSync timeline.
Select to provision from a point of time within a snapshot. You can select by date or time.
Clickand the Provision VDBwizard will open:
For Oracle Single Instance the fields Installation Home, Database Unique Name, SID, Database Name, Mount Base, and Environment User will auto-populate with information from the parent.
For Oracle RAC the fields Installation Home, Database Unique Name, SID, Database Name, Mount 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)
Review the information for Installation Home, Database Unique Name, SID, and Database Name. Edit as necessary.
Review the Mount Base and Environment User. Edit as necessary.
The Environment User must have permission 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.
Linux and Unix hosts, this mount path must be the full path and not include symlinks.
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.
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, patching, or custom 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.
Click Next.
Select a Target Group for the VDB.
Enable Auto VDB Restart to allow the VDB to be automatically restarted when the target host reboot is detected by Delphix.
The Auto VDB Restart feature is currently not available for Pluggable Databases, Clusters, or LiveSource.
Click Next.
Select a Snapshot Policy for the VDB.
Click Next.
Enter any operations that should be run at Hooks during the provisioning process.
Click Next.
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.