Templates vs. Individual Settings (GUI and CLI)
Both the CLI and the GUI allow setting parameters at Provisioning time, either through Templates or by individually setting parameters using name value pairs.
You can only use one or the other. It is not possible to mix and match Templates and Individual Settings.
However, the method of enforcing this restriction varies between the GUI and the CLI.
Whereas the CLI will issue an error, the GUI allows you to copy Template settings and add, remove, and modify settings.
In the GUI, VDB parameters are set by clicking the Advanced link in the Target Environment screen during Provisioning.
- You can choose a Template and Provision. In this case, the VDB will have a reference to the Template.
- You can choose to add parameters as name value pairs. In this case, the VDB will not reference a Template.
- You can choose a Template and then add or modify parameters. In this case, the VDB will not reference a Template! Rather, the values from the template are copied, just as if you had individually typed them in.
In the CLI, VDB parameters are defined by setting either
configParams under the
- You can choose a Template by setting
- You can choose to add parameters as name value pairs using
- Attempting to do both operations at the same time produces an error that the two are mutually exclusive. There is no way to duplicate the GUI functionality (copying the Template values) in the CLI, but you can achieve this with a simple program by extracting the values from the
templateobject, located under the
Determining whether or not a VDB is referencing a Template
In the GUI, flip the VDB card and look at the value for Template. If it says Default, there is no Template reference.
In the CLI,
cd source and
select your source. Then
get configTemplate. If it says
(unset) there is no Template reference.
Changing a VDB to reference a Template after provisioning
In the GUI, flip the VDB card and modify the value for Template.
In the CLI,
cd source and
select your source. Then
It is not possible to undo this operation and go back to not using a Template!
To undo the reference to a Template, as a workaround you can provision a VDB from the VDB to preserve your data while resetting your parameter configuration.
Changing a Template after Provisioning: effect on VDBs
When you change a Template, existing VDBs are never immediately affected.
When you change a Template, any VDB which has a reference to that template will be affected during it's next Refresh or Rewind operation. The new template settings will take affect.
Any parameter changes made after provisioning (ex:
alter system set open_cursors=new_value), but not made to the Template, will be overridden during Refresh/Rewind. Therefore, for VDBs referencing a Template, in addition to ALTER SYSTEM, Delphix recommends updating VDB Config Templates with new parameter values if you wish to preserve those values for future Refresh/Rewind operations.
Changing parameters after Provisioning: effect on VDBs (CLI only)
You can change the database parameters within Delphix after Provisioning, using the CLI.
To make changes,
cd source and
select your source. Choose to
set configParams.<name>=<value> and
$ ssh email@example.com Password: nstack516.acme> source nstack516.acme source> select Vsrc_6D9 nstack516.acme source 'Vsrc_6D9'> update nstack516.acme source 'Vsrc_6D9' update *> set configParams.au audit_sys_operations audit_trail nstack516.acme source 'Vsrc_6D9' update *> set configParams.audit_trail="db, extended" nstack516.acme source 'Vsrc_6D9' update *> commit nstack516.acme source 'Vsrc_6D9'> ls Properties type: OracleVirtualSource name: Vsrc_6D9 allowAutoVDBRestartOnHostReboot: false archivelogMode: true config: Vsrc_6D9 configParams: _omf: 'ENABLED' audit_sys_operations: FALSE audit_trail: db, extended compatible: '18.104.22.168.0' filesystemio_options: 'setall' log_archive_dest_1: 'location=/mnt/provision/Vsrc_6D9/archive/ MANDATORY' log_archive_format: '%t_%s_%r.dbf' memory_target: 1073741824 open_cursors: 300 processes: 150 remote_login_passwordfile: 'EXCLUSIVE' ...etc...
Like changing a Template after Provisioning, this has no immediate effect on VDBs.
Rather, the change will take effect during the next Refresh or Rewind operation. As with a Template, any parameter changes made after provisioning (ex:
alter system set open_cursors=new_value) will be overridden. Therefore, for VDBs which don't reference a Template, in addition to ALTER SYSTEM, Delphix recommends updating
configParams with new parameter values if you plan to preserve those values for future Refresh/Rewind operations.
The effect of SnapSync on VDB Parameters (only for non-Template based VDBs)
For a VDB which is not referencing a Template, when Delphix performs SnapSync, parameters will be examined and automatically added to the
configParams. These parameters will be retained through Refresh/Rewind operations. This can be a valuable shortcut.
Types of Parameters
Delphix divides parameters into three different sets: Inherited, Defaulted, and Restricted.
You can customize Inherited and Defaulted parameters. You cannot customize Restricted parameters.
Inherited Parameters take their value from the source database. Delphix allows for these parameters to be customized to your specific needs either with Templates or through individual settings.
The vast majority of parameters are Inherited Parameters. Unless a parameters is Defaulted or Restricted, it is Inherited.
Example Inherited Parameters:
Defaulted Parameters do not take their default from the source database. These parameters are usually only applicable for a specific database, and it would be incorrect to copy the values from the source database to the VDB.
These parameters will be unset, so they will default to the Oracle default values. However, you can set these values using a VDB Config Template or by using individual settings.
Example Defaulted Parameters:
For the complete list of Defaulted Parameters see Customizing Oracle VDB Configuration Settings.
These parameters are restricted for use by the Delphix Engine, and are usually derived from the provisioning wizard or the storage mount point location. Attempting to customize these parameters through the use of a VDB Configuration Template will cause an error when you attempt to update the Template. Attempting to customize these parameters through individual settings will cause an error during the provisioning process.
Example Restricted Parameters:
For the complete list of restricted parameters see Customizing Oracle VDB Configuration Settings.
VDB Provision and init Parameters
When a VDB is provisioned Delphix will use your custom settings from a VDB Config Template or individual settings, except for Restricted parameters.
For any other settings, if the parameter is of type Defaulted, these values will be left unset, and will become the Oracle default. If the parameter is not Restricted or Defaulted, its value is Inherited from the source database as of the time of the Snapsync card which you use for Provisioning.
If you use a Template, the VDB will retain a reference to the Template.
Note that if you use a Template in the GUI, but you add/remove parameters or modify values, your VDB will not have a reference to the Template. Rather, the GUI will copy the parameter name value pairs from the Template and treat them as if they were individually set.
By adding an empty parameter (simply click the add button but don't fill in anything), you can have the GUI copy your Template parameters but not have a reference to the template.
This trick allows you to leverage Templates for easy configuration, while keeping your VDBs unaffected by Template changes made after they are Provisioned.
In addition, you can make parameter changes in the CLI which will be retained through Refresh/Rewind operations, without having to modify your Template.
Modifying Parameters for an Active VDB
To modify a parameter after provisioning, use the Oracle command
ALTER SYSTEM SET <PARAMETER>=<VALUE> SCOPE=BOTH [SID=<VALUE>].
This will set the value both in memory and in the spfile.
Once set, these parameters will remain through stop and start operations, because they are in the spfile.
However, they will not stay in effect when performing the Delphix operations Refresh and Rewind unless you also modify either the Template or the
For VDBs which reference a Template, you modify the Template. For VDBs which don't reference a Template, you modify
configParams with the CLI.
VDB Refresh/Rewind and init Parameters
During Refresh/Rewind operations, Delphix resets the VDB init parameters in the spfile and in memory, to either Template values or the
configParams values shown in the CLI.
If you have made changes only to the VDB, even in the spfile, these changes will be lost. To preserve your changes, you must take additional action:
- If your VDB references a Template, change the Template values. Note that this will affect all VDBs referencing that Template, and new VDBs Provisioned with the Template.
- If your VDB does not reference a Template, change the
configParamsin the CLI. You can shortcut this with ALTER SYSTEM commands, followed by a SnapSync.