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
- linked a dSource from a source database, as described in Linking an Oracle Data Source
- 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
- 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, 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 Camera icon.
Optional: Select
to open LogSync timeline.Select
to provision from a point of time within a snapshot. You can select by date or time.- Click
- 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)
Database Unique Name
SID
Database Name
Mount Base
Instance Number (RAC Only)
Instance Name (RAC Only)
and the Provision VDB wizard will open: - 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 .
- 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 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. - 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, or custom environment variables.
For more information, see Customizing Oracle VDB Configuration Settings, Customizing 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 forSGA_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 target host reboot is detected by Delphix.
- Click Next.
- Select a Snapshot Policy for the VDB.
- Click Next.
- Enter any operations that should be run at Hooks during the provisioning process.
For more information, see Customizing Oracle Management with Hook Operations. - 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.
Provisioning by Snapshot or LogSync
Provisioning By Snapshot | Description |
---|---|
Provision by Time | You 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 SCN | To 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 Time | Select 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 SCN | Select 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:
- Click the group containing the VDB.
- Click the VDB.
- Disable the VDB in order to make changes to instance configuration.
- Under Configuration > Source click the edit button and edit the following:
- Instance Number for each corresponding instance
- Instance Name
- Check or uncheck the cluster nodes you want for this RAC VDB
- Click the check button to save changes.
- Enable the VDB to apply the the instance configuration changes.